public void Insert_driver_info(int option, string DrverId, string FirstName, string LastName, string PresentAddress, string Permanentaddress, string NID, string LicenseNo, string Depot, string mobile, string BloodGrp, string RefPerson, string experience, string remarks, string UserId)
{
string query = "[Insert_Driver_Information] '" + option + "','" + DrverId + "','" + FirstName + "','" + LastName + "','" + PresentAddress + "','" + Permanentaddress + "','" + NID + "','" + LicenseNo + "','" + Depot + "','" + mobile + "','" + BloodGrp + "','" + RefPerson + "','" + experience + "','" + remarks + "','" + UserId + "'";
DataExecute.GetDataSet(query);
}
public void Insert_spreparts_info(int option, string Id, string Name, string Category, string UserId)
{
string query = "[Insert_Spareparts_Information] '" + option + "','" + Id + "','" + Name + "','" + Category + "','" + UserId + "'";
DataExecute.GetDataSet(query);
}
public void Insert_After_Incident(int option, string AfterincidentId, string IncidentId, string RepairStatus, string Compensation, string Cost, string User)
{
string query = "[Insert_After_Incident] '" + option + "','" + AfterincidentId + "','" + IncidentId + "','" + RepairStatus + "','" + Compensation + "','" + Cost + "','" + User + "'";
DataExecute.GetDataSet(query);
}
public void Insert_Registration_info(int option, string VId, string RegNo, string RegDate, string LiCNo, string LicenseExDate, string RegTo, string Address, string Email, string ContactNo, byte[] RegDocFile, string UserId)
{
string query = "[Insert_Vehicle_Registration]'" + option + "','" + VId + "','" + RegNo + "','" + RegDate + "','" + LiCNo + "','" + LicenseExDate + "','" + RegTo + "','" + Address + "','" + Email + "','" + ContactNo + "','" + RegDocFile + "','" + UserId + "'";
DataExecute.GetDataSet(query);
}
public void Insert_Vehicle_info(int option, string VId, string VNo, string ModelNo, string ModelYear, string ChassisNo, string BrandName, string VType, string BodyType, string BodyColor, string TireSize, string FuelType, string PurchaseDate, string SeatingCapacity, Decimal Price, string Waranty, string CylinderSize, string Depot, string VendorId, string UserId)
{
string query = "[Insert_Vehicle_Information] '" + option + "','" + VId + "','" + VNo + "','" + ModelNo + "','" + ModelYear + "','" + ChassisNo + "','" + BrandName + "','" + VType + "','" + BodyType + "','" + BodyColor + "','" + TireSize + "','" + FuelType + "','" + PurchaseDate + "','" + SeatingCapacity + "','" + Price + "','" + Waranty + "','" + CylinderSize + "','" + Depot + "','" + VendorId + "','" + UserId + "'";
DataExecute.GetDataSet(query);
}
public void Insert_spreparts_info(int option, string Id, string Name, string Category, string SerialNo, string WarrantyPeriod, string Remarks, string UserId)
{
string query = "[Insert_Spareparts_Information] '" + option + "','" + Id + "','" + Name + "','" + Category + "','" + SerialNo + "','" + WarrantyPeriod + "','" + Remarks + "','" + UserId + "'";
DataExecute.GetDataSet(query);
}
public void Insert_vendor_info(int option, string VendorId, string VendorNm, string Mobile, string Email, string Add1, string Add2, string Country, string City, string PostalCode, string UserId)
{
string query = "[SP_Insert_Vendor_Information] '" + option + "','" + VendorId + "','" + VendorNm + "','" + Mobile + "','" + Email + "','" + Add1 + "','" + Add2 + "','" + Country + "','" + City + "','" + PostalCode + "','" + UserId + "'";
DataExecute.GetDataSet(query);
}