private void btnSave_Click(object sender, EventArgs e)
{
if (checkValidation())
{
if (isEdit)
{
int editPunishmentCount = 0;
PunishmentRule updatePunishmentRule = (from p in mbmsEntities.PunishmentRules where p.PunishmentRuleID == punishmentRuleID select p).FirstOrDefault();
if (txtPunishmentCode.Text != updatePunishmentRule.PunishmentCode)
{
editPunishmentCount = (from p in mbmsEntities.PunishmentRules where p.PunishmentCode == txtPunishmentCode.Text && p.Active == true select p).ToList().Count;
}
if (editPunishmentCount > 0)
{
tooltip.SetToolTip(txtPunishmentCode, "Error");
tooltip.Show("Punishment Rule Code is already exist!", txtPunishmentCode);
return;
}
updatePunishmentRule.PunishmentCode = txtPunishmentCode.Text;
updatePunishmentRule.ExceedMonth = Convert.ToInt32(txtExceedMonth.Text);
updatePunishmentRule.Amount = Convert.ToDecimal(txtAmount.Text);
updatePunishmentRule.UpdatedUserID = UserID;
updatePunishmentRule.UpdatedDate = DateTime.Now;
punishmentRuleController.UpdatePurnishmentRule(updatePunishmentRule);
MessageBox.Show("Successfully updated Punishment Rule!", "Update");
isEdit = false;
btnSave.Text = "Save";
Clear();
FormRefresh();
}
else
{
PunishmentRule punishmentRule = new PunishmentRule();
int punishmentRuleCount = 0;
punishmentRuleCount = (from p in mbmsEntities.PunishmentRules where p.PunishmentCode == txtPunishmentCode.Text && p.Active == true select p).ToList().Count;
if (punishmentRuleCount > 0)
{
tooltip.SetToolTip(txtPunishmentCode, "Error");
tooltip.Show("Punishment Rule Code is already exist!", txtPunishmentCode);
return;
}
punishmentRule.PunishmentRuleID = Guid.NewGuid().ToString();
punishmentRule.PunishmentCode = txtPunishmentCode.Text;
punishmentRule.ExceedMonth = Convert.ToInt32(txtExceedMonth.Text);
punishmentRule.Amount = Convert.ToDecimal(txtAmount.Text);
punishmentRule.Active = true;
punishmentRule.CreatedUserID = UserID;
punishmentRule.CreatedDate = DateTime.Now;
punishmentRuleController.Save(punishmentRule);
MessageBox.Show("Successfully registered Punishment Rule! Please check it in 'Punishment Rule List'.", "Save Success");
Clear();
FormRefresh();
}
}
}
public void DeletePrunishmentRule(PunishmentRule r)
{
PunishmentRule punishmentRule = mBMSEntities.PunishmentRules.Where(x => x.PunishmentRuleID == r.PunishmentRuleID).SingleOrDefault();
punishmentRule.Active = r.Active;
punishmentRule.DeletedDate = DateTime.Now;
punishmentRule.DeletedUserID = r.DeletedUserID;
mBMSEntities.SaveChanges();
}
private void dgvPunishmentRuleList_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
foreach (DataGridViewRow row in dgvPunishmentRuleList.Rows)
{
PunishmentRule punishmentRule = (PunishmentRule)row.DataBoundItem;
row.Cells[0].Value = punishmentRule.PunishmentRuleID;
row.Cells[1].Value = punishmentRule.PunishmentCode;
row.Cells[2].Value = punishmentRule.ExceedMonth;
row.Cells[3].Value = punishmentRule.Amount;
}
}
public void UpdatePurnishmentRule(PunishmentRule r)
{
PunishmentRule punishmentRule = mBMSEntities.PunishmentRules.Where(x => x.PunishmentRuleID == r.PunishmentRuleID).SingleOrDefault();
punishmentRule.PunishmentCode = r.PunishmentCode;
punishmentRule.ExceedMonth = r.ExceedMonth;
punishmentRule.Amount = r.Amount;
punishmentRule.UpdatedUserID = r.UpdatedUserID;
punishmentRule.UpdatedDate = DateTime.Now;
mBMSEntities.PunishmentRules.AddOrUpdate(punishmentRule); //requires using System.Data.Entity.Migrations;
mBMSEntities.SaveChanges();
}
private void dgvPunishmentRuleList_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
if (e.ColumnIndex == 5)
{
//DeleteForPunishmentRule
if (!CheckingRoleManagementFeature("PunishmentEditOrDelete"))
{
MessageBox.Show("Access Denied for this function.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
DialogResult result = MessageBox.Show(this, "Are you sure you want to delete?", "Delete", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result.Equals(DialogResult.OK))
{
DataGridViewRow row = dgvPunishmentRuleList.Rows[e.RowIndex];
punishmentRuleID = Convert.ToString(row.Cells[0].Value);
dgvPunishmentRuleList.DataSource = "";
PunishmentRule punishmentRule = (from p in mbmsEntities.PunishmentRules where p.PunishmentRuleID == punishmentRuleID select p).FirstOrDefault();
punishmentRule.Active = false;
punishmentRule.DeletedUserID = UserID;
punishmentRule.DeletedDate = DateTime.Now;
punishmentRuleController.DeletePrunishmentRule(punishmentRule);
dgvPunishmentRuleList.DataSource = (from p in mbmsEntities.PunishmentRules where p.Active == true orderby p.PunishmentCode descending select p).ToList();
MessageBox.Show(this, "Successfully Deleted!", "Delete Complete", MessageBoxButtons.OK, MessageBoxIcon.Information);
Clear();
FormRefresh();
}
}
else if (e.ColumnIndex == 4)
{
//EditPunishmentRule
if (!CheckingRoleManagementFeature("PunishmentEditOrDelete"))
{
MessageBox.Show("Access Denied for this function.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
DataGridViewRow row = dgvPunishmentRuleList.Rows[e.RowIndex];
punishmentRuleID = Convert.ToString(row.Cells[0].Value);
txtPunishmentCode.Text = Convert.ToString(row.Cells[1].Value);
txtExceedMonth.Text = Convert.ToString(row.Cells[2].Value);
txtAmount.Text = Convert.ToString(row.Cells[3].Value);
isEdit = true;
this.btnSave.Text = "Update";
}
}
}
public void Save(PunishmentRule r)
{
mBMSEntities.PunishmentRules.Add(r);
mBMSEntities.SaveChanges();
}
