public static bool Update_vehicle_sale(int vehicle, int?customer_person,
int?customer_org_branch, System.DateTime sale_date, decimal sale_price, decimal road_tax_amount,
byte?road_tax_month, int?loan, decimal loan_amount, int loan_month, decimal loan_interest_percentage,
decimal loan_monthly_installment, string loan_ref_no, System.DateTime loan_approval_date,
string loan_ownership_claim_no, int?guarantor_person, int?insurance,
string insurance_cover_note_no, string insurance_endorsement_no, string insurance_policy_no,
System.DateTime insurance_date, bool insurance_type, decimal insurance_basic,
decimal insurance_sum_insured, int?insurance_comprehensive, decimal insurance_add_comprehensive,
decimal insurance_adjustment, decimal insurance_loading_age_percent, decimal insurance_loading_percent,
decimal insurance_ncd_percent, decimal insurance_stamp_duty, decimal insurance_windscreen_sum_insured,
decimal insurance_windscreen, decimal insurance_total_payable, int salesperson, string remark)
{
try
{
using (Vehicle_sale_dsTableAdapters.QueriesTableAdapter adapter = new Vehicle_sale_dsTableAdapters.QueriesTableAdapter())
{
adapter.sp_update_vehicle_sale(vehicle, customer_person, customer_org_branch,
sale_date, sale_price, road_tax_amount, road_tax_month, loan, loan_amount, loan_month,
loan_interest_percentage, loan_monthly_installment, loan_ref_no, loan_approval_date,
loan_ownership_claim_no, guarantor_person, insurance, insurance_cover_note_no,
insurance_endorsement_no, insurance_policy_no, insurance_date,
insurance_type, insurance_basic, insurance_sum_insured, insurance_comprehensive,
insurance_add_comprehensive, insurance_adjustment, insurance_loading_age_percent,
insurance_loading_percent, insurance_ncd_percent, insurance_stamp_duty,
insurance_windscreen_sum_insured, insurance_windscreen, insurance_total_payable,
salesperson, remark, Program.System_user.UserID);
return(true);
}
}
catch (System.Exception e)
{
Classes.Class_misc.Display_dataset_error(MethodBase.GetCurrentMethod(), e.Message);
}
return(false);
}
public static bool Delete_vehicle_sale(int int_vehicle)
{
try
{
using (Vehicle_sale_dsTableAdapters.QueriesTableAdapter adapter =
new Vehicle_sale_dsTableAdapters.QueriesTableAdapter())
{
adapter.sp_delete_vehicle_sale(int_vehicle, Program.System_user.UserID);
return(true);
}
}
catch (System.Exception e)
{
Classes.Class_misc.Display_dataset_error(MethodBase.GetCurrentMethod(), e.Message);
}
return(false);
}
