<br />
<table align="center">
<tr>
<td>
<fieldset>
<legend>
<h2>
Designation Form</h2>
</legend>
<table>
<tr>
<td>
<asp:Label ID="Label2" runat="server" Text="Department Name"></asp:Label>
</td>
<td>
<asp:DropDownList ID="ddlDepartName" runat="server" Width="200px" AutoPostBack="True"
OnSelectedIndexChanged="ddlDepartName_SelectedIndexChanged">
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label3" runat="server" Text="Office Name" Width="200px"></asp:Label>
</td>
<td>
<asp:DropDownList ID="ddlOfficeName" runat="server" Width="200px" AutoPostBack="True">
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label1" runat="server" Text="Designation ID"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtDesigID" runat="server" Width="200px"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label4" runat="server" Text="Designation Name (Hindi)"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtDesigNameHindi" runat="server" Width="200px" OnTextChanged="txtDesigNameHindi_TextChanged"
AutoPostBack="True"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label5" runat="server" Text="Designation Name (English)"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtDesigNameEng" runat="server" Width="200px"></asp:TextBox>
</td>
</tr>
<tr>
<td align="center" colspan="2">
<asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="btnSubmit_Click" />
<asp:Button ID="btnUpdate" runat="server" OnClick="btnUpdate_Click" Text="Update" />
<asp:Button ID="btnReset" runat="server" Text="Reset" OnClick="btnReset_Click" />
</td>
</tr>
<tr>
<td align="center" colspan="2">
<asp:Label ID="lblStatus" runat="server"></asp:Label>
</td>
</tr>
</table>
<br />
</fieldset>
</td>
</tr>
</table>
<hr />
<table border="1" align="center" class="rounded_corners">
<tr>
<td>
<asp:GridView ID="gdView" runat="server" AutoGenerateColumns="false" DataKeyNames="DesignationID"
class="rounded_corners" AllowPaging="true" PageSize="8"
OnPageIndexChanging="gdView_PageIndexChanging"
onselectedindexchanged="gdView_SelectedIndexChanged">
<Columns>
<asp:BoundField DataField="DepartmentNameHindi" HeaderText="Department Name" />
<asp:BoundField DataField="OfficeNameHindi" HeaderText="Office Name" />
<asp:BoundField DataField="DesignationID" HeaderText="DesignationID" />
<asp:BoundField DataField="DesignationNameHindi" HeaderText="Designation Name" />
<asp:BoundField DataField="DesignationNameEng" HeaderText="Designation Name (English)" />
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="lnkEdit" CommandName="Select" runat="server" ValidationGroup="Non_Validate">Update</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</td>
</tr>
</table>
public void FillDepartName()
{
Query = @"SELECT DepartmentID, DepartmentNameEnglish from Departments";
DataTable dt = SqlHelper.ExecuteDataTable(ConString, CommandType.Text, Query);
ddlDepartName.DataSource = dt;
ddlDepartName.DataValueField = "DepartmentID";
ddlDepartName.DataTextField = "DepartmentNameEnglish";
ddlDepartName.DataBind();
ddlDepartName.Items.Insert(0, new ListItem("-Select Department Name-", "0"));
}
public void FillOffceName()
{
Query = @"SELECT OfficeID, OfficeNameEnglish from Office";
DataTable dt = SqlHelper.ExecuteDataTable(ConString, CommandType.Text, Query);
ddlOfficeName.DataSource = dt;
ddlOfficeName.DataValueField = "OfficeID";
ddlOfficeName.DataTextField = "OfficeNameEnglish";
ddlOfficeName.DataBind();
ddlOfficeName.Items.Insert(0, new ListItem("-Select Office Name-", "0"));
}
public void FillDesignationID()
{
Query = "Select Isnull(MAX(DesignationID),0)+1 as DesignationID from Designation";
DataTable dt = SqlHelper.ExecuteDataTable(ConString, CommandType.Text, Query);
txtDesigID.Text = dt.Rows[0]["DesignationID"].ToString();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
DesignationID = txtDesigID.Text.Trim();
DepartmentName = ddlDepartName.SelectedValue.Trim();
OfficeName = ddlOfficeName.SelectedValue.Trim();
DesignationNameHindi = txtDesigNameHindi.Text.Trim();
DesignationNameEng = txtDesigNameEng.Text.Trim();
UserID = "Jiw";
Operation = "insert";
Locked = "";
Transfered = "";
DateTimeStamp = DateTime.Now.ToString();
SqlParameter[] sp = new SqlParameter[9];
sp[0] = new SqlParameter("@DepartmentID", ddlDepartName.SelectedValue);
sp[1] = new SqlParameter("@OfficeID", ddlOfficeName.SelectedValue);
sp[2] = new SqlParameter("@DesignationNameHindi", txtDesigNameHindi.Text);
sp[3] = new SqlParameter("@DesignationNameEng", txtDesigNameEng.Text);
sp[4] = new SqlParameter("@UserID", UserID);
sp[5] = new SqlParameter("@Operation", Operation);
sp[6] = new SqlParameter("@Transfered", Transfered);
sp[7] = new SqlParameter("@Locked", Locked);
sp[8] = new SqlParameter("@DateTimeStamp", DateTimeStamp);
Query = "Proc_InsertValueInDesignation";
int x = SqlHelper.ExecuteNonQuery(ConString, CommandType.StoredProcedure, Query, sp);
if (x == 1)
{
CommonClass.MessageAlert(this, "डेजिगनेशन का नाम अघतन नही हो पाया है किन्ही कारणवश ");
FillGrid();
ClearAll();
}
else
{
CommonClass.MessageAlert(this, "डेजिगनेशन का नाम अघतन हो गया ");
FillGrid();
ClearAll();
}
}
protected void btnReset_Click(object sender, EventArgs e)
{
ClearAll();
}
public void ClearAll()
{
txtDesigID.Text = string.Empty;
ddlDepartName.SelectedIndex = 0;
ddlOfficeName.SelectedIndex = 0;
txtDesigNameHindi.Text = string.Empty;
txtDesigNameEng.Text = string.Empty;
ddlDepartName.Focus();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
DesignationID = txtDesigID.Text.Trim();
DepartmentName = ddlDepartName.SelectedValue.Trim();
OfficeName = ddlOfficeName.SelectedValue.Trim();
DesignationNameHindi = txtDesigNameHindi.Text.Trim();
DesignationNameEng = txtDesigNameEng.Text.Trim();
//UserID = Session["SessionUserID"].ToString();
UserID = "Jiw";
Operation = "Update";
Locked = "";
Transfered = "";
DateTimeStamp = DateTime.Now.ToString();
SqlParameter[] sp = new SqlParameter[10];
sp[0] = new SqlParameter("@DesignationID", txtDesigID.Text);
sp[1] = new SqlParameter("@DepartmentID", ddlDepartName.SelectedValue);
sp[2] = new SqlParameter("@OfficeID", ddlOfficeName.SelectedValue);
sp[3] = new SqlParameter("@DesignationNameHindi", txtDesigNameHindi.Text);
sp[4] = new SqlParameter("@DesignationNameEng", txtDesigNameEng.Text);
sp[5] = new SqlParameter("@UserID", UserID);
sp[6] = new SqlParameter("@Operation", Operation);
sp[7] = new SqlParameter("@Transfered", Transfered);
sp[8] = new SqlParameter("@Locked", Locked);
sp[9] = new SqlParameter("@DateTimeStamp", DateTimeStamp);
Query = "Proc_UpdateValueInDesignation";
int x = SqlHelper.ExecuteNonQuery(ConString, CommandType.StoredProcedure, Query, sp);
if (x == 1)
{
CommonClass.MessageAlert(this, "डेजिगनेशन का नाम अघतन नही हो पाया है किन्ही कारणवश ");
FillGrid();
ClearAll();
}
else
{
CommonClass.MessageAlert(this, "डेजिगनेशन का नाम अघतन हो गया ");
FillGrid();
ClearAll();
}
btnSubmit.Visible = true;
btnUpdate.Visible = false;
}
protected void ddlDepartmentName_SelectedIndexChanged1(object sender, EventArgs e)
{
if (ddlDepartName.SelectedIndex != 0)
{
Query = "Select OfficeNameHindi,OfficeID from Office where DepartmentID='" + ddlDepartName.SelectedValue + "'";
DataTable dt = SqlHelper.ExecuteDataTable(ConString, CommandType.Text, Query);
ddlOfficeName.DataSource = dt;
ddlOfficeName.DataTextField = "OfficeNameHindi";
ddlOfficeName.DataValueField = "OfficeID";
ddlOfficeName.DataBind();
}
}
public void FillGrid()
{
Query = "Proc Fill Grid Designation";
DataTable dt = SqlHelper.ExecuteDataTable(ConString, CommandType.StoredProcedure, Query);
gdView.DataSource = dt;
gdView.DataBind();
}
//public void lnkEdit_Click(object sender, EventArgs e)
//{
// btnUpdate.Visible = true;
// btnSubmit.Visible = false;
// LinkButton Edit = (LinkButton)sender;
// GridViewRow r = (GridViewRow)Edit.NamingContainer;
// Label DesignationID = (Label)r.FindControl("lblDesignationID");
// Label DepartmentID = (Label)r.FindControl("lblDepartment");
// Label OfficeID = (Label)r.FindControl("lblOffice");
// Label DesignationNameHindi = (Label)r.FindControl("lblDesignationName");
// Label DesignationNameEng = (Label)r.FindControl("lblDesignationNameEng");
// txtDesigID.Text = DesignationID.Text.Trim();
// ddlDepartName.Text = ddlDepartName.SelectedValue.Trim();
// ddlOfficeName.Text = ddlOfficeName.SelectedValue.Trim();
// txtDesigNameHindi.Text = DesignationNameHindi.Text.Trim();
// txtDesigNameEng.Text = DesignationNameEng.Text.Trim();
//}
protected void gdView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gdView.PageIndex = e.NewPageIndex;
FillGrid();
}
protected void ddlDepartName_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlDepartName.SelectedIndex != 0)
{
Query = @"SELECT OfficeID, OfficeNameEnglish from Office where DepartmentID='" + ddlDepartName.SelectedValue + "'";
DataTable dt = SqlHelper.ExecuteDataTable(ConString, CommandType.Text, Query);
ddlOfficeName.DataSource = dt;
ddlOfficeName.DataValueField = "OfficeID";
ddlOfficeName.DataTextField = "OfficeNameEnglish";
ddlOfficeName.DataBind();
ddlOfficeName.Items.Insert(0, new ListItem("-Select Office Name-", "0"));
}
}
protected void txtDesigNameHindi_TextChanged(object sender, EventArgs e)
{
int DepartmentID = Convert.ToInt16(ddlDepartName.SelectedValue);
int OfficeID = Convert.ToInt16(ddlOfficeName.SelectedValue);
string DesignationName = txtDesigNameHindi.Text;
String str = dbcon.Designation_Availablity(DepartmentID, OfficeID, DesignationName);
if (str == "valid")
{
lblStatus.Text = "Designation Already Register";
txtDesigNameHindi.Text = string.Empty;
txtDesigNameHindi.Focus();
}
else if (str != "valid")
{
lblStatus.Text = string.Empty;
txtDesigNameEng.Focus();
}
}
protected void gdView_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = gdView.SelectedRow;
ddlDepartName.Text = ddlDepartName.Items.FindByText(row.Cells[0].Text.Trim()).Value;
ddlDepartName.SelectedIndex = Convert.ToInt16(ddlDepartName.Text);
ddlOfficeName.Text = ddlOfficeName.Items.FindByText(row.Cells[1].Text.Trim()).Value;
ddlOfficeName.SelectedIndex = Convert.ToInt16(ddlOfficeName.Text);
txtDesigID.Text = row.Cells[2].Text.Trim();
txtDesigNameHindi.Text = row.Cells[3].Text.Trim();
txtDesigNameEng.Text = row.Cells[4].Text.Trim();
}
For Edit I want to select the OfficeName before Selecting a Department or any another way to do this