private void dgvMeterboxList_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
if (e.ColumnIndex == 7)
{
//DeleteForMeterBox
if (!CheckingRoleManagementFeature("MeterEditOrDelete"))
{
MessageBox.Show("Access Deined 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 = dgvMeterboxList.Rows[e.RowIndex];
meterBoxID = Convert.ToString(row.Cells[0].Value);
MeterBox meterBoxobj = (MeterBox)row.DataBoundItem;
meterBoxobj = (from mb in mbmsEntities.MeterBoxes where mb.MeterBoxID == meterBoxobj.MeterBoxID select mb).FirstOrDefault();
var meterCount = (from m in meterBoxobj.Meters where m.Active == true select m).Count();
if (meterCount > 0)
{
MessageBox.Show("This Meterbox cannot be deleted! It is in used.", "Cannot Delete", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
dgvMeterboxList.DataSource = "";
MeterBox meterBox = (from mb in mbmsEntities.MeterBoxes where mb.MeterBoxID == meterBoxID select mb).FirstOrDefault();
meterBox.Active = false;
meterBox.DeletedUserID = UserID;
meterBox.DeletedDate = DateTime.Now;
meterBoxController.DeleteMeterBox(meterBox);
dgvMeterboxList.DataSource = (from mb in mbmsEntities.MeterBoxes where mb.Active == true orderby mb.MeterBoxCode descending select mb).ToList();
MessageBox.Show(this, "Successfully Deleted!", "Delete Complete", MessageBoxButtons.OK, MessageBoxIcon.Information);
Clear();
FormRefresh();
}
}
else if (e.ColumnIndex == 6)
{
//EditMeterBox
if (!CheckingRoleManagementFeature("MeterEditOrDelete"))
{
MessageBox.Show("Access Deined for this function.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
DataGridViewRow row = dgvMeterboxList.Rows[e.RowIndex];
meterBoxID = Convert.ToString(row.Cells[0].Value);
txtMeterBoxCode.Text = Convert.ToString(row.Cells[1].Value);
cboPoleNo.Text = Convert.ToString(row.Cells[2].Value);
txtQuarterName.Text = Convert.ToString(row.Cells[3].Value);
cboMeterBoxName.Text = Convert.ToString(row.Cells[4].Value);
txtMeterBox.Text = Convert.ToString(row.Cells[5].Value);
isEdit = true;
btnSave.Text = "Update";
}
}
}
public void DeleteMeterBox(MeterBox mb)
{
MeterBox meterBox = mBMSEntities.MeterBoxes.Where(x => x.MeterBoxID == mb.MeterBoxID).SingleOrDefault();
meterBox.Active = mb.Active;
meterBox.DeletedDate = DateTime.Now;
meterBox.DeletedUserID = mb.DeletedUserID;
mBMSEntities.SaveChanges();
}
private void dgvMeterboxList_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
foreach (DataGridViewRow row in dgvMeterboxList.Rows)
{
MeterBox meterBox = (MeterBox)row.DataBoundItem;
row.Cells[0].Value = meterBox.MeterBoxID;
row.Cells[1].Value = meterBox.MeterBoxCode;
row.Cells[2].Value = meterBox.Pole.PoleNo;
row.Cells[3].Value = meterBox.Pole.Transformer.Quarter.QuarterNameInEng;
row.Cells[4].Value = meterBox.MeterBoxName;
row.Cells[5].Value = meterBox.Box;
}
}
public void bindMeterBoxCode()
{
List <MeterBox> meterboxList = new List <MeterBox>();
MeterBox meterbox = new MeterBox();
meterbox.MeterBoxID = Convert.ToString(0);
meterbox.MeterBoxCode = "Select";
meterboxList.Add(meterbox);
meterboxList.AddRange(mbsEntities.MeterBoxes.Where(x => x.Active == true).ToList());
cboMeterBoxCode.DataSource = meterboxList;
cboMeterBoxCode.DisplayMember = "MeterBoxCode";
cboMeterBoxCode.ValueMember = "MeterBoxID";
}
public void UpdateMeterBox(MeterBox mb)
{
MeterBox meterBox = mBMSEntities.MeterBoxes.Where(x => x.MeterBoxID == mb.MeterBoxID).SingleOrDefault();
meterBox.MeterBoxCode = mb.MeterBoxCode;
meterBox.Box = mb.Box;
meterBox.MeterBoxName = mb.MeterBoxName;
meterBox.AvailableInMBQty = mb.AvailableInMBQty;
meterBox.PoleID = mb.PoleID;
meterBox.UpdatedUserID = mb.UpdatedUserID;
meterBox.UpdatedDate = DateTime.Now;
mBMSEntities.MeterBoxes.AddOrUpdate(meterBox); //requires using System.Data.Entity.Migrations;
mBMSEntities.SaveChanges();
}
private void BindRecrods(Meter meter, DataRow row)
{
meter.MeterNo = row["MeterNo"].ToString();
meter.MeterID = Guid.NewGuid().ToString();
meter.Model = row["Model"].ToString();
meter.InstalledDate = Convert.ToDateTime(row["InstalledDate"].ToString());
meter.Phrase = row["Phrase"].ToString();
meter.Wire = row["Wire"].ToString();
meter.BasicCurrent = row["BasicCurrent"].ToString();
meter.iMax = Convert.ToInt32(row["iMax"]);
meter.Voltage = Convert.ToInt32(row["Voltage"]);
meter.ManufactureBy = row["ManufactureBy"].ToString();
meter.Status = row["Status"].ToString();
meter.AvailableYear = Convert.ToInt32(row["AvailableYear"]);
MeterBox meterbox = meterservices.getMeterBoxByMeterBoxNo(row["MeterBoxCode"].ToString());
if (meterbox == null)
{
MessageBox.Show("Please define Meter Box Code for>" + meter.MeterNo, "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
bool checkmeterboxsequence = meterservices.getMeterByMeterboxIdBoxSequence(meterbox.MeterBoxID, Convert.ToString(row["MeterBoxSequence"]));
if (checkmeterboxsequence)
{
MessageBox.Show("Meter Box Sequence is already used!!>" + meter.MeterNo, "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
meter.MeterBoxID = meterbox.MeterBoxID;
meter.MeterBoxSequence = Convert.ToString(row["MeterBoxSequence"]);
MeterType metertype = meterservices.getMeterTypeByMeterTypeCode(row["MeterTypeCode"].ToString());
if (metertype == null)
{
MessageBox.Show("Please define Meter Type Code for>" + meter.MeterNo, "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
meter.MeterTypeID = metertype.MeterTypeID;
meter.Active = true;
meter.CreatedDate = DateTime.Now;
meter.CreatedUserID = UserID;
meterList.Add(meter);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!CheckingRoleManagementFeature("MeterBoxAdd"))
{
MessageBox.Show("Access Deined for this function.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (checkValidation())
{
if (isEdit)
{
int editMeterBoxCodeCount = 0; int editMeterBoxCount = 0;
MeterBox updateMeterBox = (from mb in mbmsEntities.MeterBoxes where mb.MeterBoxID == meterBoxID select mb).FirstOrDefault();
if (txtMeterBoxCode.Text != updateMeterBox.MeterBoxCode)
{
editMeterBoxCodeCount = (from mb in mbmsEntities.MeterBoxes where mb.MeterBoxCode == txtMeterBoxCode.Text && mb.Active == true select mb).ToList().Count;
}
if (txtMeterBox.Text != updateMeterBox.Box)
{
editMeterBoxCount = (from mb in mbmsEntities.MeterBoxes where mb.MeterBoxCode == txtMeterBox.Text && mb.Pole.PoleNo == cboPoleNo.Text && mb.Active == true select mb).ToList().Count;
}
if (editMeterBoxCodeCount > 0)
{
tooltip.SetToolTip(txtMeterBoxCode, "Error");
tooltip.Show("Meter Box Code is already exist!", txtMeterBoxCode);
return;
}
if (editMeterBoxCount > 0)
{
tooltip.SetToolTip(txtMeterBox, "Error");
tooltip.Show("Meter Box is already exist!", txtMeterBox);
return;
}
updateMeterBox.MeterBoxCode = txtMeterBoxCode.Text;
updateMeterBox.Box = txtMeterBox.Text;
updateMeterBox.PoleID = cboPoleNo.SelectedValue.ToString();
updateMeterBox.MeterBoxName = cboMeterBoxName.Text.ToString();
updateMeterBox.UpdatedUserID = UserID;
updateMeterBox.UpdatedDate = DateTime.Now;
meterBoxController.UpdateMeterBox(updateMeterBox);
MessageBox.Show("Successfully updated Meterbox!", "Update");
isEdit = false;
btnSave.Text = "Save";
Clear();
FormRefresh();
}
else
{
MeterBox meterBox = new MeterBox();
int meterBoxCodeCount = 0; int meterBoxCount = 0;
meterBoxCodeCount = (from mb in mbmsEntities.MeterBoxes where mb.MeterBoxCode == txtMeterBoxCode.Text && mb.Active == true select mb).ToList().Count;
meterBoxCount = (from mb in mbmsEntities.MeterBoxes where mb.Box == txtMeterBox.Text && mb.Pole.PoleNo == cboPoleNo.Text && mb.Active == true select mb).ToList().Count;
if (meterBoxCodeCount > 0)
{
tooltip.SetToolTip(txtMeterBoxCode, "Error");
tooltip.Show("Meter Box Code is already exist!", txtMeterBoxCode);
return;
}
if (meterBoxCount > 0)
{
tooltip.SetToolTip(txtMeterBox, "Error");
tooltip.Show("Meter Box is already exist!", txtMeterBox);
return;
}
try
{
meterBox.MeterBoxID = Guid.NewGuid().ToString();
meterBox.MeterBoxCode = txtMeterBoxCode.Text;
meterBox.Box = txtMeterBox.Text;
meterBox.PoleID = cboPoleNo.SelectedValue.ToString();
meterBox.MeterBoxName = cboMeterBoxName.Text;
meterBox.Active = true;
meterBox.CreatedUserID = UserID;
meterBox.CreatedDate = DateTime.Now;
meterBoxController.Save(meterBox);
MessageBox.Show("Successfully registered Meterbox! Please check it in 'Meterbox List'.", "Save Success");
Clear();
FormRefresh();
}
catch (Exception ex)
{
MessageBox.Show("Error", "Error");
}
}
}
}
public void Save(MeterBox mb)
{
mBMSEntities.MeterBoxes.Add(mb);
mBMSEntities.SaveChanges();
}
