public static List <VehicleMasterVM> GetVehicleMaster(VehicleMasterVM o)
{
o = o ?? new VehicleMasterVM();
Dictionary <string, string> input = new Dictionary <string, string>()
{
{ "VehicleID", o.VehicleID ?? "" },
{ "VehicleDescription", o.VehicleDescription ?? "" },
{ "RegistrationNo", o.RegistrationNo ?? "" },
{ "Model", o.Model ?? "" },
{ "PurchaseValue", o.PurchaseValue ?? "" },
{ "PurchaseDate", o.PurchaseDate ?? "" },
{ "RegExpirydate", o.RegExpirydate ?? "" },
{ "VehicleTypeID", o.VehicleTypeID ?? "" },
{ "InsuranceExpDate", o.InsuranceExpDate ?? "" },
{ "AcCompanyID", o.AcCompanyID ?? "" },
{ "Mode", o.Mode ?? "" },
{ "FinanceCompany", o.FinanceCompany ?? "" },
{ "InsuranceCompName", o.InsuranceCompName ?? "" },
{ "PolicyNo", o.PolicyNo ?? "" },
{ "InsuredValue", o.InsuredValue ?? "" },
{ "Category", o.Category ?? "" },
{ "DepreciationDate", o.DepreciationDate ?? "" },
{ "ScrapValue", o.ScrapValue ?? "" },
{ "BranchID", o.BranchID ?? "" },
{ "MakeYear", o.MakeYear ?? "" },
{ "RegisteredUnder", o.RegisteredUnder ?? "" },
{ "TDDate", o.TDDate ?? "" },
{ "RouteID", o.RouteID ?? "" },
{ "eMode", o.eMode ?? "" },
};
return(pgFun.GetData <VehicleMasterVM>("[dbo].[usp_VehicleMaster_Get]", input));
}
public static string ManageVehicleMaster(VehicleMasterVM o)
{
o = o ?? new VehicleMasterVM();
string Res = "Error";
try
{
Dictionary <string, string> input = new Dictionary <string, string>()
{
{ "VehicleID", o.VehicleID ?? "" },
{ "VehicleDescription", o.VehicleDescription ?? "" },
{ "RegistrationNo", o.RegistrationNo ?? "" },
{ "Model", o.Model ?? "" },
{ "PurchaseValue", o.PurchaseValue ?? "" },
{ "PurchaseDate", o.PurchaseDate ?? "" },
{ "RegExpirydate", o.RegExpirydate ?? "" },
{ "VehicleTypeID", o.VehicleTypeID ?? "" },
{ "InsuranceExpDate", o.InsuranceExpDate ?? "" },
{ "AcCompanyID", o.AcCompanyID ?? "" },
{ "Mode", o.Mode ?? "" },
{ "FinanceCompany", o.FinanceCompany ?? "" },
{ "InsuranceCompName", o.InsuranceCompName ?? "" },
{ "PolicyNo", o.PolicyNo ?? "" },
{ "InsuredValue", o.InsuredValue ?? "" },
{ "Category", o.Category ?? "" },
{ "DepreciationDate", o.DepreciationDate ?? "" },
{ "ScrapValue", o.ScrapValue ?? "" },
{ "BranchID", o.BranchID ?? "" },
{ "MakeYear", o.MakeYear ?? "" },
{ "RegisteredUnder", o.RegisteredUnder ?? "" },
{ "eMode", o.eMode ?? "" },
};
Dictionary <string, string> output = new Dictionary <string, string>()
{
{ "Result", "" }
};
Dictionary <string, string> res = pgFun.ExecuteSQL("[dbo].[usp_VehicleMaster_Manage]", input, output, true);
int LastID = 0;
bool isdone = int.TryParse(res["Result"], out LastID);
if (isdone)
{
Res = res["Result"];
}
else
{
Res = res["Result"];
}
return(Res);
}
catch (Exception p)
{
return(p.Message);
}
}
