public DataTable DocDownload(string vid)
{
string query = "SELECT VId, RegNo, RegDocFile FROM Vehicle_Registration where VId='" + vid + "'";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable GetMaxIncidentId()
{
string query = "SELECT isnull(MAX(VId),0)+1 as CountId FROM New_Incident_Info";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable GetAllVendor(int option, string VendorId)
{
string query = "[SP_Get_Vendor_Information] '" + option + "','" + VendorId + "'";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
//drop down list finding value from registration table to insurance table
public DataTable GetVehicleRegistrationNumber()
{
string query = "select regno from Vehicle_Registration ";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable GetVehicleRegistration()
{
string query = "SELECT VId, RegNo,convert(varchar(10), RegDate,121) as RegDate, LiCNo,convert(varchar(10), LicenseExDate,121) as LicenseExDate, RegTo, Address, Email, ContactNo, RegDocFile FROM Vehicle_Registration";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
//functionnal work for vehicle insurances.....
public DataTable InsuranceCompany()
{
string query = "SELECT DISTINCT[Companyname] FROM [AMS_DB]. [dbo].[Insurance_Company_Info]";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable GetMaxVehicleId()
{
string query = "SELECT isnull(MAX(VId),0)+1 as CountId FROM Vehicle_Information";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
//public DataTable GetMaxVehicleId()
//{
// string query = "SELECT isnull(MAX(VId),0)+1 as CountId FROM Vehicle_Information";
// dt = DataExecute.GetDataSet(query).Tables[0];
// return dt;
//}
public DataTable GetMaxSparepartsId()
{
string query = "SELECT isnull(MAX(Id),0)+1 as CountId FROM Spareparts_Information";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable GetAllVehicle(int option, string VNo)
{
string query = "[Get_Vehicle_Information] '" + option + "','" + VNo + "'";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable GetVendor()
{
string query = " SELECT [VendorId] ,[VendorNm] FROM [AMS_DB].[dbo].[VendorInfo] ";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable GetDriver()
{
string query = " SELECT [DriverId] FROM [AMS_DB].[dbo].[Driver_Information]";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable GetDriverr()
{
string query = "SELECT DriverId, FirstName+' '+ LastName as DriverName FROM Driver_Information";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable GetDepartment()
{
string query = "SELECT DepotId, DepotName FROM Department_Info";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable InsuranceBranchName()
{
string query = "SELECT DISTINCT [Branch] AS BranchName FROM [AMS_DB].[dbo].[Insurance_Company_BranchInfo]";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable VehicleId()
{
string query = "SELECT VId FROM Vehicle_Information";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable GetAllspareparts(int option, string Id)
{
string query = "[SP_Get_Spareparts_Information] '" + option + "','" + Id + "'";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable GetAllDriver(int option, string DriverId)
{
string query = "[Get_Driver_Information] '" + option + "','" + DriverId + "'";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable GetMaxAfterIncidentId()
{
string query = "SELECT isnull(MAX(AfterincidentId),0)+1 as CountId FROM After_Incident_Information";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable GetAllIncident(int option, string IncidentId)
{
string query = "[Get_New_Incident_Information] '" + option + "' , '" + IncidentId + "'";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable GetVehicles()
{
string query = " SELECT [VId] FROM [AMS_DB].[dbo].[Vehicle_Information] ";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable GetCategory()
{
string query = "SELECT Id, Name FROM Parts_Category";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
public DataTable GetIncident()
{
string query = " SELECT [IncidntId] FROM [AMS_DB].[dbo].[New_Incident_Info] ";
dt = DataExecute.GetDataSet(query).Tables[0];
return(dt);
}
//insert method for vehicles insurence information....
public void InsertVehiclesInsuranceInformation(int option, string code, string vehiclesRegNo, string companyName, string branchName, string PolicyNumber, string effectiveDate,
string expireDate, string grapicalArea, string issuDate, string mrNo, string notes, string createdBy)
{
string query = " [Insert_Vehicle_Insurance_Info]'" + option + "', '" + code + "', '" + vehiclesRegNo + "', '" + companyName + "', '" + branchName + "', '"
+ PolicyNumber + "', '" + effectiveDate + "','" + expireDate + "', '" + grapicalArea + "','" + issuDate + "','" + mrNo + "','" + notes + "','" + createdBy + "'";
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_Incident_info(int option, string IncidntId, string VId, string IncidentLocation, string DriverId, string PersonList, string Destination,
string CashAmt, string ProductAmt, string IncidentDate, string IncidentTime, string UserId)
{
string query = "[Insert_New_Incident] '" + option + "','" + IncidntId + "','" + VId + "','" + IncidentLocation + "','" + DriverId + "','" + PersonList + "','"
+ Destination + "','" + CashAmt + "','" + ProductAmt + "','" + IncidentDate + "','" + IncidentTime + "','" + 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_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_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_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);
}