private void btnSave_Click(object sender, EventArgs e) { ItemGroupMasterModel objModel = new ItemGroupMasterModel(); objModel.ItemGroup = tbxGroupName.Text.Trim(); objModel.Alias = tbxAliasname.Text.Trim(); objModel.PrimaryGroup = cbxPrimarygroup.SelectedItem.ToString() == "Y" ? true : false; objModel.UnderGroup = cbxUndergroup.SelectedItem.ToString(); objModel.StockAccount = cbxStockaccount.SelectedItem.ToString(); objModel.SalesAccount = cbxSalesaccount.SelectedItem.ToString(); objModel.PurchaseAccount = cbxPurchaseAccount.SelectedItem.ToString(); objModel.CreatedBy = "Admin"; bool isSuccess = objItemBL.SaveIGM(objModel); if (isSuccess) { MessageBox.Show("Saved Successfully!"); } //List<ItemGroupMasterModel> lstItems = objItemBL.GetAllItemGroup(); //dgvList.DataSource = lstItems; //Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!"); //d.ShowDialog(); }
//Save public bool SaveIGM(ItemGroupMasterModel objIGM) { string Query = string.Empty; bool isSaved = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@ItemGroup", objIGM.ItemGroup)); paramCollection.Add(new DBParameter("@Alias", objIGM.Alias)); paramCollection.Add(new DBParameter("@PrimaryGroup", objIGM.PrimaryGroup, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@UnderGroup", objIGM.UnderGroup)); paramCollection.Add(new DBParameter("@StockAccount", objIGM.StockAccount)); paramCollection.Add(new DBParameter("@SalesAccount", objIGM.SalesAccount)); paramCollection.Add(new DBParameter("@PurchaseAccount", objIGM.PurchaseAccount)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); Query = "INSERT INTO ItemGroupMaster (`ItemGroup`,`Alias`,`PrimaryGroup`,`UnderGroup`,`StockAccount`,`SalesAccount`,`PurchaseAccount`,`CreatedBy`) " + "VALUES(@ItemGroup,@Alias,@PrimaryGroup,@UnderGroup,@StockAccount,@SalesAccount,@PurchaseAccount,@CreatedBy)"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { isSaved = true; } } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
//List public List <ItemGroupMasterModel> GetAllItemGroup() { List <eSunSpeedDomain.ItemGroupMasterModel> lstIGM = new List <ItemGroupMasterModel>(); eSunSpeedDomain.ItemGroupMasterModel objIGM; string Query = "SELECT * FROM ItemGroupMaster"; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objIGM = new ItemGroupMasterModel(); 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(); lstIGM.Add(objIGM); } return(lstIGM); }
//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); }
//Save public bool SaveIGM(ItemGroupMasterModel objIGM) { string Query = string.Empty; bool isSaved = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@ItemGroup", objIGM.ItemGroup)); paramCollection.Add(new DBParameter("@Alias", objIGM.Alias)); paramCollection.Add(new DBParameter("@PrimaryGroup", objIGM.PrimaryGroup, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@UnderGroup", objIGM.UnderGroup)); paramCollection.Add(new DBParameter("@StockAccount", objIGM.StockAccount)); paramCollection.Add(new DBParameter("@SalesAccount", objIGM.SalesAccount)); paramCollection.Add(new DBParameter("@PurchaseAccount", objIGM.PurchaseAccount)); paramCollection.Add(new DBParameter("@DefaultConfig", objIGM.DefaultConfig, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@SeparateConfig", objIGM.SeparateConfig, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@Parameters", objIGM.Parameters)); paramCollection.Add(new DBParameter("@SpecifyBillReferencegrp", objIGM.SpecifyBillReferencegrp, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@BillReferencegrp", objIGM.BillReferencegrp)); paramCollection.Add(new DBParameter("@CrDaysforSale", objIGM.CrDaysforSale, System.Data.DbType.Decimal)); paramCollection.Add(new DBParameter("@CrDaysforPurc", objIGM.CrDaysforPurc, System.Data.DbType.Decimal)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); Query = "INSERT INTO itemgroupmaster (`ItemGroup`,`Alias`,`PrimaryGroup`,`UnderGroup`,`StockAccount`,`SalesAccount`,`PurchaseAccount`,`DefaultConfig`,`SeparateConfig`," + "`Parameters`,`SpecifyBillReferencegrp`,`BillReferencegrp`,`CrDaysforSale`,`CrDaysforPurc`,`CreatedBy`) " + "VALUES(@ItemGroup,@Alias,@PrimaryGroup,@UnderGroup,@StockAccount,@SalesAccount,@PurchaseAccount,@DefaultConfig,@SeparateConfig,@Parameters," + "@SpecifyBillReferencegrp,@BillReferencegrp,@CrDaysforSale,@CrDaysforPurc,@CreatedBy)"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { SaveIGMasterSeriesGroup(objIGM.IGMasterSeries); } isSaved = true; } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
private void FillItemGroupInfo() { if (ItemgrpId == 0) { lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; ClearControls(); tbxGroupName.Focus(); return; } objModel = objItemBL.GetAllItemGroupById(ItemgrpId); tbxGroupName.Text = objModel.ItemGroup; tbxAliasname.Text = objModel.Alias; cbxPrimarygroup.SelectedItem = Convert.ToString((objModel.PrimaryGroup)?"Y":"N"); cbxUndergroup.SelectedItem = objModel.UnderGroup; cbxStockaccount.SelectedItem = objModel.StockAccount; cbxSalesaccount.SelectedItem = objModel.SalesAccount; cbxPurchaseAccount.SelectedItem = objModel.PurchaseAccount; if (objModel.DefaultConfig) { rbnDefaultConfig.SelectedIndex = 0; } if (objModel.SeparateConfig) { rbnDefaultConfig.SelectedIndex = 1; } cbxTagBillReference.SelectedItem = objModel.SpecifyBillReferencegrp ? "Y" : "N"; cbxBillReferenceGroup.Text = objModel.BillReferencegrp.ToString(); tbxCrDaysforSale.Text = objModel.CrDaysforSale.ToString(); tbxCrDaysforPurc.Text = objModel.CrDaysforPurc.ToString(); tbxParameters.Text = Convert.ToString(objModel.Parameters); lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; tbxGroupName.Focus(); }
//Update public bool UpdateIGM(ItemGroupMasterModel objIGM) { string Query = string.Empty; bool isUpdate = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@ItemGroup", objIGM.ItemGroup)); paramCollection.Add(new DBParameter("@Alias", objIGM.Alias)); paramCollection.Add(new DBParameter("@PrimaryGroup", objIGM.PrimaryGroup, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@UnderGroup", objIGM.UnderGroup)); paramCollection.Add(new DBParameter("@StockAccount", objIGM.StockAccount)); paramCollection.Add(new DBParameter("@SalesAccount", objIGM.SalesAccount)); paramCollection.Add(new DBParameter("@PurchaseAccount", objIGM.PurchaseAccount)); paramCollection.Add(new DBParameter("@ModifiedBy", "Admin")); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now)); paramCollection.Add(new DBParameter("@IGM_Id", objIGM.IGM_id)); Query = "UPDATE ItemGroupMaster SET [ItemGroup]=@ItemGroup,[Alias]=@Alias,[PrimaryGroup]=@PrimaryGroup,[UnderGroup]=@UnderGroup,[StockAccount]=@StockAccount,[SalesAccount]=@SalesAccount," + "[PurchaseAccount]=@PurchaseAccount,[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " + "WHERE IGM_Id=@IGM_Id"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { isUpdate = true; } } catch (Exception ex) { isUpdate = false; throw ex; } return(isUpdate); }
//List public List <ItemGroupMasterModel> GetAllItemGroup() { List <eSunSpeedDomain.ItemGroupMasterModel> lstIGM = new List <ItemGroupMasterModel>(); eSunSpeedDomain.ItemGroupMasterModel objIGM; string Query = "SELECT DISTINCT IGM_ID,ItemGroup,PrimaryGroup,UnderGroup FROM `ItemGroupMaster`"; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objIGM = new ItemGroupMasterModel(); objIGM.IGM_id = Convert.ToInt32(dr["IGM_ID"]); objIGM.ItemGroup = dr["ItemGroup"].ToString(); objIGM.PrimaryGroup = Convert.ToBoolean(dr["PrimaryGroup"]); objIGM.UnderGroup = dr["UnderGroup"].ToString(); lstIGM.Add(objIGM); } return(lstIGM); }
//Update public bool UpdateIGM(ItemGroupMasterModel objIGM) { string Query = string.Empty; bool isUpdate = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@ItemGroup", objIGM.ItemGroup)); paramCollection.Add(new DBParameter("@Alias", objIGM.Alias)); paramCollection.Add(new DBParameter("@PrimaryGroup", objIGM.PrimaryGroup, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@UnderGroup", objIGM.UnderGroup)); paramCollection.Add(new DBParameter("@StockAccount", objIGM.StockAccount)); paramCollection.Add(new DBParameter("@SalesAccount", objIGM.SalesAccount)); paramCollection.Add(new DBParameter("@PurchaseAccount", objIGM.PurchaseAccount)); paramCollection.Add(new DBParameter("@DefaultConfig", objIGM.DefaultConfig, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@SeparateConfig", objIGM.SeparateConfig, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@Parameters", objIGM.Parameters)); paramCollection.Add(new DBParameter("@SpecifyBillReferencegrp", objIGM.SpecifyBillReferencegrp, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@BillReferencegrp", objIGM.BillReferencegrp)); paramCollection.Add(new DBParameter("@CrDaysforSale", objIGM.CrDaysforSale, System.Data.DbType.Decimal)); paramCollection.Add(new DBParameter("@CrDaysforPurc", objIGM.CrDaysforPurc, System.Data.DbType.Decimal)); paramCollection.Add(new DBParameter("@ModifiedBy", "Admin")); paramCollection.Add(new DBParameter("@IGM_Id", objIGM.IGM_id)); Query = "UPDATE ItemGroupMaster SET ItemGroup=@ItemGroup,Alias=@Alias,`PrimaryGroup`=@PrimaryGroup,UnderGroup=@UnderGroup,StockAccount=@StockAccount,SalesAccount=@SalesAccount," + "PurchaseAccount=@PurchaseAccount,`DefaultConfig`=@DefaultConfig,`SeparateConfig`=@SeparateConfig,Parameters=@Parameters,ModifiedBy=@ModifiedBy," + "SpecifyBillReferencegrp=@SpecifyBillReferencegrp,BillReferencegrp=@BillReferencegrp,CrDaysforSale=@CrDaysforSale,CrDaysforPurc=@CrDaysforPurc " + "WHERE IGM_Id=@IGM_Id"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { List <MasterseriesModel> lstSeries = new List <MasterseriesModel>(); foreach (MasterseriesModel objMaster in objIGM.IGMasterSeries) { objMaster.ParentId = objIGM.IGM_id; if (objMaster.MasterId > 0) { paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@ParentId", objMaster.ParentId)); paramCollection.Add(new DBParameter("@SeriesId", objMaster.MasterId)); paramCollection.Add(new DBParameter("@MasterName", objMaster.MasterName)); paramCollection.Add(new DBParameter("@CreatedBy", "")); paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@ModifiedBy", "Admin")); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime)); System.Data.IDataReader drmg = _dbHelper.ExecuteDataReader("spUpdateIGMasterSeriesGroup", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure); isUpdate = true; } else { paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@AccountId", "0", DbType.Int32)); paramCollection.Add(new DBParameter("@AccountGroupId", "0", DbType.Int32)); paramCollection.Add(new DBParameter("@ItemId", "0", DbType.Int32)); paramCollection.Add(new DBParameter("@ItemGroupId", objMaster.ParentId)); paramCollection.Add(new DBParameter("@MaterialCenterId", "0", DbType.Int32)); paramCollection.Add(new DBParameter("@MaterialCenterGroupId", "0", DbType.Int32)); paramCollection.Add(new DBParameter("@CostCenterId", "0", DbType.Int32)); paramCollection.Add(new DBParameter("@CostCenterGroupId", "0", DbType.Int32)); paramCollection.Add(new DBParameter("@BillSundaryId", "0", DbType.Int32)); paramCollection.Add(new DBParameter("@SaleId", "0", DbType.Int32)); paramCollection.Add(new DBParameter("@PurcId", "0", DbType.Int32)); paramCollection.Add(new DBParameter("@MasterName", objMaster.MasterName)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@ModifiedBy", string.Empty)); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime)); System.Data.IDataReader dr = _dbHelper.ExecuteDataReader("spInsertMasterSeriesGroupDetails", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure); isUpdate = true; } } isUpdate = true; } } catch (Exception ex) { isUpdate = false; throw ex; } return(isUpdate); }