public List <eSunSpeedDomain.MaterialCentreMasterModel> GetAllMaterials() { List <eSunSpeedDomain.MaterialCentreMasterModel> lstMaterials = new List <MaterialCentreMasterModel>(); eSunSpeedDomain.MaterialCentreMasterModel objMat; string Query = "SELECT * FROM MaterialCentreMaster"; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objMat = new MaterialCentreMasterModel(); objMat.Name = dr["Name"].ToString(); objMat.Alias = dr["Alias"].ToString(); objMat.Group = dr["PrintName"].ToString(); objMat.PrintName = dr["Group"].ToString(); objMat.StockAccount = dr["StockAccount"].ToString(); objMat.ReflectTheStockInBalanceSheet = Convert.ToBoolean(dr["Reflect_StockBalSheet"]); objMat.SalesAccount = dr["SalesAccount"].ToString(); objMat.PurchaseAccount = dr["PurchaseAccount"].ToString(); objMat.AccountinginStockTransfer = dr["Acc_StockTransfer"].ToString(); objMat.Address = dr["Address"].ToString(); lstMaterials.Add(objMat); } return(lstMaterials); }
public List <MaterialCentreMasterModel> GetAllMaterials() { List <MaterialCentreMasterModel> lstMaterials = new List <MaterialCentreMasterModel>(); MaterialCentreMasterModel objMat; string Query = "SELECT * FROM MaterialCentreMaster"; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objMat = new MaterialCentreMasterModel(); objMat.MC_Id = Convert.ToInt32(dr["MC_Id"]); objMat.Name = dr["Name"].ToString(); objMat.Alias = dr["Alias"].ToString(); objMat.PrintName = dr["PrintName"].ToString(); objMat.Group = dr["Group"].ToString(); objMat.StockAccount = dr["StockAccount"].ToString(); objMat.EnableStockinBal = Convert.ToBoolean(dr["EnableStockinBal"]); objMat.SalesAccount = dr["SalesAccount"].ToString(); objMat.PurchaseAccount = dr["PurchaseAccount"].ToString(); objMat.EnableAccinTransfer = Convert.ToBoolean(dr["EnableAccinTransfer"]); objMat.Address = dr["Address"].ToString(); objMat.Street = dr["Street"].ToString(); objMat.PinCode = dr["PinCode"].ToString(); objMat.State = dr["State"].ToString(); objMat.City = dr["City"].ToString(); objMat.Country = dr["Country"].ToString(); objMat.Mobile = dr["Mobile"].ToString(); lstMaterials.Add(objMat); } return(lstMaterials); }
private void FillMaterialCenterInfo() { if (MCId == 0) { tbxGroupName.Focus(); ClearControls(); lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; return; } MaterialCentreMasterModel objMaterial = objmatcenbl.GetAllMaterialsById(MCId); tbxGroupName.Text = objMaterial.GroupName; tbxAliasname.Text = objMaterial.Alias; tbxPrintname.Text = objMaterial.PrintName; cbxGroup.SelectedItem = objMaterial.Group; cbxStockaccount.SelectedItem = objMaterial.StockAccount; cbxreflectstockinbalancesheet.SelectedItem = Convert.ToString(objMaterial.EnableStockinBal ?"Y":"N"); cbxSaleAccount.SelectedItem = objMaterial.SalesAccount; cbxPurchaseAccount.SelectedItem = objMaterial.PurchaseAccount; cbxStockaccount.SelectedItem = objMaterial.SalesAccount; tbxAccStocktransfer.SelectedItem = Convert.ToString(objMaterial.EnableAccinTransfer ?"Y":"N"); tbxAddress.Text = objMaterial.Address; tbxAddress1.Text = objMaterial.Address1; tbxAddress2.Text = objMaterial.Address2; tbxAddress3.Text = objMaterial.Address3; lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; tbxGroupName.Focus(); }
private void btnDelete_Click(object sender, EventArgs e) { MaterialCentreMasterModel objmodel = objMatMasterBl.GetMaterialCenterByGroupname(tbxGroupName.Text.Trim()); if (objmodel.GroupName != null) { MessageBox.Show("Can Not Delete Group Name Under Tag With Item Name.." + objmodel.GroupName); tbxGroupName.Focus(); } if (objmodel.GroupName == null) { bool isDelete = MatObj.DeleteMaterialGroupById(MCGId); if (isDelete) { MessageBox.Show("Delete Successfully!"); MCGId = 0; ClearControls(); Administration.List.MaterialcentergrpList frmList = new Administration.List.MaterialcentergrpList(); frmList.StartPosition = FormStartPosition.CenterScreen; frmList.ShowDialog(); FillMaterialGroupInfo(); } } }
//List of Material Centermaster By Id public MaterialCentreMasterModel GetAllMaterialsById(int id) { MaterialCentreMasterModel objMat = new MaterialCentreMasterModel(); string Query = "SELECT * FROM `materialcentremaster` WHERE MC_Id=" + id + ""; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objMat = new MaterialCentreMasterModel(); objMat.MC_Id = Convert.ToInt32(dr["MC_Id"]); objMat.GroupName = dr["Name"].ToString(); objMat.Alias = dr["Alias"].ToString(); objMat.PrintName = dr["PrintName"].ToString(); objMat.Group = dr["Group"].ToString(); objMat.StockAccount = dr["StockAccount"].ToString(); objMat.EnableStockinBal = Convert.ToBoolean(dr["EnableStockinBal"]); objMat.SalesAccount = dr["SalesAccount"].ToString(); objMat.PurchaseAccount = dr["PurchaseAccount"].ToString(); objMat.EnableAccinTransfer = Convert.ToBoolean(dr["EnableAccinTransfer"]); objMat.Address = dr["Address"].ToString(); objMat.Address1 = dr["Address1"].ToString(); objMat.Address2 = dr["Address2"].ToString(); objMat.Address3 = dr["Address3"].ToString(); } return(objMat); }
public bool SaveMaterialMaster(MaterialCentreMasterModel objMCM) { string Query = string.Empty; bool isSaved = true; //TODO: NEED TO INCLUDE MISSING PARAMETERS try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@GroupName", objMCM.GroupName)); paramCollection.Add(new DBParameter("@Alias", objMCM.Alias)); paramCollection.Add(new DBParameter("@PrintName", objMCM.PrintName)); paramCollection.Add(new DBParameter("@Group", objMCM.Group)); paramCollection.Add(new DBParameter("@StockAccount", objMCM.StockAccount)); paramCollection.Add(new DBParameter("@EnableStockinBal", objMCM.EnableStockinBal, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@SalesAccount", objMCM.SalesAccount)); paramCollection.Add(new DBParameter("@PurchaseAccount", objMCM.PurchaseAccount)); paramCollection.Add(new DBParameter("@EnableAccinTransfer", objMCM.EnableAccinTransfer, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@Address", objMCM.Address)); paramCollection.Add(new DBParameter("@Address1", objMCM.Address1)); paramCollection.Add(new DBParameter("@Address2", objMCM.Address2)); paramCollection.Add(new DBParameter("@Address3", objMCM.Address3)); paramCollection.Add(new DBParameter("@Street", objMCM.Street)); paramCollection.Add(new DBParameter("@City", objMCM.City)); paramCollection.Add(new DBParameter("@State", objMCM.State)); paramCollection.Add(new DBParameter("@Country", objMCM.Country)); paramCollection.Add(new DBParameter("@PinCode", objMCM.PinCode)); paramCollection.Add(new DBParameter("@Mobile", objMCM.Mobile)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); Query = "INSERT INTO materialcentremaster(`Name`,`Alias`,`PrintName`,`Group`,`StockAccount`,`EnableStockinBal`,`SalesAccount`,`PurchaseAccount`," + "`EnableAccinTransfer`,`Address`,`Address1`,`Address2`,`Address3`,`Street`,`City`,`State`,`Country`,`PinCode`,`Mobile`,`CreatedBy`)" + "VALUES(@GroupName,@Alias,@PrintName,@Group,@StockAccount,@EnableStockinBal,@SalesAccount,@PurchaseAccount,@EnableAccinTransfer,@Address,@Address1,@Address2,@Address3,@Street,@City," + "@State,@Counry,@PinCode,@Mobile,@CreatedBy)"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { isSaved = true; } } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
public bool UpdateMaterialMaster(MaterialCentreMasterModel objMCM) { string Query = string.Empty; bool isSaved = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@Name", objMCM.Name)); paramCollection.Add(new DBParameter("@Alias", objMCM.Alias)); paramCollection.Add(new DBParameter("@PrintName", objMCM.PrintName)); paramCollection.Add(new DBParameter("@Group", objMCM.Group)); paramCollection.Add(new DBParameter("@StockAccount", objMCM.StockAccount)); paramCollection.Add(new DBParameter("@EnableStockinBal", objMCM.EnableStockinBal, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@SalesAccount", objMCM.SalesAccount)); paramCollection.Add(new DBParameter("@PurchaseAccount", objMCM.PurchaseAccount)); paramCollection.Add(new DBParameter("@EnableAccinTransfer", objMCM.EnableAccinTransfer, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@Address", objMCM.Address)); paramCollection.Add(new DBParameter("@Street", objMCM.Street)); paramCollection.Add(new DBParameter("@City", objMCM.City)); paramCollection.Add(new DBParameter("@State", objMCM.State)); paramCollection.Add(new DBParameter("@Country", objMCM.Country)); paramCollection.Add(new DBParameter("@PinCode", objMCM.PinCode)); paramCollection.Add(new DBParameter("@Mobile", objMCM.Mobile)); paramCollection.Add(new DBParameter("@ModifiedBy", "Admin")); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now.ToString())); paramCollection.Add(new DBParameter("@MC_Id", objMCM.MC_Id)); Query = "UPDATE MaterialCentreMaster SET [Name]=@Name,[Alias]=@Alias,[PrintName]=@PrintName,[Group]=@Group," + "[StockAccount]=@StockAccount,[EnableStockinBal]=@EnableStockinBal,[SalesAccount]=@SalesAccount,[PurchaseAccount]=@PurchaseAccount," + "[EnableAccinTransfer]=@EnableAccinTransfer,[Address]=@Address,[Street]=@Street,[City]=@City,[State]=@State,[Country]=@Country,[PinCode]=@PinCode,[Mobile]=@Mobile,[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " + " WHERE MC_Id=@MC_Id"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { isSaved = true; } } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
//Get MaterialCenter By Material Group public MaterialCentreMasterModel GetMaterialCenterByGroupname(string groupname) { MaterialCentreMasterModel objMaterial = new MaterialCentreMasterModel(); string Query = string.Empty; Query = "SELECT Name FROM `materialcentremaster` WHERE `Group`='" + groupname + "'"; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objMaterial = new eSunSpeedDomain.MaterialCentreMasterModel(); objMaterial.GroupName = dr["Name"].ToString(); } return(objMaterial); }
public bool UpdateMaterialMaster(MaterialCentreMasterModel objMCM) { string Query = string.Empty; bool isSaved = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@GroupName", objMCM.GroupName)); paramCollection.Add(new DBParameter("@Alias", objMCM.Alias)); paramCollection.Add(new DBParameter("@PrintName", objMCM.PrintName)); paramCollection.Add(new DBParameter("@Group", objMCM.Group)); paramCollection.Add(new DBParameter("@StockAccount", objMCM.StockAccount)); paramCollection.Add(new DBParameter("@EnableStockinBal", objMCM.EnableStockinBal, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@SalesAccount", objMCM.SalesAccount)); paramCollection.Add(new DBParameter("@PurchaseAccount", objMCM.PurchaseAccount)); paramCollection.Add(new DBParameter("@EnableAccinTransfer", objMCM.EnableAccinTransfer, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@Address", objMCM.Address)); paramCollection.Add(new DBParameter("@Address1", objMCM.Address1)); paramCollection.Add(new DBParameter("@Address2", objMCM.Address2)); paramCollection.Add(new DBParameter("@Address3", objMCM.Address3)); paramCollection.Add(new DBParameter("@MC_Id", objMCM.MC_Id)); Query = "UPDATE `materialcentremaster` SET `Name`=@GroupName,`Alias`=@Alias,`PrintName`=@PrintName,`Group`=@Group," + "`StockAccount`=@StockAccount,`EnableStockinBal`=@EnableStockinBal,`SalesAccount`=@SalesAccount,`PurchaseAccount`=@PurchaseAccount," + "`EnableAccinTransfer`=@EnableAccinTransfer,`Address`=@Address,`Address1`=@Address1,`Address2`=@Address2,`Address3`=@Address3 " + " WHERE `MC_Id`=@MC_Id"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { isSaved = true; } } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
private void btnSave_Click(object sender, EventArgs e) { MaterialCentreMasterModel objMaster = new MaterialCentreMasterModel(); objMaster.Name = tbxGroupName.Text.Trim(); objMaster.Alias = tbxAliasname.Text.Trim(); objMaster.PrintName = tbxPrintname.Text.Trim(); objMaster.Group = cbxGroupname.SelectedItem.ToString(); objMaster.StockAccount = cbxStockaccount.SelectedItem.ToString(); objMaster.PurchaseAccount = cbxPurchaseAccount.SelectedItem.ToString(); objMaster.SalesAccount = cbxSaleAccount.SelectedItem.ToString(); //objMaster.EnableStockinBal = cbxSalesAccount.SelectedItem.ToString() == "Y" ? true : false; //objMaster.EnableAccinTransfer = cbxStockTrans.SelectedItem.ToString() == "Y" ? true : false; objMaster.Address = tbxAddress.Text.Trim(); //objMaster.Street = tbxStreet.Text.Trim(); //CityModel objCity = (CityModel)cbxCity.SelectedItem; //objMaster.City = objCity.City_Name.ToString(); //StateModel objState = (StateModel)cbxState.SelectedItem; //objMaster.State = objState.State_Name; //objMaster.Country = cbxCountry.SelectedItem.ToString(); //objMaster.PinCode = tbxPincode.Text.Trim(); //objMaster.Mobile = tbxMobile.Text.Trim(); objMaster.CreatedBy = "Admin"; bool isSuccess = objbal.SaveMaterialMaster(objMaster); if (isSuccess) { MessageBox.Show("Saved Successfully!"); } // List<MaterialCentreMasterModel> lstMC = accObj.GetAllMaterials(); // dgvList.DataSource = lstMC; // Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!"); // d.ShowDialog(); }
public List <MaterialCentreMasterModel> GetAllMaterials() { List <MaterialCentreMasterModel> lstMaterials = new List <MaterialCentreMasterModel>(); MaterialCentreMasterModel objMat; string Query = "SELECT * FROM `materialcentremaster`"; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objMat = new MaterialCentreMasterModel(); objMat.MC_Id = Convert.ToInt32(dr["MC_Id"]); objMat.GroupName = dr["Name"].ToString(); objMat.Alias = dr["Alias"].ToString(); objMat.Group = dr["Group"].ToString(); lstMaterials.Add(objMat); } return(lstMaterials); }
private void btnUpdate_Click(object sender, EventArgs e) { MaterialCentreMasterModel objGroup = new MaterialCentreMasterModel(); objGroup.GroupName = tbxGroupName.Text.Trim(); objGroup.Alias = tbxAliasname.Text.Trim() == null ? string.Empty : tbxAliasname.Text.Trim(); objGroup.PrintName = tbxPrintname.Text.Trim() == null ? string.Empty : tbxAliasname.Text.Trim();; objGroup.Group = cbxGroup.SelectedItem.ToString(); objGroup.StockAccount = cbxStockaccount.SelectedItem.ToString(); objGroup.EnableStockinBal = cbxreflectstockinbalancesheet.SelectedItem.ToString() == "Y" ? true : false; //In Settings Check Check box This fiels Are Enable //objGroup.SalesAccount = cbxSaleAccount.SelectedItem.ToString(); //objGroup.PurchaseAccount = cbxPurchaseAccount.SelectedItem.ToString(); //objGroup.EnableAccinTransfer = tbxAccStocktransfer.Text.Trim() == "Y" ? true : false; objGroup.Address = tbxAddress.Text == null ? string.Empty : tbxAddress.Text.Trim(); objGroup.Address1 = tbxAddress1.Text == null ? string.Empty : tbxAddress1.Text.Trim(); objGroup.Address2 = tbxAddress2.Text == null ? string.Empty : tbxAddress2.Text.Trim(); objGroup.Address3 = tbxAddress3.Text == null ? string.Empty : tbxAddress3.Text.Trim(); objGroup.MC_Id = MCId; objGroup.CreatedBy = "Admin"; bool isSuccess = objmatcenbl.UpdateMaterialMaster(objGroup); if (isSuccess) { MessageBox.Show("Update Successfully!"); MCId = 0; ClearControls(); Administration.List.MaterialcenterList frmList = new Administration.List.MaterialcenterList(); frmList.StartPosition = FormStartPosition.CenterScreen; frmList.ShowDialog(); FillMaterialCenterInfo(); } }