//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();
}
