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();
}
public void DeleteBillCode7Layer(BillCode7Layer bc)
{
BillCode7Layer billCode7Layer = mBMSEntities.BillCode7Layer.Where(x => x.BillCode7LayerID == bc.BillCode7LayerID).SingleOrDefault();
billCode7Layer.Active = bc.Active;
billCode7Layer.DeletedDate = DateTime.Now;
billCode7Layer.DeletedUserID = bc.DeletedUserID;
mBMSEntities.SaveChanges();
}
public void DeletedByTownship(Township t)
{
Township township = mBMSEntities.Townships.Where(x => x.TownshipID == t.TownshipID).SingleOrDefault();
township.Active = t.Active;
township.DeletedDate = DateTime.Now;
township.DeletedUserID = t.DeletedUserID;
mBMSEntities.SaveChanges();
}
private void CreateRoleFeatures(string feature, bool IsAllowed, string RoleID, string UserID)
{
RoleManagement rolemgtentity = new RoleManagement();
rolemgtentity.RoleManagementID = Guid.NewGuid().ToString();
rolemgtentity.Active = true;
rolemgtentity.RoleFeatureName = feature;
rolemgtentity.RoleID = RoleID;
rolemgtentity.IsAllowed = IsAllowed;
rolemgtentity.CreatedUserID = UserID;
rolemgtentity.CratedDate = DateTime.Now;
mBMSEntities.RoleManagements.Add(rolemgtentity);
mBMSEntities.SaveChanges();
}
private void dgvRemoveTransformerList_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
if (e.ColumnIndex == 9)
{
//DeleteForTransformer
DialogResult result = MessageBox.Show(this, "Are you sure you want to delete?", "Delete", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result.Equals(DialogResult.OK))
{
DataGridViewRow row = dgvRemoveTransformerList.Rows[e.RowIndex];
TransformerID = Convert.ToString(row.Cells[0].Value);
dgvRemoveTransformerList.DataSource = "";
TransformerHistory removeTransformer = (from tf in mbsEntities.TransformerHistories where tf.TransformerID == TransformerID select tf).FirstOrDefault();
removeTransformer.Active = false;
removeTransformer.DeletedUserID = UserID;
removeTransformer.DeletedDate = DateTime.Now;
mbsEntities.SaveChanges();
dgvRemoveTransformerList.DataSource = (from tf in mbsEntities.TransformerHistories where tf.Active == true orderby tf.TransformerName descending select tf).ToList();
MessageBox.Show(this, "Successfully Deleted!", "Delete Complete", MessageBoxButtons.OK, MessageBoxIcon.Information);
FormRefresh();
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Boolean hasError = false;
tp.RemoveAll();
tp.IsBalloon = true;
tp.ToolTipIcon = ToolTipIcon.Error;
tp.ToolTipTitle = "Error";
if (txtNoCopy.Text.Trim() == string.Empty || Convert.ToInt32(txtNoCopy.Text) == 0)
{
tp.SetToolTip(txtNoCopy, "Error");
tp.Show("Please number of Copy!", txtNoCopy);
hasError = true;
}
if (!hasError)
{
DefaultPrinter.A4Printer = cboPrinter.Text;
SettingController.CompanyName = lblCompanyName.Text;
SettingController.CompanyEmail = lblEmail.Text;
SettingController.PhoneNo = lblPhoneNumber.Text;
SettingController.CompanyWebsite = lblWebsite.Text;
SettingController.CompanyAddress = lblAddress.Text;
SettingController.DefaultNoOfCopies = Convert.ToInt32(txtNoCopy.Text);
SettingController.ExpireDate = dtExpireDate.Value.ToString();
SettingController.StreetLightFees = Convert.ToInt32(txtStreetLightFees.Text);
mbmsEntities.SaveChanges();
MessageBox.Show("Successfully save Setting!");
}
}
public bool Save(PunishmentCustomer punishmentcustomer)
{
try {
mBMSEntities.PunishmentCustomers.Add(punishmentcustomer);
mBMSEntities.SaveChanges();
}catch (Exception ex) {
return(false);
}
return(true);
}
public bool SaveAdvanceMoney(AdvanceMoneyCustomer advanceMoneyCustomer)
{
try {
mBMSEntities.AdvanceMoneyCustomers.Add(advanceMoneyCustomer);
mBMSEntities.SaveChanges();
}catch (Exception ex) {
return(false);
}
return(true);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (checkValidation())
{
string QuarterId = cboQuarterName.SelectedValue.ToString();
bool isdataExists = mbmsEntities.StreetLightFees.Any(x => x.Active == true && x.QuarterID == QuarterId);
if (isdataExists)
{
MessageBox.Show("Same Quarter data already exists!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (btnSave.Text.Equals("Update"))
{
StreetLightFee streetlightfeeentity = mbmsEntities.StreetLightFees.Where(x => x.Active == true && x.StreetLightFeesID == streetLightFeesId).SingleOrDefault();
streetlightfeeentity.QuarterID = QuarterId;
streetlightfeeentity.Amount = Convert.ToDecimal(txtstreetlightfeeamt.Text);
streetlightfeeentity.Active = true;
streetlightfeeentity.UpdatedDate = DateTime.Now;
streetlightfeeentity.UpdatedUserID = UserID;
mbmsEntities.StreetLightFees.AddOrUpdate(streetlightfeeentity);
mbmsEntities.SaveChanges();
MessageBox.Show("Successfully Updated", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnSave.Text = "Save";
}
else
{
StreetLightFee streetlightfeeentity = new StreetLightFee();
streetlightfeeentity.StreetLightFeesID = Guid.NewGuid().ToString();
streetlightfeeentity.QuarterID = QuarterId;
streetlightfeeentity.Amount = Convert.ToDecimal(txtstreetlightfeeamt.Text);
streetlightfeeentity.Active = true;
streetlightfeeentity.CreatedDate = DateTime.Now;
streetlightfeeentity.CreatedUserID = UserID;
mbmsEntities.StreetLightFees.Add(streetlightfeeentity);
mbmsEntities.SaveChanges();
MessageBox.Show("Successfully Saved", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
bindStreetLightFeesGridView();
}
}
public void MeterUnitProces(MeterUnitCollect meterUnitCollect)
{
mBMSEntities.MeterUnitCollects.Add(meterUnitCollect);
mBMSEntities.SaveChanges();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (checkValidation())
{
if (isEdit)
{
int editBillCodeNoCount = 0;
long editbillCodeNo = Convert.ToInt64(txtBillCodeNo.Text);
BillCode7Layer updateBillCode7Layer = (from b in mbsEntities.BillCode7Layer where b.BillCode7LayerID == billCode7LayerID select b).FirstOrDefault();
if (txtBillCodeNo.Text != Convert.ToString(updateBillCode7Layer.BillCode7LayerNo))
{
editBillCodeNoCount = (from b in mbsEntities.BillCode7Layer where b.BillCode7LayerNo == editbillCodeNo && b.Active == true select b).ToList().Count;
}
if (editBillCodeNoCount > 0)
{
tooltip.SetToolTip(txtBillCodeNo, "Error");
tooltip.Show("Bill Code No is already exist!", txtBillCodeNo);
return;
}
updateBillCode7Layer.BillCode7LayerNo = Convert.ToInt64(txtBillCodeNo.Text);
updateBillCode7Layer.BillCodeLayerType = cboBillCodeType.Text;
updateBillCode7Layer.UpdatedUserID = UserID;
updateBillCode7Layer.UpdatedDate = DateTime.Now;
billCode7LayerController.UpdateBillCode7Layer(updateBillCode7Layer);
mbsEntities.BillCode7LayerDetail_DeleteByBillCode7LayerID(billCode7LayerID);
foreach (DataGridViewRow row in gv7layer.Rows)
{
BillCode7LayerDetail billCode7LayerDetail = new BillCode7LayerDetail();
billCode7LayerDetail.BillCode7LayerDetailID = Guid.NewGuid().ToString();
billCode7LayerDetail.BillCode7LayerID = billCode7LayerID;
billCode7LayerDetail.LowerLimit = Convert.ToDecimal(row.Cells[0].Value);
billCode7LayerDetail.UpperLimit = Convert.ToDecimal(row.Cells[1].Value);
billCode7LayerDetail.RateUnit = Convert.ToDecimal(row.Cells[2].Value);
billCode7LayerDetail.AmountPerUnit = Convert.ToDecimal(row.Cells[3].Value);
billCode7LayerDetail.Active = true;
billCode7LayerDetail.CreatedDate = DateTime.Now;
billCode7LayerDetail.CreatedUserID = UserID;
mbsEntities.BillCode7LayerDetail.Add(billCode7LayerDetail);
}
mbsEntities.SaveChanges();
MessageBox.Show("Successfully Update!", "Update");
Clear();
BillCode7LayerList billcode7LayerListForm = new BillCode7LayerList();
billcode7LayerListForm.Show();
this.Close();
}
else
{
if (gv7layer.Rows.Count == 0)
{
MessageBox.Show("please define layers information firstly!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
int billCodeNoCount = 0;
long billCodeNo = Convert.ToInt64(txtBillCodeNo.Text);
billCodeNoCount = (from b in mbsEntities.BillCode7Layer where b.BillCode7LayerNo == billCodeNo && b.Active == true select b).ToList().Count;
if (billCodeNoCount > 0)
{
tooltip.SetToolTip(txtBillCodeNo, "Error");
tooltip.Show("Bill Code No is already exist!", txtBillCodeNo);
MessageBox.Show("Bill Code No is already exist!", "Error");
return;
}
billCode7Layer.BillCode7LayerID = Guid.NewGuid().ToString();
billCode7Layer.BillCode7LayerNo = Convert.ToInt64(txtBillCodeNo.Text);
billCode7Layer.BillCodeLayerType = cboBillCodeType.Text;
billCode7Layer.Active = true;
billCode7Layer.CreatedUserID = UserID;
billCode7Layer.CreatedDate = DateTime.Now;
billCode7LayerController.Save(billCode7Layer);
foreach (DataGridViewRow row in gv7layer.Rows)
{
BillCode7LayerDetail billCode7LayerDetail = new BillCode7LayerDetail();
billCode7LayerDetail.BillCode7LayerDetailID = Guid.NewGuid().ToString();
billCode7LayerDetail.BillCode7LayerID = billCode7Layer.BillCode7LayerID;
billCode7LayerDetail.LowerLimit = Convert.ToDecimal(row.Cells[0].Value);
billCode7LayerDetail.UpperLimit = Convert.ToDecimal(row.Cells[1].Value);
billCode7LayerDetail.RateUnit = Convert.ToDecimal(row.Cells[2].Value);
billCode7LayerDetail.AmountPerUnit = Convert.ToDecimal(row.Cells[3].Value);
billCode7LayerDetail.Active = true;
billCode7LayerDetail.CreatedDate = DateTime.Now;
billCode7LayerDetail.CreatedUserID = UserID;
mbsEntities.BillCode7LayerDetail.Add(billCode7LayerDetail);
}
mbsEntities.SaveChanges();
MessageBox.Show("Success", "Save Success");
Clear();
BillCode7LayerList billcode7LayerListForm = new BillCode7LayerList();
billcode7LayerListForm.UserID = this.UserID;
billcode7LayerListForm.Show();
this.Close();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (checkValidation())
{
if (isEdit)
{
int TransformerName = 0;
TransformerName = (from tn in mbsEntities.Transformers where tn.TransformerName.Trim() == txtTransformerName.Text.Trim() && tn.TransformerID != TransformerID && tn.Active == true select tn).ToList().Count;
if (TransformerName == 0)
{
string oldTransformerName;
Transformer updateTransformer = (from tf in mbsEntities.Transformers where tf.TransformerID == TransformerID select tf).FirstOrDefault();
oldTransformerName = updateTransformer.TransformerName;
updateTransformer.TransformerName = txtTransformerName.Text;
updateTransformer.Model = txtTransformerModel.Text;
updateTransformer.CountryOfOrgin = txtCountryOrgin.Text;
updateTransformer.FullLoadLoss = Convert.ToInt32(txtFullLoadLoss.Text);
updateTransformer.ImpendanceVoltage = Convert.ToInt32(txtImpedanceVoltage.Text);
updateTransformer.EfficiencyLoad = Convert.ToInt32(txtEfficiency.Text);
updateTransformer.TappingRange = txtTappingRange.Text;
updateTransformer.TypeofCooling = txtTypeOfCooling.Text;
updateTransformer.VectorGroup = txtVectorGroup.Text;
updateTransformer.VoltageRatio = Convert.ToInt32(txtVoltageRatio.Text);
updateTransformer.Standard = txtStandard.Text;
updateTransformer.NoloadLoss = Convert.ToInt32(txtNoLoadLoss.Text);
updateTransformer.RatedOutputPower = Convert.ToInt32(txtRatedPower.Text);
updateTransformer.Maker = txtmaker.Text;
if (rdoEnable.Checked == true)
{
updateTransformer.Status = "Enable";
}
else
{
updateTransformer.Status = "Disable";
}
updateTransformer.QuarterID = cboQuarterName.SelectedValue.ToString();
updateTransformer.UpdatedUserID = UserID;
updateTransformer.UpdateDate = DateTime.Now;
transformerController.UpdateTransformer(updateTransformer);
if (oldTransformerName != txtTransformerName.Text)
{
TransformerHistory transformerHistory = new TransformerHistory();
transformerHistory.TransformerID = Guid.NewGuid().ToString();
transformerHistory.OldTransformerName = oldTransformerName;
transformerHistory.TransformerName = updateTransformer.TransformerName;
transformerHistory.Model = updateTransformer.Model;
transformerHistory.CountryOfOrgin = updateTransformer.CountryOfOrgin;
transformerHistory.FullLoadLoss = updateTransformer.FullLoadLoss;
transformerHistory.ImpendanceVoltage = updateTransformer.ImpendanceVoltage;
transformerHistory.EfficiencyLoad = updateTransformer.EfficiencyLoad;
transformerHistory.TappingRange = updateTransformer.TappingRange;
transformerHistory.TypeofCooling = updateTransformer.TypeofCooling;
transformerHistory.VectorGroup = updateTransformer.VectorGroup;
transformerHistory.VoltageRatio = updateTransformer.VoltageRatio;
transformerHistory.Standard = updateTransformer.Standard;
transformerHistory.NoloadLoss = updateTransformer.NoloadLoss;
transformerHistory.RatedOutputPower = updateTransformer.RatedOutputPower;
transformerHistory.Maker = updateTransformer.Maker;
transformerHistory.GPSX = 0;
transformerHistory.GPSY = 0;
transformerHistory.Status = "Disable";
transformerHistory.CreatedUserID = updateTransformer.UpdatedUserID;
transformerHistory.CreatedDate = DateTime.Now;
transformerHistory.QuarterID = updateTransformer.QuarterID;
transformerHistory.Active = true;
mbsEntities.TransformerHistories.Add(transformerHistory);
mbsEntities.SaveChanges();
}
MessageBox.Show("Successfully updated Transformer!", "Update");
Clear();
TransformerListfrm transformerListfrm = new TransformerListfrm();
transformerListfrm.Show();
this.Close();
}
else if (TransformerName > 0)
{
tooltip.SetToolTip(txtTransformerName, "Error");
tooltip.Show("This Transformer Name is already exist!", txtTransformerName);
}
}
else
{
int TransformerName = 0;
TransformerName = (from tn in mbsEntities.Transformers where tn.TransformerName.Trim() == txtTransformerName.Text.Trim() && tn.Active == true select tn).ToList().Count;
if (TransformerName == 0)
{
Transformer transformer = new Transformer();
transformer.TransformerID = Guid.NewGuid().ToString();
transformer.TransformerName = txtTransformerName.Text;
transformer.Model = txtTransformerModel.Text;
transformer.CountryOfOrgin = txtCountryOrgin.Text;
transformer.FullLoadLoss = Convert.ToInt32(txtFullLoadLoss.Text == ""?"0":txtFullLoadLoss.Text);
transformer.ImpendanceVoltage = Convert.ToInt32(txtImpedanceVoltage.Text == ""?"0":txtImpedanceVoltage.Text);
transformer.EfficiencyLoad = Convert.ToInt32(txtEfficiency.Text == "" ?"0":txtEfficiency.Text);
transformer.TappingRange = txtTappingRange.Text == ""?"0":txtTappingRange.Text;
transformer.TypeofCooling = txtTypeOfCooling.Text == ""?"0":txtTypeOfCooling.Text;
transformer.VectorGroup = txtVectorGroup.Text;
transformer.VoltageRatio = Convert.ToInt32(txtVoltageRatio.Text == "" ?"0":txtVoltageRatio.Text);
transformer.Standard = txtStandard.Text == "" ?"0":txtStandard.Text;
transformer.NoloadLoss = Convert.ToInt32(txtNoLoadLoss.Text == "" ?"0":txtNoLoadLoss.Text);
transformer.RatedOutputPower = Convert.ToInt32(txtRatedPower.Text == ""?"0":txtRatedPower.Text);
transformer.Maker = txtmaker.Text;
if (rdoEnable.Checked == true)
{
transformer.Status = "Enable";
}
else
{
transformer.Status = "Disable";
}
transformer.QuarterID = cboQuarterName.SelectedValue.ToString();
transformer.Active = true;
transformer.CreatedUserID = UserID;
transformer.CreatedDate = DateTime.Now;
transformerController.Save(transformer);
MessageBox.Show("Successfully registered Trasformer! Please check it in 'Transformer List'.", "Save Success");
Clear();
}
else if (TransformerName > 0)
{
tooltip.SetToolTip(txtTransformerName, "Error");
tooltip.Show("This Transformer Name is already exist!", txtTransformerName);
}
}
}
}