public DataTable SaveProductMaster(ProductMasterModel model) { DataTable dt = new DataTable(); SqlParameter[] arrproc; string spName = "SaveProductMaster"; arrproc = new SqlParameter[16]; arrproc[0] = new SqlParameter("@ProductCategoryId", model.ProductCategoryId); arrproc[1] = new SqlParameter("@ProductSubCategoryId", model.ProductSubCategoryId); arrproc[2] = new SqlParameter("@ProductCode", model.ProductCode); arrproc[3] = new SqlParameter("@ProductName", model.ProductName); arrproc[4] = new SqlParameter("@ProductDescription", model.ProductDescription); arrproc[5] = new SqlParameter("@ProductCompanyId", model.ProductCompanyId); arrproc[6] = new SqlParameter("@Packing", model.Packing); arrproc[7] = new SqlParameter("@PurchaseUnitId", model.PurchaseUnitId); arrproc[8] = new SqlParameter("@SalesUnitId", model.SalesUnitId); arrproc[9] = new SqlParameter("@PuchaseTaxId", model.PuchaseTaxId); arrproc[10] = new SqlParameter("@SaleTaxId", model.SaleTaxId); arrproc[11] = new SqlParameter("@TaxAplicability", model.TaxAplicability); arrproc[12] = new SqlParameter("@HSNCode", model.HSNCode); arrproc[13] = new SqlParameter("@SACCode", model.SACCode); arrproc[14] = new SqlParameter("@IsActive", model.IsActive); arrproc[15] = new SqlParameter("@CreatedBy", model.UserId); ADOContext _dbContext = new ADOContext(); dt = _dbContext.ExecSQLProc(spName, arrproc); return(dt); }
public static DataTable GetUserData(int ModuleID) { SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ModuleID", ModuleID); ADOContext dut = new ADOContext(); DataTable dtdata = new DataTable(); dtdata = dut.ExecSQLProc("USP_GETCategoryDropDown", param); return(dtdata); }
public DataTable BindDropdown(string Flag, string Param1 = null, string Param2 = null) { DataTable dt = new DataTable(); SqlParameter[] arrproc; string spName = "BindDropDown"; arrproc = new SqlParameter[3]; arrproc[0] = new SqlParameter("@Flag", Flag); arrproc[1] = new SqlParameter("@Param1", Param1); arrproc[2] = new SqlParameter("@Param2", Param2); dt = _dbContext.ExecSQLProc(spName, arrproc); return(dt); }
public DataTable GetProductMaster(ProductMasterModel model) { DataTable dt = new DataTable(); SqlParameter[] arrproc; string spName = "GetProductMaster"; ADOContext _dbContext = new ADOContext(); arrproc = new SqlParameter[7]; arrproc[0] = new SqlParameter("@PageNumber", model.PageNumber); arrproc[1] = new SqlParameter("@RecordSize", model.RecordSize); arrproc[2] = new SqlParameter("@ProductCategoryId", model.ProductCategoryId); arrproc[3] = new SqlParameter("@ProductSubCategoryId", model.ProductSubCategoryId); arrproc[4] = new SqlParameter("@ProductCode", model.ProductCode); arrproc[5] = new SqlParameter("@ProductName", model.ProductName); arrproc[6] = new SqlParameter("@ProductCompanyId", model.ProductCompanyId); dt = _dbContext.ExecSQLProc(spName, arrproc); return(dt); }
public bool ValidateSaleData(Int64 UserId, int SaleType) { SqlParameter[] arrproc; bool IsValid = false; string spName = "ValidateSaleData"; arrproc = new SqlParameter[2]; arrproc[0] = new SqlParameter("@UserId", UserId); arrproc[1] = new SqlParameter("@SaleType", SaleType); DataTable dt = _dbContext.ExecSQLProc(spName, arrproc); if (dt != null && dt.Rows.Count > 0) { IsValid = Convert.ToBoolean(dt.Rows[0]["IsValid"]); } return(IsValid); }