public void Insert_Vehicle_Log_Entry(int option, string logid, string regNo, string frmdate, string DeptCd, string DriverName, string RoadName, string lFrom, string FromTime, string lTo, string InTime, string NatureOfWork, int MilageOut, int MilageIn, int OpnBanance, int IssueInTaka, int clsBalance, int inssueinOctan, string runnigBy, int PQBAmt, string userId)
{
string query = "[Insert_Vehicle_Log_Entry] '" + option + "','" + logid + "','" + regNo + "','" + frmdate + "','" + DeptCd + "','" + DriverName + "','" + RoadName + "','" + lFrom + "','" + FromTime + "','" + lTo + "','" + InTime + "','" + NatureOfWork + "','" + MilageOut + "','" + MilageIn + "','" + OpnBanance + "','" + IssueInTaka + "','" + clsBalance + "','" + inssueinOctan + "','" + runnigBy + "','" + PQBAmt + "','" + userId + "'";
DataExecute.GetDataSet(query);
}
//insert method for inserting to table
public void InsertInsuranceInfo(int option, string Code, string Name, string Remarks, string UserId)
{
string query = "[SP_Insert_Insureance_Company_Information]'" + option + "', '" + Code + "', '" + Name + "', '" + Remarks + "', '" + UserId + "'";
DataExecute.GetDataSet(query);
}
public void InsertVehiclesFitnessInformation(int option, string Code, string RegNo, string ChesisNo, string EngineNo, string Description, int Nofseats, string Cylinder, string CC, string WeightEmpty, string WeightLoad, int NumTyres, string TyreSize, string OverhangFont, string OverhangBack, string Name, string FatherName, string Address, string Tin, string FromDate, string ToDate, string ApproveDate, string VisitDate, string VisitorName, string Designation, string AreaName, string Certificatename, string CreatedBy)
{
string query = "[Insert_Vehicles_Fiteness_Information]'" + option + "','" + Code + "', '" + RegNo + "','" + ChesisNo + "','" + EngineNo + "','" + Description + "','" + Nofseats + "','" + Cylinder + "','" + CC + "','" + WeightEmpty + "','" + WeightLoad + "','" + NumTyres + "','" + TyreSize + "','" + OverhangFont + "','" + OverhangBack + "','" + Name + "','" + FatherName + "','" + Address + "','" + Tin + "','" + FromDate + "','" + ToDate + "','" + ApproveDate + "','" + VisitDate + "','" + VisitorName + "','" + Designation + "','" + AreaName + "','" + Certificatename + "','" + CreatedBy + "'";
DataExecute.GetDataSet(query);
}
public void InsertvehiclsTaxToken(int option, string Code, string RegNo, string TaxTokenNo, string TransacTionNo, string ETrackingNo, string BankName, string BranchName, string TellerName, string ExpireDate, string IssueDate, int NoTyres, string TyreSize, string OverHangFont, string OverhangBack, string Name, string FatherName, string Address, string Tin, string FromDate, string ToDate, string ApproveDate, string VisitDate, string Visitorname, string Designation, string AreaName, string RegistrationDate, string CreatedBy)
{
string query = "[Insert_Vehicles_tax_Information]'" + option + "', '" + Code + "', '" + RegNo + "', '" + TaxTokenNo + "','" + TransacTionNo + "','" + ETrackingNo + "','" + BankName + "','" + BranchName + "','" + TellerName + "','" + ExpireDate + "','" + IssueDate + "','" + NoTyres + "','" + TyreSize + "','" + OverHangFont + "','" + OverhangBack + "','" + Name + "','" + FatherName + "','" + Address + "','" + Tin + "','" + FromDate + "','" + ToDate + "','" + ApproveDate + "','" + VisitDate + "','" + Visitorname + "','" + Designation + "','" + AreaName + "','" + RegistrationDate + "','" + CreatedBy + "'";
DataExecute.GetDataSet(query);
}
public void Insert_Vehicle_Driver_Tag_Info(int option, string Id, string DriverId, string VehicleRegNo, string UserInfo)
{
string query = "[Insert_Vehicle_Driver_Tag_Info] '" + option + "','" + Id + "','" + DriverId + "','" + VehicleRegNo + "','" + UserInfo + "'";
DataExecute.GetDataSet(query);
}
