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 dgvRemoveTransformerList_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
foreach (DataGridViewRow row in dgvRemoveTransformerList.Rows)
{
TransformerHistory transformerhistory = (TransformerHistory)row.DataBoundItem;
row.Cells[0].Value = transformerhistory.TransformerID;
row.Cells[1].Value = transformerhistory.OldTransformerName;
row.Cells[2].Value = transformerhistory.TransformerName;
row.Cells[3].Value = transformerhistory.Model;
row.Cells[4].Value = transformerhistory.Maker;
row.Cells[5].Value = transformerhistory.CountryOfOrgin;
row.Cells[6].Value = transformerhistory.Status;
row.Cells[7].Value = transformerhistory.QuarterID;
row.Cells[8].Value = transformerhistory.Standard;
}
}
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);
}
}
}
}
