internal Inv_DepartmentType GetDepartmentByDepartmentId(string deparId, string OCODE)
{
int DepId = Convert.ToInt32(deparId);
Inv_DepartmentType dep = _context.Inv_DepartmentType.First(x => x.DepartmentTypeId == DepId);
return(dep);
}
internal int InsertDepartment(Inv_DepartmentType objDepartment)
{
try
{
_context.Inv_DepartmentType.AddObject(objDepartment);
_context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
protected void imgbtnDepartmentEdit_Click(object sender, EventArgs e)
{
Inv_DepartmentType objectDepartment = new Inv_DepartmentType();
ImageButton imgbtn = (ImageButton)sender;
GridViewRow row = (GridViewRow)imgbtn.NamingContainer;
try
{
string deparId = "";
Label lblDepartmentId = (Label)gridviewDepartmetn.Rows[row.RowIndex].FindControl("lblDepartmetn");
if (lblDepartmentId != null)
{
string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
deparId = lblDepartmentId.Text;
objectDepartment = objDept_BLL.GetDepartmentByDepartmentId(deparId, OCODE);
if (objectDepartment != null)
{
hidDepartmentId.Value = objectDepartment.DepartmentTypeId.ToString();
drpdwnResionForDepartment.SelectedValue = objectDepartment.ResionId.ToString();
int resionId = Convert.ToInt32(objectDepartment.ResionId.ToString());
BridOfficeByResion(resionId);
drpdwnOffice.SelectedValue = objectDepartment.Office_ID.ToString();
txtbxDepartemntName.Text = objectDepartment.DPT_NAME.ToString();
txtbxType.Text = objectDepartment.DepartmentType.ToString();
string officeCode = objectDepartment.DPT_CODE.ToString();
string[] occode = officeCode.Split('-');
lblOfficeCode.Text = occode[0] + "-" + occode[1] + "-";
txtbxDepartmentCode.Text = occode[2];
if (btnDepartmentSubmit.Text == "Submit")
{
btnDepartmentSubmit.Text = "Update";
}
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
internal int UpdateDepartment(Inv_DepartmentType objDepartment, int DepartmentId)
{
try
{
Inv_DepartmentType obj = _context.Inv_DepartmentType.First(x => x.DepartmentTypeId == DepartmentId);
obj.DPT_NAME = objDepartment.DPT_NAME;
obj.DPT_CODE = objDepartment.DPT_CODE;
obj.EDIT_USER = objDepartment.EDIT_USER;
obj.EDIT_DATE = objDepartment.EDIT_DATE;
obj.Office_ID = objDepartment.Office_ID;
obj.ResionId = objDepartment.ResionId;
obj.DepartmentType = objDepartment.DepartmentType;
_context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnDepartmentSubmit_Click(object sender, EventArgs e)
{
try
{
if (drpdwnResionForDepartment.SelectedItem.ToString() == "--Select--")
{
// lblMessage.Text = "Please Select Resion!";
// lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Select Resion!')", true);
}
else if (txtbxDepartemntName.Text == "")
{
// lblMessage.Text = "Please Input Department Name!";
// lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input Department Name!')", true);
}
else if (txtbxDepartmentCode.Text == "")
{
// lblMessage.Text = "Please Input Department Code!";
// lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input Department Code!')", true);
}
else if (txtbxDepartmentCode.Text.Length < 3)
{
// lblMessage.Text = "Department Code Minmum Length 3!";
// lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Department Code Minmum Length 3!')", true);
}
else if (txtbxType.Text == "")
{
// lblMessage.Text = "Please Input Department Type!";
// lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input Department Type!')", true);
}
else
{
if (drpdwnOffice.SelectedItem.ToString() == "--Select--")
{
// lblMessage.Text = "Please Select Office";
// lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Select Office')", true);
}
else
{
Inv_DepartmentType objDepartment = new Inv_DepartmentType();
objDepartment.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
objDepartment.EDIT_DATE = DateTime.Now;
objDepartment.OCODE = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode);
objDepartment.Office_ID = Convert.ToInt32(drpdwnOffice.SelectedValue.ToString());
objDepartment.DPT_NAME = txtbxDepartemntName.Text;
objDepartment.DepartmentType = txtbxType.Text;
objDepartment.ResionId = Convert.ToInt32(drpdwnResionForDepartment.SelectedValue.ToString());
string offcode = lblOfficeCode.Text + txtbxDepartmentCode.Text;
objDepartment.DPT_CODE = offcode;
if (btnDepartmentSubmit.Text == "Submit")
{
int result = objDept_BLL.InsertDepartment(objDepartment);
if (result == 1)
{
// lblMessage.Text = "Data Save successfully!";
// lblMessage.ForeColor = System.Drawing.Color.Green;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Save successfully!')", true);
}
}
else
{
int DepartmentId = Convert.ToInt32(hidDepartmentId.Value);
int result = objDept_BLL.UpdateDepartment(objDepartment, DepartmentId);
if (result == 1)
{
// lblMessage.Text = "Data Update successfully!";
// lblMessage.ForeColor = System.Drawing.Color.Green;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update successfully!')", true);
}
}
GetAllDepartmentforGridview();
ClearDepartmentUi();
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
