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; } }