public string GetInvoiceIdFromJobCard_v1(int jobcard, bool isfromInvoice, int type = 1)
{
string InvoiceId = "";
dbConnection dbCon = new dbConnection();
ServiceMethods ServiceMethod = new ServiceMethods();
if (isfromInvoice)
{
string query = "Select top 1 [GstInvoiceNumber] from Invoice where JobCardId=@1 and type=" + type + " and GstInvoiceNumber is not null order by Id desc";
string[] param = { jobcard.ToString() };
DataTable dt = dbCon.GetDataTableWithParams(query, param);
if (dt != null && dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
InvoiceId = dr["GstInvoiceNumber"].ToString();
}
}
return(InvoiceId);
}
public string GetInvoiceDateFromJobCard_v1(int jobcard, bool isfromInvoice, int type = 1)
{
string InvoiceId = "";
dbConnection dbCon = new dbConnection();
ServiceMethods ServiceMethod = new ServiceMethods();
if (isfromInvoice)
{
string query = "Select top 1 NULLIF(DOC,'') as DOC from Invoice where JobCardId=@1 and type=" + type + " order by Id desc";
string[] param = { jobcard.ToString() };
DataTable dt = dbCon.GetDataTableWithParams(query, param);
if (dt != null && dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
DateTime dtDate = Convert.ToDateTime(dr["DOC"]);
InvoiceId = ServiceMethod.JobCardDateFormatWithTime(dtDate);
}
}
return(InvoiceId);
}
public string GetJobCardDate(int jobcardId)
{
dbConnection dbCon = new dbConnection();
ServiceMethods ServiceMethod = new ServiceMethods();
string name = "";
if (jobcardId > 0)
{
string query = "Select Isnull(DOC,'') as DOC from JobCard where JobCard.Id=@1";
string[] param = { jobcardId.ToString() };
DataTable dt = dbCon.GetDataTableWithParams(query, param);
if (dt != null && dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
name = dr["DOC"].ToString();
DateTime dtDate = Convert.ToDateTime(dr["DOC"]);
name = ServiceMethod.JobCardDateFormatWithTime(dtDate);
// name = ServiceMethod.DOBFormat(name);
}
}
return(name);
}
public List <string> HavingInsuranceDetailsWithJobCard(string JobCardId, bool FromInvoice = false, int Type = 1)
{
List <string> strLst = new List <string>();
dbConnection dbCon = new dbConnection();
ServiceMethods ServiceMethod = new ServiceMethods();
bool HavingInsurance = false;
var customerJobCardDetails = new ServiceClass.CustomerJobCardDetails();
var notes = ServiceMethod.GetCustomerNoteInJobCardList(JobCardId.ToString());
var Customer = ServiceMethod.GetCustomerByJobCardId(JobCardId.ToString());
var Vehicle = ServiceMethod.GetVehicleByJobCardId(JobCardId.ToString());
#region Having Insurance
DataTable dataTableWithParams1 = dbCon.GetDataTableWithParams("Select Id, JobStatus_Id, DOC, DOM,Vehicle_Id,Customer_Id, Job_Close_Date as CloseDate, UserId from JobCard where IsDelete=0 and Id=@1", new string[1]
{
JobCardId.ToString()
});
if (dataTableWithParams1 != null)
{
if (dataTableWithParams1.Rows.Count > 0)
{
int int32_1 = Convert.ToInt32(JobCardId);
DataRow row1 = dataTableWithParams1.Rows[0];
customerJobCardDetails.JobCardId = row1["Id"].ToString();
customerJobCardDetails.JobCardStatus = ServiceMethod.GetJobStatus(row1["JobStatus_Id"].ToString());
DateTime dateTime1 = Convert.ToDateTime(row1["DOC"]);
customerJobCardDetails.DateOfCreate = ServiceMethod.JobCardDateFormatWithTime(dateTime1);
if (!string.IsNullOrEmpty(row1["CloseDate"].ToString()))
{
DateTime dateTime2 = Convert.ToDateTime(row1["CloseDate"]);
try
{
customerJobCardDetails.DateOfClose = ServiceMethod.JobCardDateFormatWithTime(dateTime2);
}
catch (Exception ex)
{
customerJobCardDetails.DateOfClose = "";
}
}
if (!string.IsNullOrEmpty(row1["Vehicle_Id"].ToString()))
{
int int32_2 = Convert.ToInt32(row1["Vehicle_Id"]);
if (int32_2 > 0)
{
ServiceClass.Vehicle vehicleById = ServiceMethod.GetVehicleById(int32_2.ToString());
customerJobCardDetails.VehicleId = vehicleById.Id;
customerJobCardDetails.VehicleNo = vehicleById.Number;
customerJobCardDetails.VehicleName = vehicleById.Name;
customerJobCardDetails.ChasisNumber = vehicleById.ChasisNumber;
customerJobCardDetails.VehicleBrand = vehicleById.VehicleBrand;
customerJobCardDetails.VehicleModel = vehicleById.VehicleModel;
customerJobCardDetails.VehicleVariant = vehicleById.VehicleVariant;
// customerJobCardDetails.VehicleModel = vehicleById.ModelYear;
}
}
ServiceClass.InsuranceDetails InsuranceDetails = new ServiceClass.InsuranceDetails();
if (!string.IsNullOrEmpty(row1["Vehicle_Id"].ToString()))
{
int int32_2 = Convert.ToInt32(row1["Vehicle_Id"]);
if (int32_2 > 0)
{
ServiceClass.Customer customerByVehicleId = ServiceMethod.GetCustomerByVehicleId(int32_2.ToString());
customerJobCardDetails.CustomerName = customerByVehicleId.Name;
customerJobCardDetails.CustomerMobile = customerByVehicleId.Mobile;
bool flag = ServiceMethod.VehicleHavingInsurance1(int32_1.ToString());
HavingInsurance = flag;
customerJobCardDetails.HavingInsurance = Convert.ToInt32(flag).ToString();
if (flag)
{
ServiceClass.VehicleInsurance insuranceByVehicleId = ServiceMethod.GetVehicleInsuranceByVehicleId(int32_2.ToString());
customerJobCardDetails.VehicleInsuranceNumber = insuranceByVehicleId.VehicleInsuranceNumber;
customerJobCardDetails.Insurance_ExpireDate = insuranceByVehicleId.Insurance_ExpireDate;
customerJobCardDetails.Insurance_Provider = insuranceByVehicleId.Insurance_Provider;
customerJobCardDetails.Insurance_Provider_Id = insuranceByVehicleId.Insurance_Provider_Id;
InsuranceDetails = ServiceMethod.GetVehicleInsuranceById(insuranceByVehicleId.Insurance_Provider_Id);
customerJobCardDetails.Insurance_Status = insuranceByVehicleId.Insurance_Status;
customerJobCardDetails.Insurance_Status_Id = insuranceByVehicleId.Insurance_Status_Id;
}
}
}
DataTable dataTableWithParams2 = dbCon.GetDataTableWithParams("Select Id,Isnull(Link,'') as Link from JobCard_Vehicle_Images where JobCardId=@1 and IsDeleted=0", new string[1]
{
int32_1.ToString()
});
if (dataTableWithParams2 != null && dataTableWithParams2.Rows.Count > 0)
{
foreach (DataRow row2 in (InternalDataCollectionBase)dataTableWithParams2.Rows)
{
ServiceClass.VehicleImages vehicleImages = new ServiceClass.VehicleImages();
string str1 = "";
string str2 = "";
if (!string.IsNullOrEmpty(row2["Link"].ToString()))
{
str1 = row2["Link"].ToString();
}
if (!string.IsNullOrEmpty(str1))
{
// str2 = Constant.Message.FinalPathForApplication + "/" + str1;
if (!string.IsNullOrEmpty(str2))
{
vehicleImages.Id = row2["Id"].ToString();
vehicleImages.Name = str2;
customerJobCardDetails.VehicleImages.Add(vehicleImages);
}
}
}
}
customerJobCardDetails.CustomerNotes = ServiceMethod.GetProblemsinJobCardList(JobCardId.ToString(), "1");
customerJobCardDetails.AdvisiorNotes = ServiceMethod.GetProblemsinJobCardList(JobCardId.ToString(), "2");
customerJobCardDetails.Problems = ServiceMethod.GetProblemsinJobCardList(JobCardId.ToString(), "3");
customerJobCardDetails.VideoUrl = ServiceMethod.CameraLinkbyJobCardId(JobCardId.ToString());
customerJobCardDetails.Spares = ServiceMethod.GetJobCardSpareInJobCardForInvoice(JobCardId.ToString());
customerJobCardDetails.Services = ServiceMethod.GetJobCardServiceInJobCard(JobCardId.ToString());
var Spares = ServiceMethod.GetJobCardSpareInJobCardForInvoice(JobCardId.ToString());
var getRCDetail = ServiceMethod.GetRCDetail(int.Parse(JobCardId));
// FromInvoice = true;
string InvoiceId = GetInvoiceIdFromJobCard(int.Parse(JobCardId), FromInvoice, Type);
string InvoiceDate = GetInvoiceDateFromJobCard(int.Parse(JobCardId), FromInvoice, Type);
#endregion
if (HavingInsurance && Type == 2)//Come
{
string InnerHtml = "<tr style='text-transform: uppercase; '> <td colspan='1' style='text-align:center;font-weight:bold;border-right: 1px solid #ccc;border-bottom: 1px solid #ccc;'> Insurance Details </td><td colspan='2' style='text-align:center;font-weight:bold;border-bottom: 1px solid #ccc;'> Vehicle Details </td></tr><tr> <td width='50%' style='border-right: 1px solid #ccc;border-bottom: 1px solid #ccc;padding: 5px;vertical-align: top;'> <table style='width:100%;font-size:8pt !important; padding: 5px;'> <tbody><tr style='#SHOWVISIBILITYTR1#'> <td width='20%' style='padding-top: 1px;'> <span style='word-break: break-word;line-height: 1;'>Name:</span></td><td style='padding-top: 1px;' colspan='3'> <span style='word-break: break-word;line-height: 1;'>" + customerJobCardDetails.Insurance_Provider + "</span></td></tr><tr style='#SHOWVISIBILITYTR3#'> <td style='vertical-align: top;'> <span style='word-break: break-word;line-height: 1;'>GSTIN:</span></td><td style='vertical-align: top;padding-right: 2px;' colspan='3'> <span style='word-break: break-word;line-height: 1; '>" + InsuranceDetails.GSTIN + "</span></td></tr><tr> <td width='25%' style='vertical-align: top;'> <span style='word-break: break-word;line-height: 1;'>Policy Number:</span></td><td width='25%' style='vertical-align: top;padding-right: 2px;'> <span style='word-break: break-word; line-height: 1;'>" + customerJobCardDetails.VehicleInsuranceNumber + "</span></td></tr><tr style='#SHOWVISIBILITYTR4#'> <td> <span style='word-break: break-word;line-height: 1;'>Phone:</span></td><td> <span style='word-break: break-word;line-height: 1;'>" + InsuranceDetails.ContactNumber + "</span></td></tr><tr style='#SHOWVISIBILITYTR2#'> <td style='vertical-align: top;'> <span style='word-break: break-word;line-height: 1;'>Address:</span></td><td colspan='3' style='vertical-align: top;padding-right: 2px;'> <span style='word-break: break-word;line-height: 1; '>" + InsuranceDetails.Address + "</span></td></tr><tr style='border-top: 1px solid #ccc;'><td colspan='4'> </td></tr><tr> <td width='25%' style='vertical-align: top;'> <span style='word-break: break-word;line-height: 1;'>Exp Dt:</span></td><td width='25%' style='vertical-align: top;padding-right: 2px;'> <span style='word-break: break-word;line-height: 1; '>" + customerJobCardDetails.Insurance_ExpireDate + "</span></td><td width='19%' style='vertical-align: top;'> <span style='word-break: break-word;line-height: 1;'>Claim Dt:</span></td><td width='31%' style='vertical-align: top;padding-right: 2px;'> <span style='word-break: break-word;line-height: 1; '></span></td></tr><tr> <td style='vertical-align: top;'> <span style='word-break: break-word;line-height: 1;'>Claim No:</span></td><td style='vertical-align: top;padding-right: 2px;'> <span style='word-break: break-word; line-height: 1;'></span></td><td style='vertical-align: top;'> <span style='word-break: break-word;line-height: 1;'>IDV(Rs.):</span></td><td style='vertical-align: top;padding-right: 2px;'> <span style='word-break: break-word;line-height: 1; '></span></td></tr></tbody></table> </td><td width='50' style='border-bottom: 1px solid #ccc;padding: 5px;vertical-align: top;'><table style='width:100%;font-size:8pt !important; padding: 5px;'> <tbody><tr> <td width='20%'> <span style='word-break: break-word;line-height: 1;padding-top: 1px;'> Invoice No: </span> </td><td width='30%'> <span style='word-break: break-word;line-height: 1;padding-top: 1px;'>" + InvoiceId + " </span> </td><td width='20%'> <span style='word-break: break-word;line-height: 1;padding-top: 1px;'> Jobcard No: </span> </td><td width='30%'> <span style='word-break: break-word;line-height: 1;padding-top: 1px;'> <asp:Label ID='JobCardNo' runat='server' Text='" + JobCardId.ToString() + "'>" + JobCardId.ToString() + "</asp:Label> </span> </td></tr><tr> <td> <span style='word-break: break-word;line-height: 1;'> Invoice Date: </span> </td><td> <span style='word-break: break-word;line-height: 1;'> <asp:Label ID='Invoice_Date' runat='server' Text='" + InvoiceDate + "'>" + InvoiceDate + "</asp:Label> </span> </td><td> <span style='word-break: break-word;line-height: 1;'> Jobcard Date: </span> </td><td> <span style='word-break: break-word;line-height: 1;'> <asp:Label ID='JobCard_Date' runat='server' Text='" + customerJobCardDetails.DateOfCreate + "'>" + customerJobCardDetails.DateOfCreate + "</asp:Label></span> </td></tr><tr> <td> <span style='word-break: break-word;line-height: 1;'> Reg. Number: </span> </td><td> <span style='word-break: break-word;line-height: 1;'> <asp:Label ID='Vehicle_Reg_No' runat='server' Text='" + Vehicle.Number + "'>" + Vehicle.Number + "</asp:Label></span> </td><td> <span style='word-break: break-word;line-height: 1;'> KMS. Driven</span> </td><td> <span style='word-break: break-word;line-height: 1;'> <asp:Label ID='Kms' runat='server' Text='" + Vehicle.KiloMeters + "'>" + Vehicle.KiloMeters + "</asp:Label></span> </td></tr><tr> <td> <span style='word-break: break-word; line-height: 1;'>VIN:</span> </td><td> <span style='word-break: break-word; line-height: 1;'> <asp:Label ID='Chasis_No' runat='server' Text='" + Vehicle.ChasisNumber + "'>" + Vehicle.ChasisNumber + "</asp:Label></span> </td><td> <span style='word-break: break-word;'> Eng No: </span> </td><td> <span style='word-break: break-word;'> <asp:Label ID='EngineNo' runat='server' Text='" + Vehicle.EngineNumber + "'>" + Vehicle.EngineNumber + "</asp:Label> </span> </td></tr><tr> <td> <span style='word-break: break-word;'> Model: </span> </td><td colspan='3'> <span style='word-break: break-word;line-height: 1;'><asp:Label ID='ModelName' runat='server' Text='" + Vehicle.VehicleBrand + " " + Vehicle.VehicleModel + "'>" + Vehicle.VehicleBrand + " " + Vehicle.VehicleModel + "</asp:Label> </span> </td></tr></tbody></table>";
//+" <tr> <td colspan='4' style='text-align: center;font-weight:bold;border-top: solid thin #ccc;font-weight:bold;border-bottom: solid thin #ccc;#SHOWVISIBILITYTR1#;'> <strong>RC Details</strong> </td></tr><tr style='text-transform: uppercase;'> <td width='20%'> <span style='word-break: break-word;line-height: 1;'> Registration Owner : </span></td><td width='30%'> <span style='word-break: break-word;line-height: 1;'> </span></td><td width='20%'> <span style='word-break: break-word;line-height: 1;'> Registration Dt :</span></td><td width='30%'> <span>0000-00-00</span></td><!-- <td width='10%'> <span style='word-break: break-word;line-height: 1;'> Registration Dt :</span></td><td width='20%'> <span>0000-00-00</span></td>--> </tr><tr style='text-transform: uppercase;#SHOWVISIBILITYTR8#;'> <td width='20%'> <span style='word-break: break-word;line-height: 1;'> RTO Name : </span></td><td width='30%'> <span style='word-break: break-word;line-height: 1;'> </span></td><td width='20%'> <span style='word-break: break-word;line-height: 1;'>Color :</span></td><td width='30%'> <span></span></td></tr><tr style='text-transform: uppercase;#SHOWVISIBILITYTR9#;'> <td width='20%'> <span style='word-break: break-word;line-height: 1;'> Cubic Capacity : </span></td><td width='30%'> <span style='word-break: break-word;line-height: 1;'> 0</span></td><td width='20%'> <span style='word-break: break-word;line-height: 1;'>Registration valid upto :</span></td><td width='30%'> <span>0000-00-00</span></td></tr><tr style='text-transform: uppercase;#SHOWVISIBILITYTR10#;'> <td width='20%'> <span style='word-break: break-word;line-height: 1;'> Hypothecated To : </span></td><td width='30%'> <span style='word-break: break-word;line-height: 1;'> </span></td><td width='20%'> <span style='word-break: break-word;line-height: 1;'>Manufactured Yr :</span></td><td width='30%'></td></tr>";
string width = "20%";
//string InnerHtmlRc = "<table style='width:100%;font-size:8pt !important; padding: 5px;'><tbody><tr> <td colspan='4' style='text-align: center;font-weight:bold;border-top: solid thin #ccc;font-weight:bold;border-bottom: solid thin #ccc;#SHOWVISIBILITYTR1#;'> <strong>RC Details</strong> </td></tr><tr style='text-transform: uppercase;'> <td width='20%'> <span style='word-break: break-word;line-height: 1;'> Registration Owner : </span></td><td width='30%'> <span style='word-break: break-word;line-height: 1;'>" + getRCDetail.RegistrationOwner + " </span></td><td width='20%'> <span style='word-break: break-word;line-height: 1;'> Registration Dt :</span></td><td width='10%'> <span>" + getRCDetail.DateOfRegistration + " </span></td><!-- <td width='10%'> <span style='word-break: break-word;line-height: 1;'> Registration Dt :</span></td><td width='" + width + "'> <span>" + getRCDetail.DateOfRegistration + "</span></td>--> </tr><tr style='text-transform: uppercase;#SHOWVISIBILITYTR8#;'> <td width='" + width + "'> <span style='word-break: break-word;line-height: 1;'> RTO Name : </span></td><td width='30%'> <span style='word-break: break-word;line-height: 1;'>" + getRCDetail.RTOName + " </span></td><td width='" + width + "'> <span style='word-break: break-word;line-height: 1;'>Color :</span></td><td width='30%'> <span>" + getRCDetail.Color + " </span></td></tr><tr style='text-transform: uppercase;#SHOWVISIBILITYTR9#;'> <td width='" + width + "'> <span style='word-break: break-word;line-height: 1;'> Cubic Capacity : </span></td><td width='30%'> <span style='word-break: break-word;line-height: 1;'> " + getRCDetail.CubicCapacity + "</span></td><td width='" + width + "'> <span style='word-break: break-word;line-height: 1;'>Registration valid upto :</span></td><td width='30%'> <span>" + getRCDetail.RegValidDt + "</span></td></tr><tr style='text-transform: uppercase;#SHOWVISIBILITYTR10#;'> <td width='" + width + "'> <span style='word-break: break-word;line-height: 1;'> Hypothecated To : </span></td><td width='30%'> <span style='word-break: break-word;line-height: 1;'> </span></td><td width='" + width + "'> <span style='word-break: break-word;line-height: 1;'>Manufactured Yr :</span></td><td width='30%'><span>" + getRCDetail.ModelYear + "</span></td></tr>";
strLst.Add(InnerHtml);
// strLst.Add(InnerHtmlRc);
}
else
{
string InnerHtml = "<tr style='text-transform: uppercase; '> <td colspan='1' style='text-align:center;font-weight:bold;border-right: 1px solid #ccc;border-bottom: 1px solid #ccc;'> Customer Details </td><td colspan='2' style='text-align:center;font-weight:bold;border-bottom: 1px solid #ccc;'> Vehicle Details </td></tr><tr> <td width='45%' style='border-right: 1px solid #ccc;border-bottom: 1px solid #ccc;padding: 0px 1px 0px 1px;vertical-align: top;'> <table style='width:100%;font-size:8pt !important;padding: 5px;'> <tbody><tr> <td width='17%' style='padding-top: 1px;'> <span style='word-break: break-word;line-height: 1;'>Name:</span> </td><td width='83%' style='padding-top: 1px;'> <span style='word-break: break-word; line-height: 1;'><asp:Label ID='Cus_Name' runat='server' Text='" + Customer.Name + "'>" + Customer.Name + "</asp:Label></span> </td></tr><tr> <td style='vertical-align: top;'> <span style='word-break: break-all;'>Address:</span> </td><td style='vertical-align: top;padding-right: 2px;'> <span style='word-break: break-all; '><asp:Label ID='Cus_Address' runat='server' Text='" + Customer.Address + "'>" + Customer.Address + "</asp:Label></span> </td></tr><tr> <td> <span style='word-break: break-word;line-height: 1;'>Phone:</span> </td><td> <span style='word-break: break-word;line-height: 1;'><asp:Label ID='Cus_Phone' runat='server' Text='" + Customer.Mobile + "'>" + Customer.Mobile + "</asp:Label></span> </td></tr><tr> <td> <span style='word-break: break-word;line-height: 1;'> Email: </span> </td><td> <span style='word-break: break-word;line-height: 1;'>" + Customer.Email + " </span> </td></tr><tr> <td> <span style='word-break: break-word;line-height: 1;'> GST: </span> </td><td> <span style='word-break: break-word;line-height: 1;'>" + Customer.GstNo + " </span> </td></tr></tbody></table> </td><td width='55%' style='border-bottom: 1px solid #ccc;padding: 0px 1px 0px 1px;'> <table style='width:100%;font-size:8pt !important;padding: 5px;'> <tbody><tr> <td width='20%'> <span style='word-break: break-word;line-height: 1;padding-top: 1px;'> Invoice No: </span> </td><td width='30%'> <span style='word-break: break-word;line-height: 1;padding-top: 1px;'>" + InvoiceId + " </span> </td><td width='20%'> <span style='word-break: break-word;line-height: 1;padding-top: 1px;'> Jobcard No: </span> </td><td width='30%'> <span style='word-break: break-word;line-height: 1;padding-top: 1px;'> <asp:Label ID='JobCardNo' runat='server' Text='" + JobCardId.ToString() + "'>" + JobCardId.ToString() + "</asp:Label> </span> </td></tr><tr> <td> <span style='word-break: break-word;line-height: 1;'> Invoice Date: </span> </td><td> <span style='word-break: break-word;line-height: 1;'> <asp:Label ID='Invoice_Date' runat='server' Text='" + InvoiceDate + "'>" + InvoiceDate + "</asp:Label> </span> </td><td> <span style='word-break: break-word;line-height: 1;'> Jobcard Date: </span> </td><td> <span style='word-break: break-word;line-height: 1;'> <asp:Label ID='JobCard_Date' runat='server' Text='" + customerJobCardDetails.DateOfCreate + "'>" + customerJobCardDetails.DateOfCreate + "</asp:Label></span> </td></tr><tr> <td> <span style='word-break: break-word;line-height: 1;'> Reg. Number: </span> </td><td> <span style='word-break: break-word;line-height: 1;'> <asp:Label ID='Vehicle_Reg_No' runat='server' Text='" + Vehicle.Number + "'>" + Vehicle.Number + "</asp:Label></span> </td><td> <span style='word-break: break-word;line-height: 1;'> KMS. Driven</span> </td><td> <span style='word-break: break-word;line-height: 1;'> <asp:Label ID='Kms' runat='server' Text='" + Vehicle.KiloMeters + "'>" + Vehicle.KiloMeters + "</asp:Label></span> </td></tr><tr> <td> <span style='word-break: break-word; line-height: 1;'>VIN:</span> </td><td> <span style='word-break: break-word; line-height: 1;'> <asp:Label ID='Chasis_No' runat='server' Text='" + Vehicle.ChasisNumber + "'>" + Vehicle.ChasisNumber + "</asp:Label></span> </td><td> <span style='word-break: break-word;'> Eng No: </span> </td><td> <span style='word-break: break-word;'> <asp:Label ID='EngineNo' runat='server' Text='" + Vehicle.EngineNumber + "'>" + Vehicle.EngineNumber + "</asp:Label> </span> </td></tr><tr> <td> <span style='word-break: break-word;'> Model: </span> </td><td colspan='3'> <span style='word-break: break-word;line-height: 1;'><asp:Label ID='ModelName' runat='server' Text='" + Vehicle.VehicleBrand + " " + Vehicle.VehicleModel + "'>" + Vehicle.VehicleBrand + " " + Vehicle.VehicleModel + "</asp:Label> </span> </td></tr>";
strLst.Add(InnerHtml);
}
}
}
return(strLst);
}
public PlaceOrderModel PlaceOrder(String CustomerId, decimal PaidAmount, string AddressId, string Quantity, string buywith, string discountamount = "", string Redeemeamount = "", string couponCode = "")
{
PlaceOrderModel objplaceorder = new PlaceOrderModel();
try
{
string merchantTxnId = dbCon.getindiantime().ToString("yyyyMMddHHmmssffff") + CustomerId;
if(PaidAmount==0)
{
int result = dbCon.CreateTransaction(merchantTxnId, CustomerId, PaidAmount);
if (result == 1)
{
string chektrans = "select id from AlterNetOrder where trnid=@1";
string[] param = { merchantTxnId };
DataTable dtcheckTrans = dbCon.GetDataTableWithParams(chektrans, param);
if (dtcheckTrans != null && dtcheckTrans.Rows.Count > 0)
{
dbCon.deleteAlternateOrder(merchantTxnId);
}
else
{
int chkalternat = CreateAlternateOrder(CustomerId, merchantTxnId, AddressId, PaidAmount.ToString(), Quantity, buywith, discountamount, Redeemeamount, couponCode);
if (chkalternat > 0 && PaidAmount == 0)
{
int OrderId = WalletPlaceOrder(merchantTxnId);
if (OrderId > 0)
{
// if success, Update the transaction
#region Update Transaction
try
{
String querynew = "UPDATE [dbo].[CitrusPayment] SET [OrderId] = @1 ,[Order_TimeOfTransaction]= @2,[Statuse] = @3 ,[IsPaymentSuccess]=@4 WHERE [TxnId] = '" + merchantTxnId + "'";
string[] parms_new = { OrderId.ToString(), dbCon.getindiantime().ToString("dd/MMM/yyyy HH:mm:ss"), "3", "1" };
int resvaltrn = dbCon.ExecuteQueryWithParams(querynew, parms_new);
if (resvaltrn > 0)
{
String querynew1 = "UPDATE [dbo].[AlternetOrder] SET [UpdatedOnUtc]=@1,[IsPaymentDone]=@2 WHERE [TrnId] = '" + merchantTxnId + "'";
string[] parms_new1 = { dbCon.getindiantime().ToString("dd/MMM/yyyy HH:mm:ss"), "1" };
int resvaltrn1 = dbCon.ExecuteQueryWithParams(querynew1, parms_new1);
if (resvaltrn1 > 0)
{
String querynew2 = "UPDATE [dbo].[Order] SET [UpdatedOnUtc] =@1,[IsPaymentDone]=@2 WHERE [TRNID] ='" + merchantTxnId + "'";
string[] parms_new2 = { dbCon.getindiantime().ToString("dd/MMM/yyyy HH:mm:ss"), "1" };
int resvaltrn2 = dbCon.ExecuteQueryWithParams(querynew2, parms_new2);
if (resvaltrn2 > 0)
{
objplaceorder.resultflag = "1";
objplaceorder.OrderId = OrderId.ToString();
objplaceorder.Message = "Your OrderNo:" + OrderId + " has been succesfully generated";
}
}
}
else
{
objplaceorder.resultflag = "1";
objplaceorder.OrderId = OrderId.ToString();
objplaceorder.Message = "Your Order was Not Generated";
}
}
catch (Exception err)
{
objplaceorder.resultflag = "1";
objplaceorder.OrderId = OrderId.ToString();
objplaceorder.Message = "Your Order was Not Generated";
}
#endregion
}
else
{
objplaceorder.resultflag = "1";
objplaceorder.OrderId = OrderId.ToString();
objplaceorder.Message = "Your Order was Not Generated";
}
}
else
{
objplaceorder.resultflag = "0";
objplaceorder.Message = "Your Order was Not Generated";
}
}
}
}
}
catch(Exception ex)
{
}
return objplaceorder;
}