//DELI_WARR MODULE // For validating a booking ID public bool bus_validate(Booking_entity book) { try { bool t; SqlParameter g = new SqlParameter(); g = new SqlParameter("@B_id", book.B_Id); t = bookdal.dal_validate(g); return(t); } catch (Exception ex) { throw new Exception(ex.Message); } }
//Getting a new vehicle ID public int bus_get_vid(Booking_entity book) { try { int t; SqlParameter g = new SqlParameter(); g = new SqlParameter("@C_id", book.C_Id); t = bookdal.dal_get_vid(g); return(t); } catch (Exception ex) { throw new Exception(ex.Message); } }
//Inserting data in Vehicle details table public void bus_insert_vd(Booking_entity book) { try { SqlParameter[] a = new SqlParameter[3]; a[0] = new SqlParameter("@vid", book.vid); a[1] = new SqlParameter("@cid", book.C_Id); a[2] = new SqlParameter("@chasis", book.chasis); bookdal.dal_inser_vd(a); } catch (Exception ex) { throw new Exception(ex.Message); } }
//For displaying data through pre-population in Insurance public List <string> display1(Booking_entity book) { try { SqlParameter g = new SqlParameter(); g = new SqlParameter("@C_id", book.C_Id); List <string> li = new List <string>(); li = bookdal.display1(g); return(li); } catch (Exception ex) { throw new Exception(ex.Message); } }
// Getting date of delivery public string bus_get_dod(Booking_entity book) { try { string t; SqlParameter g = new SqlParameter(); g = new SqlParameter("@b_id", book.B_Id); t = bookdal.dal_get_dod(g); return(t); } catch (Exception ex) { throw new Exception(ex.Message); } }
//For creating new policy iD public string bus_new_plcy(Booking_entity book) { try { SqlParameter a = new SqlParameter(); int code; a = new SqlParameter("@new_pid", SqlDbType.Int, 20); a.Direction = ParameterDirection.Output; code = bookdal.dal_new_plcy(a); return("PLCY-" + code); } catch (Exception ex) { throw new Exception(ex.Message); } }
//Inserting data into customer purchase details public void bus_insert_cpd(Booking_entity book) { try { SqlParameter[] a = new SqlParameter[9]; a[0] = new SqlParameter("@Customer_Id", book.C_Id); a[1] = new SqlParameter("@Customer_name", book.cust_name); a[2] = new SqlParameter("@Email_Id", book.email_id); a[3] = new SqlParameter("@Contact", book.contact); a[4] = new SqlParameter("@Address", book.address); a[5] = new SqlParameter("@Pincode", book.pincode); a[6] = new SqlParameter("@Model_No", book.model_number); a[7] = new SqlParameter("@Date_of_Delivery", book.edod); a[8] = new SqlParameter("@Warranty_expiry_date", book.wed); bookdal.dal_insert_cpd(a); } catch (Exception ex) { throw new Exception(ex.Message); } }
//For inserting data in Booking Table public void bus_booking1(Booking_entity book) { try { SqlParameter[] a = new SqlParameter[9]; a[0] = new SqlParameter("@Booking_Id", book.B_Id); a[1] = new SqlParameter("@Customer_name", book.cust_name); a[2] = new SqlParameter("@Email_Id", book.email_id); a[3] = new SqlParameter("@Contact", book.contact); a[4] = new SqlParameter("@Address", book.address); a[5] = new SqlParameter("@Pincode", book.pincode); a[6] = new SqlParameter("@Model_No", book.model_number); a[7] = new SqlParameter("@Date_of_Booking", book.dob); a[8] = new SqlParameter("@Expected_Date_of_Delivery", book.edod); bookdal.dal_booking1(a); } catch (Exception ex) { throw new Exception(ex.Message); } }