//Get All Salesman Details By Id public SalesManModel GetAllSalesManById(int id) { SalesManModel objModel = new SalesManModel(); string Query = "SELECT * FROM `SalesManMaster` WHERE SalesMan_Id=" + id + ""; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objModel.SalesMan_Id = Convert.ToInt32(dr["SalesMan_Id"]); objModel.SM_Name = dr["SM_Name"].ToString(); objModel.SM_Alias = dr["SM_Alias"].ToString(); objModel.SM_PrintName = dr["SM_PrintName"].ToString(); objModel.EnableDefCommision = Convert.ToBoolean(dr["EnableDefCommision"]); objModel.Commision_Mode = dr["Commision_Mode"].ToString(); objModel.DefCommision = Convert.ToDecimal(dr["DefCommision"]); objModel.FreezeCommision = Convert.ToBoolean(dr["FreezeCommision"]); objModel.Sales_DebitMode = dr["Sales_DebitMode"].ToString(); //objModel.Sales_ACCredited = dr["Sales_ACCredited"].ToString(); objModel.Sales_AccDebited = dr["Sales_AccDebited"].ToString(); objModel.SM_AccounttobeCredited = dr["Salesman_AccountToCredit"].ToString(); objModel.Purchase_DebitMode = dr["Purchase_DebitMode"].ToString(); //objModel.Purchase_AccCredited = dr["Purchase_DebitMode"].ToString(); objModel.Purchase_AccDebited = dr["Purchase_AccDebited"].ToString(); objModel.Address = dr["Address"].ToString(); objModel.Address1 = dr["Address1"].ToString(); objModel.Address2 = dr["Address2"].ToString(); objModel.Address3 = dr["Address3"].ToString(); objModel.Telephone = Convert.ToInt64(dr["TelNo"].ToString() == string.Empty?"0": dr["TelNo"].ToString()); objModel.Mobile = Convert.ToInt64(dr["Mobile"].ToString() == string.Empty ? "0" : dr["Mobile"].ToString()); objModel.Email = dr["EMail"].ToString(); } return(objModel); }
//Save Sales Man public bool SaveSalesMan(SalesManModel objModel) { string Query = string.Empty; bool isSaved = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@Name", objModel.SM_Name)); paramCollection.Add(new DBParameter("@Alias", objModel.SM_Alias)); paramCollection.Add(new DBParameter("@Printname", objModel.SM_PrintName)); paramCollection.Add(new DBParameter("@Enabledef", objModel.EnableDefCommision, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@Commissionmode", objModel.Commision_Mode)); paramCollection.Add(new DBParameter("@Defcommission", objModel.DefCommision, DbType.Decimal)); paramCollection.Add(new DBParameter("@Freezecommission", objModel.FreezeCommision, DbType.Boolean)); paramCollection.Add(new DBParameter("@Saledebit", objModel.Sales_DebitMode)); paramCollection.Add(new DBParameter("@SaleaccDebit", objModel.Sales_AccDebited)); paramCollection.Add(new DBParameter("@SalesmanAccountToCredit", objModel.SM_AccounttobeCredited)); paramCollection.Add(new DBParameter("@purchasedebit", objModel.Purchase_DebitMode)); paramCollection.Add(new DBParameter("@purchaseaccdebit", objModel.Purchase_AccDebited)); paramCollection.Add(new DBParameter("@Address", objModel.Address)); paramCollection.Add(new DBParameter("@Address1", objModel.Address1)); paramCollection.Add(new DBParameter("@Address2", objModel.Address2)); paramCollection.Add(new DBParameter("@Address3", objModel.Address3)); paramCollection.Add(new DBParameter("@Telenumber", objModel.Telephone)); paramCollection.Add(new DBParameter("@mobile", objModel.Mobile)); paramCollection.Add(new DBParameter("@email", objModel.Email)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); Query = "INSERT INTO salesmanmaster(`SM_Name`,`SM_Alias`,`SM_PrintName`,`EnableDefCommision`,`Commision_Mode`,`DefCommision`,`FreezeCommision`,`Sales_DebitMode`,`Sales_AccDebited`,`Salesman_AccountToCredit`,`Purchase_DebitMode`,`Purchase_AccDebited`,`Address`," + "`Address1`,`Address2`,`Address3`,`TelNo`,`Mobile`,`EMail`,`CreatedBy`) " + "VALUES(@Name,@Alias,@Printname,@Enabledef,@Commissionmode,@Defcommission,@Freezecommission,@Saledebit,@SaleaccDebit,@SalesmanAccountToCredit,@purchasedebit,@purchaseaccdebit,@Address," + "@Address1,@Address2,@Address3,@Telenumber,@mobile,@email,@CreatedBy)"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { isSaved = true; } } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
//List public List <SalesManModel> GetAllSalesMan() { List <SalesManModel> lstSaleMan = new List <SalesManModel>(); SalesManModel objModel; string Query = "SELECT * FROM SalesManMaster"; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objModel = new SalesManModel(); objModel.SalesMan_Id = Convert.ToInt32(dr["SalesMan_Id"]); objModel.SM_Name = dr["SM_Name"].ToString(); objModel.SM_Alias = dr["SM_Alias"].ToString(); objModel.SM_PrintName = dr["SM_PrintName"].ToString(); objModel.EnableDefCommision = Convert.ToBoolean(dr["EnableDefCommision"]); objModel.Commision_Mode = dr["Commision_Mode"].ToString(); objModel.DefCommision = Convert.ToDecimal(dr["DefCommision"]); objModel.FreezeCommision = Convert.ToBoolean(dr["FreezeCommision"]); objModel.Sales_DebitMode = dr["Sales_DebitMode"].ToString(); objModel.Sales_ACCredited = dr["Sales_ACCredited"].ToString(); objModel.Sales_AccDebited = dr["Sales_AccDebited"].ToString(); objModel.Purchase_DebitMode = dr["Purchase_DebitMode"].ToString(); objModel.Purchase_AccCredited = dr["Purchase_DebitMode"].ToString(); objModel.Purchase_AccDebited = dr["Purchase_AccDebited"].ToString(); objModel.Address = dr["Address"].ToString(); objModel.City = dr["City"].ToString(); objModel.State = dr["State"].ToString(); objModel.Country = dr["Country"].ToString(); objModel.State = dr["State"].ToString(); objModel.Mobile = dr["Mobile"].ToString(); lstSaleMan.Add(objModel); } return(lstSaleMan); }
//Update Sales man Details public bool UpdateSalesMan(SalesManModel objModel) { string Query = string.Empty; bool isUpdate = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@SM_Name", objModel.SM_Name)); paramCollection.Add(new DBParameter("@SM_Alias", objModel.SM_Alias)); paramCollection.Add(new DBParameter("@SM_PrintName", objModel.SM_PrintName)); paramCollection.Add(new DBParameter("@EnableDefCommision", objModel.EnableDefCommision, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@Commision_Mode", objModel.Commision_Mode)); paramCollection.Add(new DBParameter("@DefCommision", objModel.DefCommision, DbType.Decimal)); paramCollection.Add(new DBParameter("@FreezeCommision", objModel.FreezeCommision, DbType.Boolean)); paramCollection.Add(new DBParameter("@Sales_DebitMode", objModel.Sales_DebitMode)); paramCollection.Add(new DBParameter("@Sales_AccDebited", objModel.Sales_AccDebited)); paramCollection.Add(new DBParameter("@Salesman_AccountToCredit", objModel.SM_AccounttobeCredited)); paramCollection.Add(new DBParameter("@Purchase_DebitMode", objModel.Purchase_DebitMode)); paramCollection.Add(new DBParameter("@Purchase_AccDebited", objModel.Purchase_AccDebited)); paramCollection.Add(new DBParameter("@Address", objModel.Address)); paramCollection.Add(new DBParameter("@Address1", objModel.Address1)); paramCollection.Add(new DBParameter("@Address2", objModel.Address2)); paramCollection.Add(new DBParameter("@Address3", objModel.Address3)); paramCollection.Add(new DBParameter("@TelNo", objModel.Telephone)); paramCollection.Add(new DBParameter("@Mobile", objModel.Mobile)); paramCollection.Add(new DBParameter("@EMail", objModel.Email)); paramCollection.Add(new DBParameter("@ModifiedBy", "Admin")); paramCollection.Add(new DBParameter("@SM_Id", objModel.SalesMan_Id)); System.Data.IDataReader dr = _dbHelper.ExecuteDataReader("spUpdateSalesMan", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure); } catch (Exception ex) { isUpdate = false; throw ex; } return(isUpdate); }
private void FillSalesManInfo() { if (SMId == 0) { tbxName.Focus(); ClearControls(); lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; return; } SalesManModel objModel = objbl.GetAllSalesManById(SMId); tbxName.Text = objModel.SM_Name.ToString(); tbxAlias.Text = objModel.SM_Alias.ToString(); tbxPrintName.Text = objModel.SM_PrintName.ToString(); cbxEnableDefComm.SelectedItem = (objModel.EnableDefCommision) ? "Y" : "N"; cbxDefCommMode.SelectedItem = objModel.Commision_Mode.ToString(); tbxDefComm.Text = objModel.DefCommision.ToString(); cbxDefFreeze.SelectedItem = objModel.FreezeCommision ? "Y" : "N"; cbxSaleDebitMode.SelectedItem = objModel.Sales_DebitMode.ToString(); //objModel.Sales_ACCredited = dr["Sales_ACCredited"].ToString(); cbxSalesDebited.SelectedItem = objModel.Sales_AccDebited.ToString(); cbxSalesAccountCredited.SelectedItem = objModel.SM_AccounttobeCredited.ToString(); cbxPurchaseDebitMode.SelectedItem = objModel.Purchase_DebitMode.ToString(); ////objModel.Purchase_AccCredited = dr["Purchase_DebitMode"].ToString(); cbxPurchaseDebitMode.SelectedItem = objModel.Purchase_AccDebited.ToString(); tbxAddress.Text = objModel.Address.ToString(); tbxAddress1.Text = objModel.Address1.ToString(); tbxAddress2.Text = objModel.Address2.ToString(); tbxAddress3.Text = objModel.Address3.ToString(); tbxTelephone.Text = objModel.Telephone.ToString(); tbxMobile.Text = objModel.Mobile.ToString(); tbxEmail.Text = objModel.Email.ToString(); lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; tbxName.Focus(); }