public DataTable GetPaymentDetails(frmAddProductModel model) { try { DbCommand dbcommand = database.GetStoredPocCommand("Sp_GetPaymentDetails"); database.AddInParameter(dbcommand, "@CustProdcutID", DbType.String, model.CustProductId); dt = database.ExecuteDataTable(dbcommand); return(dt); } catch (Exception) { throw; } }
public DataTable GetCutomerDetails(frmAddProductModel model) { try { DbCommand dbcommand = database.GetStoredPocCommand("SP_GetCutomerDetails"); database.AddInParameter(dbcommand, "@SearchText", DbType.String, model.CustmoerName); dt = database.ExecuteDataTable(dbcommand); return(dt); } catch (Exception) { throw; } }
public int InsertProductDeatils(frmAddProductModel model) { try { DbCommand dbcommand = database.GetStoredPocCommand("SP_InsertProductDeatils"); database.AddInParameter(dbcommand, "@Warrenty", DbType.Int32, model.warrenty); database.AddInParameter(dbcommand, "@CustProductID", DbType.Int32, model.CustProductId); database.AddInParameter(dbcommand, "@CustId", DbType.Int32, model.CustId); database.AddInParameter(dbcommand, "@ProductID", DbType.Int32, model.ProductID); database.AddInParameter(dbcommand, "@BrandID", DbType.Int32, model.BrandID); database.AddInParameter(dbcommand, "@CapacityID", DbType.Int32, model.CapacityID); database.AddInParameter(dbcommand, "@ProductCost", DbType.String, model.ProductCost); database.AddInParameter(dbcommand, "@ReminderDate", DbType.String, model.ReminderDate); database.AddInParameter(dbcommand, "@PurchesDate", DbType.String, model.PurchesDate); database.AddInParameter(dbcommand, "@EngineerID", DbType.Int32, model.EngineerID); database.AddInParameter(dbcommand, "@ThirdPartyID", DbType.Int32, model.ThirdPartyID); result = database.ExecuteNonQuery(dbcommand); return(result); } catch (Exception) { throw; } }