private void btnDelete_Click(object sender, EventArgs e)
{
UnitConversionModel objmodel = objunitConBl.GetUnitConversionByUnitname(tbxUnitName.Text.Trim());
if (objmodel.SubUnit != null)
{
MessageBox.Show("Can Not Delete Unit Under Tag With Unit Name.." + objmodel.SubUnit);
tbxUnitName.Focus();
}
if (objmodel.SubUnit == null)
{
bool isDelete = objunm.DeleteUnitMasterById(UMId);
if (isDelete)
{
MessageBox.Show("Delete Successfully!");
ClearControls();
UMId = 0;
Administration.List.UnitmasterList frmList = new Administration.List.UnitmasterList();
frmList.StartPosition = FormStartPosition.CenterScreen;
frmList.ShowDialog();
FillUnitMasterInfo();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (cbxMainunit.Text.Equals(string.Empty))
{
MessageBox.Show("MainUnit Name can not be blank!");
return;
}
UnitConversionModel objUnitCon = new UnitConversionModel();
objUnitCon.MainUnit = cbxMainunit.SelectedItem.ToString();
objUnitCon.SubUnit = cbxSubunit.SelectedItem.ToString();
objUnitCon.ConFactor = Convert.ToDecimal(cbxConfactor.Text.Trim());
bool isSuccess = objunc.SaveUC(objUnitCon);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
ClearControls();
}
//List<eSunSpeedDomain.UnitConversionModel> lstGroups = objunc.GetListofUnitConversions();
//dgvList.DataSource = lstGroups;
//Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!");
//d.ShowDialog();
}
public List <UnitConversionModel> GetListofUnitConversions()
{
List <UnitConversionModel> lsObj = new List <UnitConversionModel>();
UnitConversionModel obj;
try
{
string Query = "SELECT * from unitconversion";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
//Initialize/reset account master object
obj = new UnitConversionModel();
obj.ID = Convert.ToInt32(dr["ID"]);
obj.ConFactor = Convert.ToDecimal(dr["ConFactor"]);
obj.SubUnit = dr["SubUnit"].ToString();
obj.MainUnit = dr["MainUnit"].ToString();
lsObj.Add(obj);
}
}
catch (Exception ex)
{
throw ex;
}
return(lsObj);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (cbxMainunit.Text.Equals(string.Empty))
{
MessageBox.Show("MainUnit Name can not be blank!");
return;
}
UnitConversionModel objUnitCon = new UnitConversionModel();
objUnitCon.MainUnit = cbxMainunit.SelectedItem.ToString();
objUnitCon.SubUnit = cbxSubunit.SelectedItem.ToString();
objUnitCon.ConFactor = Convert.ToDecimal(cbxConfactor.Text.Trim());
objUnitCon.ID = UCId;
bool isSuccess = objunc.UpdateUC(objUnitCon);
if (isSuccess)
{
MessageBox.Show("Update Successfully!");
UCId = 0;
ClearControls();
Administration.List.UnitconversionList frmList = new Administration.List.UnitconversionList();
frmList.StartPosition = FormStartPosition.CenterScreen;
frmList.ShowDialog();
FillUnitConversionInfo();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (cbxMainunit.Text.Equals(string.Empty))
{
MessageBox.Show("MainUnit Name can not be blank!");
return;
}
UnitConversionModel objUnitCon = new UnitConversionModel();
//if (objUnitCon.IsGroupExists(tbxGroupName.Text.Trim()))
//{
// MessageBox.Show("Group Name already Exists!", "SunSpeed", MessageBoxButtons.RetryCancel);
// cbxUnderGrp.Focus();
// return;
//}
objUnitCon.MainUnit = cbxMainunit.Text.Trim();
objUnitCon.SubUnit = tbxSubunit.Text.Trim();
objUnitCon.ConFactor = Convert.ToDecimal(cbxConfactor.Text.Trim());
bool isSuccess = objunc.SaveUC(objUnitCon);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
}
//List<eSunSpeedDomain.UnitConversionModel> lstGroups = objunc.GetListofUnitConversions();
//dgvList.DataSource = lstGroups;
//Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!");
//d.ShowDialog();
}
//Get Unit Conversion By Unit Name
public UnitConversionModel GetUnitConversionByUnitname(string Unitname)
{
UnitConversionModel objUnitCon = new UnitConversionModel();
string Query = string.Empty;
Query = "SELECT SubUnit FROM `UnitConversion` WHERE `MainUnit`='" + Unitname + "'";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objUnitCon = new eSunSpeedDomain.UnitConversionModel();
objUnitCon.SubUnit = dr["SubUnit"].ToString();
}
return(objUnitCon);
}
private void FillUnitConversionInfo()
{
if (UCId == 0)
{
cbxMainunit.Focus();
ClearControls();
lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
return;
}
UnitConversionModel objMaster = objunc.GetListofUnitConversionsById(UCId);
cbxMainunit.SelectedItem = objMaster.MainUnit;
cbxSubunit.SelectedItem = objMaster.SubUnit;
cbxConfactor.Text = Convert.ToString(objMaster.ConFactor);
lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
cbxMainunit.Focus();
}
//Get List Of Unit Conversion By Unit Id
public UnitConversionModel GetListofUnitConversionsById(int id)
{
UnitConversionModel obj = new UnitConversionModel();
try
{
string Query = "SELECT * from unitconversion WHERE ID=" + id + "";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
obj.ID = Convert.ToInt32(dr["ID"]);
obj.ConFactor = Convert.ToDecimal(dr["ConFactor"]);
obj.SubUnit = dr["SubUnit"].ToString();
obj.MainUnit = dr["MainUnit"].ToString();
}
}
catch (Exception ex)
{
throw ex;
}
return(obj);
}
