private void btnOk_Click(object sender, EventArgs e)
{
MasterseriesModel objSeries;
Account.objAccount.MasterSeries = new List <MasterseriesModel>();
Accountgroup.objAccGroup.AGMasterSeries = new List <MasterseriesModel>();
Itemgroup.objModel.IGMasterSeries = new List <MasterseriesModel>();
ItemMasterNew.objModel.ItemSeriesDetails = new List <MasterseriesModel>();
//Loop through the grid and get the values
for (int i = 0; i < dvgmasterSGDetails.DataRowCount; i++)
{
DataRow row = dvgmasterSGDetails.GetDataRow(i);
objSeries = new MasterseriesModel();
objSeries.MasterName = row["MasterName"].ToString() == null? string.Empty : row["MasterName"].ToString();
if (Account.objAccount.AccountId != 0 || Accountgroup.objAccGroup.GroupId != 0 || Itemgroup.ItemgrpId != 0 || ItemMasterNew.Item_Id != 0)
{
objSeries.MasterId = Convert.ToInt32(row["MasterId"].ToString() == string.Empty ? "0" : row["MasterId"]);
objSeries.ParentId = Convert.ToInt32(row["ParentId"].ToString() == string.Empty ? "0" : row["ParentId"]);
}
Account.objAccount.MasterSeries.Add(objSeries);
Accountgroup.objAccGroup.AGMasterSeries.Add(objSeries);
Itemgroup.objModel.IGMasterSeries.Add(objSeries);
ItemMasterNew.objModel.ItemSeriesDetails.Add(objSeries);
}
this.Close();
}
//Update
public bool UpdateMasterSeries(MasterseriesModel objmasmod)
{
string Query = string.Empty;
bool isUpdate = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@MasterName", objmasmod.MasterName));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@SN_Id", objmasmod.MasterId));
Query = "UPDATE masterseriesgroup SET Name=@MasterName " +
"WHERE masid=@SN_Id;";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdate = true;
}
}
catch (Exception ex)
{
isUpdate = false;
throw ex;
}
return(isUpdate);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (tbxName.Text.Equals(string.Empty))
{
MessageBox.Show("Name can not be blank!");
return;
}
MasterseriesModel objmaster = new MasterseriesModel();
objmaster.MasterName = tbxName.Text.Trim();
objmaster.MasterId = MsGId;
bool isSuccess = objmasbl.UpdateMasterSeries(objmaster);
if (isSuccess)
{
MessageBox.Show("Update Successfully!");
tbxName.Text = string.Empty;
MsGId = 0;
Administration.List.MasterseriesList frmList = new Administration.List.MasterseriesList();
frmList.StartPosition = FormStartPosition.CenterScreen;
frmList.ShowDialog();
tbxName.Focus();
FillMasterSeriesInfo();
}
}
//Save
public bool SaveMasterSeries(MasterseriesModel objmasmod)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@MasterName", objmasmod.MasterName));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
Query = "INSERT INTO masterseriesgroup (`Name`) " +
"VALUES(@MasterName)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
//get Master Series Details By Id
public MasterseriesModel GetListofMasterSeriesById(int id)
{
MasterseriesModel masterseries = new MasterseriesModel();
string Query = "SELECT * FROM masterseriesgroup WHERE masid=" + id + "";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
masterseries.MasterId = Convert.ToInt32(dr["masid"]);
masterseries.MasterName = dr["Name"].ToString();
}
return(masterseries);
}
//Get List Of Groups By Id
public ItemGroupMasterModel GetAllItemGroupById(int id)
{
ItemGroupMasterModel objIGM = new ItemGroupMasterModel();
string Query = "SELECT * FROM `ItemGroupMaster` WHERE IGM_ID=" + id + "";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objIGM.IGM_id = Convert.ToInt32(dr["IGM_ID"]);
objIGM.ItemGroup = dr["ItemGroup"].ToString();
objIGM.Alias = dr["Alias"].ToString();
objIGM.PrimaryGroup = Convert.ToBoolean(dr["PrimaryGroup"]);
objIGM.UnderGroup = dr["UnderGroup"].ToString();
objIGM.StockAccount = dr["StockAccount"].ToString();
objIGM.SalesAccount = dr["SalesAccount"].ToString();
objIGM.PurchaseAccount = dr["PurchaseAccount"].ToString();
objIGM.DefaultConfig = Convert.ToBoolean(dr["DefaultConfig"]);
objIGM.SeparateConfig = Convert.ToBoolean(dr["SeparateConfig"]);
objIGM.Parameters = Convert.ToInt32(dr["Parameters"].ToString());
objIGM.SpecifyBillReferencegrp = Convert.ToBoolean(dr["SpecifyBillReferencegrp"].ToString());
objIGM.BillReferencegrp = dr["BillReferencegrp"].ToString();
objIGM.CrDaysforSale = Convert.ToInt32(dr["CrDaysforSale"].ToString());
objIGM.CrDaysforPurc = Convert.ToInt32(dr["CrDaysforPurc"].ToString());
string MasterQuery = "SELECT * FROM masterseriesgrpdetails WHERE IGM_ID=" + id;
System.Data.IDataReader drms = _dbHelper.ExecuteDataReader(MasterQuery, _dbHelper.GetConnObject());
objIGM.IGMasterSeries = new List <MasterseriesModel>();
MasterseriesModel objMaster;
while (drms.Read())
{
objMaster = new MasterseriesModel();
objMaster.MasterId = Convert.ToInt32(drms["MasterId"]);
objMaster.ParentId = Convert.ToInt32(drms["IGM_ID"]);
objMaster.MasterName = drms["MasterName"].ToString();
objIGM.IGMasterSeries.Add(objMaster);
}
}
return(objIGM);
}
private void FillMasterSeriesInfo()
{
if (MsGId == 0)
{
tbxName.Text = string.Empty;
lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
tbxName.Focus();
return;
}
MasterseriesModel objMaster = objmasbl.GetListofMasterSeriesById(MsGId);
tbxName.Text = objMaster.MasterName;
tbxName.Focus();
lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
}
private void btnSave_Click(object sender, EventArgs e)
{
if (tbxName.Text.Equals(string.Empty))
{
MessageBox.Show("Name can not be blank!");
return;
}
MasterseriesModel objmaster = new MasterseriesModel();
objmaster.MasterName = tbxName.Text.Trim();
bool isSuccess = objmasbl.SaveMasterSeries(objmaster);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
tbxName.Text = string.Empty;
MsGId = 0;
}
}
