public bool DeleteSalaryHead(int salaryHeadID)
{
bool result = true;
try
{
TBl_MP_HR_SalaryHead model = _dbContext.TBl_MP_HR_SalaryHead.Where(x => x.pK_SH_ID == salaryHeadID).FirstOrDefault();
if (model != null)
{
model.IsActive = false;
}
TBL_MP_Admin_UserList model1 = _dbContext.TBL_MP_Admin_UserList.Where(x => x.PKID == salaryHeadID).FirstOrDefault();
if (model1 != null)
{
model1.IsActive = false;
}
_dbContext.SaveChanges();
result = true;
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "ServiceSalaryHead::DeleteSalaryHead", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(result);
}
public bool UpdatesalaryHead(TBl_MP_HR_SalaryHead model)
{
bool result = false;
try
{
TBl_MP_HR_SalaryHead dbModel = _dbContext.TBl_MP_HR_SalaryHead.Where(x => x.pK_SH_ID == model.pK_SH_ID).FirstOrDefault();
dbModel.fK_Usrlst_SH_ID = model.fK_Usrlst_SH_ID;
dbModel.fk_Usrlst_HdrType_ID = model.fk_Usrlst_HdrType_ID;
dbModel.fk_Usrlst_HdNature_ID = model.fk_Usrlst_HdNature_ID;
dbModel.Sequence = model.Sequence;
dbModel.IsActive = model.IsActive;
_dbContext.SaveChanges();
result = true;
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "ServiceSalaryHead::UpdatesalaryHead", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(result);
}
private void btnSave_Click(object sender, EventArgs e)
{
TBl_MP_HR_SalaryHead model = null;
ServiceSalaryHead _service = new ServiceSalaryHead();
try
{
if (!this.ValidateChildren())
{
return;
}
if (this.SelectedPK_ID == 0)
{
model = new TBl_MP_HR_SalaryHead();
}
else
{
model = _service.GetSalaryHeadDbRecord(this.SelectedPK_ID);
}
model.fK_Usrlst_SH_ID = SelectSalaryHeadID;
model.fk_Usrlst_HdrType_ID = ((SelectListItem)cboSalaryHeadType.SelectedItem).ID;
model.fk_Usrlst_HdNature_ID = ((SelectListItem)cboSalaryHeadNature.SelectedItem).ID;
model.Sequence = int.Parse(txtSequence.Text.Trim());
model.IsActive = chkIsActive.Checked;
if (this.SelectedPK_ID == 0)
{
this.SelectSalaryHeadID = _service.AddNewSalaryHead(model);
}
else
{
_service.UpdatesalaryHead(model);
}
DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditSalaryHead::btnSave_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmAddEditSalaryHead_Load(object sender, EventArgs e)
{
try
{
PopulateSalaryHeadTypeDropDown();
PopulateSalaryHeadNatureDropDown();
txtSalaryHead.ReadOnly = true;
if (this.SelectedPK_ID == 0)
{
txtSalaryHead.Text =
txtSequence.Text = String.Empty;
cboSalaryHeadType.SelectedIndex = 0;
cboSalaryHeadNature.SelectedIndex = 0;
chkIsActive.Checked = true;
}
else
{
TBl_MP_HR_SalaryHead model = (new ServiceSalaryHead()).GetSalaryHeadDbRecord(this.SelectedPK_ID);
if (model != null)
{
this.SelectSalaryHeadID = model.fK_Usrlst_SH_ID;
txtSalaryHead.Text = GetSalaryHeadTypeName(model.fK_Usrlst_SH_ID);
txtSequence.Text = model.Sequence.ToString();
cboSalaryHeadType.SelectedItem = ((List <SelectListItem>)cboSalaryHeadType.DataSource).Where(x => x.ID == model.fk_Usrlst_HdrType_ID).FirstOrDefault();
cboSalaryHeadNature.SelectedItem = ((List <SelectListItem>)cboSalaryHeadNature.DataSource).Where(x => x.ID == model.fk_Usrlst_HdNature_ID).FirstOrDefault();
chkIsActive.Checked = model.IsActive;
btnAddNewSalaryHead.Visible = false;
}
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditSalaryHead::frmAddEditSalaryHead_Load", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public int AddNewSalaryHead(TBl_MP_HR_SalaryHead model)
{
int newID = 0;
try
{
model.IsActive = true;
_dbContext.TBl_MP_HR_SalaryHead.Add(model);
_dbContext.SaveChanges();
newID = model.pK_SH_ID;
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "ServiceSalaryHead::AddNewBankBranch", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(newID);
}
