public static DataTable Receive_Payment(WarrentyService obj) { ISalesPOSDBManager dbManager = new SalesPOSDBManager(); DataTable dt = new DataTable(); try { dbManager.Open(); IDbDataParameter[] param = SalesPOSDBManagerFactory.GetParameters(dbManager.ProviderType, 6); param[0] = dbManager.getparam("@ServiceNumber", obj.ServiceNumber); param[1] = dbManager.getparam("@PaidAmount", obj.PaidAmount); param[2] = dbManager.getparam("@Status", obj.Status); param[3] = dbManager.getparam("@CustomerID", obj.CustomerID); param[4] = dbManager.getparam("@TerminalID", bllUtility.LoggedInSystemInformation.TerminalID); param[5] = dbManager.getparam("@CreatedBy", bllUtility.LoggedInSystemInformation.LoggedUserId); IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "[update_service_payment]", param); dt = dbManager.GetDataTable(cmd); } catch (Exception ex) { throw (ex); } finally { dt.Dispose(); dbManager.Dispose(); } return(dt); }
public static DataTable Receive_Warrenty_Product(WarrentyService obj) { ISalesPOSDBManager dbManager = new SalesPOSDBManager(); DataTable dt = new DataTable(); try { dbManager.Open(); IDbDataParameter[] param = SalesPOSDBManagerFactory.GetParameters(dbManager.ProviderType, 17); param[0] = dbManager.getparam("@ProductSizeID", obj.ProductSizeID); param[1] = dbManager.getparam("@Manufacturer", obj.Manufacturer); param[2] = dbManager.getparam("@SerialNo", obj.SerialNo); param[3] = dbManager.getparam("@IsWarrentyApplicable", obj.IsWarrentyApplicable); param[4] = dbManager.getparam("@IsNewFareAdded", obj.IsNewFareAdded); param[5] = dbManager.getparam("@Status", obj.Status); param[6] = dbManager.getparam("@VehicleNo", obj.VehicleNo); param[7] = dbManager.getparam("@CustomerID", obj.CustomerID); param[8] = dbManager.getparam("@CustomerName", obj.CustomerName); param[9] = dbManager.getparam("@Address", obj.Address); param[10] = dbManager.getparam("@WarrentyExpiredDate", obj.WarrentyExpiredDate); param[11] = dbManager.getparam("@TotalServiceAmount", obj.TotalServiceAmount); param[12] = dbManager.getparam("@DiscountAmount", obj.DiscountAmount); param[13] = dbManager.getparam("@PaidAmount", obj.PaidAmount); param[14] = dbManager.getparam("@ReadyForGatePass", obj.ReadyForGatePass); param[15] = dbManager.getparam("@IsPaid", obj.IsPaid); param[16] = dbManager.getparam("@CreatedBy", bllUtility.LoggedInSystemInformation.LoggedUserId); IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "[insert_service_parent]", param); dt = dbManager.GetDataTable(cmd); } catch (Exception ex) { throw (ex); } finally { dt.Dispose(); dbManager.Dispose(); } return(dt); }