public Object GetOrderId1([FromBody] RazorPaymentcs Order)
{
string sJSONResponse = "";
DataTable dt_AppType = new DataTable();
string ServerDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);
int a = 0;
string AppType_Query = "";
PaymentDetailsGet Pdetails = new PaymentDetailsGet();
string ReceiptNos = ReceiptNo();
try
{
Dictionary <string, object> input = new Dictionary <string, object>();
input.Add("amount", Order.Amount); // this amount should be same as transaction amount
input.Add("currency", Order.Currency);
input.Add("receipt", ReceiptNos);
input.Add("payment_capture", 1);
// string key = "rzp_live_1FlbqBOlw7TqHA";
//string secret = "6UJyvn78r9xNlbckRZZDvqEZ";
string key = "rzp_test_51inWTBswRzU37";
string secret = "u8dI6qRiT8bpvNIdTqvju7bQ";
RazorpayClient client = new RazorpayClient(key, secret);
Razorpay.Api.Order order = client.Order.Create(input);
orderId = order["id"].ToString();
cnn.Open();
AppType_Query = "insert into PaymentGateway(GatewayProviderName,OrderId,BranchCode,MobileNo,ModeOfPayment,Amount,Currency,receipt,TransactionDate,CreatedOn,CreatedBy,IsDeleted,IsActive) values('GPN001','" + orderId + "','Brc1101','" + Order.MobileNo + "','OnLine','" + Order.Amount + "','INR','" + ReceiptNos + "','" + Order.TransactionDate + "','" + ServerDateTime + "','" + Order.MobileNo + "',0,1) SELECT @@IDENTITY;";
SqlCommand tm_cmd = new SqlCommand(AppType_Query, cnn);
a = Convert.ToInt32(tm_cmd.ExecuteScalar());
Pdetails.status = "success";
Pdetails.orderId = orderId;
}
catch (Exception ex)
{
Pdetails.status = "Fail";
}
finally
{
cnn.Close();
}
sJSONResponse = JsonConvert.SerializeObject(Pdetails);
return(sJSONResponse);
}
public Object OffLinePostPaymentDetails([FromBody] OffLineCapturePaymentDetails Order)
{
OffLineRazorPaymentFinalOutput RPFO = new OffLineRazorPaymentFinalOutput();
OffLineRazorPaymentFinalOutputMessage RPFOM = new OffLineRazorPaymentFinalOutputMessage();
string r = "";
DataSet ds_PaymentDetailsPost = new DataSet();
string sJSONResponse = "";
DataTable dt_AppType = new DataTable();
string ServerDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);
ArrayList arl_pdetails = GetPersonDetailsByMobileNo(Order.MobileNo);
PaymentDetailsGet Pdetails = new PaymentDetailsGet();
int Year = DateTime.Now.Year - 2000;
int Month = DateTime.Now.Month;
//-- GYMFEES','Trainer Fees','IGSTableAmount','IGST','CGST','SGST
//IGSTtableamount - IGST
//payableamount* Personaltrainer%
//payableamount * Gymfee %
//IGSTtableamount * IGST
//IGSTtableamount* CGST
//IGSTtableamount * SGST
ArrayList ary_GST = new ArrayList();
ary_GST = GetGSTCode();
// Clients Unique COde
ArrayList al = new ArrayList();
string GSTCode = "";
try
{
GSTCode = ary_GST[0].ToString();
}
catch (Exception ec)
{
}
float IGSTPercentage = float.Parse(ary_GST[1].ToString());
float CGSTPercentage = float.Parse(ary_GST[2].ToString());
float SGSTPercentage = float.Parse(ary_GST[3].ToString());
float GYMFeePercentage = float.Parse(ary_GST[4].ToString());
float PersonalTrainerPercentage = float.Parse(ary_GST[5].ToString());
float PayableAmount = Convert.ToInt32(Order.PayableAmount);
float PersonalTrainer = PayableAmount * (PersonalTrainerPercentage / 100);
float IGSTableAmount = PayableAmount * (GYMFeePercentage / 100);
float IGST = PayableAmount * (IGSTPercentage / 100);
float CGST = PayableAmount * (CGSTPercentage / 100);
float SGST = PayableAmount * (SGSTPercentage / 100);
float GYMFEE = IGSTableAmount - IGST;
int SerialNo = 0;
string MembershipCode = GetMembersExistance(Order.MobileNo);
if (MembershipCode == null || MembershipCode == "" || MembershipCode == string.Empty)
{
al = MCode(Order.BranchCode);
r = (String)al[1].ToString();
SerialNo = Convert.ToInt32(al[0].ToString());
}
else
{
r = MembershipCode;
}
// Invoice Generation
string Invoice = "N" + UniqueGeneration2();
int UID = UIDNew(Order.BranchCode);
if (InvoiceCheck(Invoice) != 0)
{
Invoice = "N" + UniqueGeneration2();
}
string ReceiptNos = ReceiptNo();
if (CheckExistency(MembershipCode, Order.PlanCode, Order.SlotCode, Order.PackageCode, Convert.ToDateTime(Order.MembershipStartDate), Convert.ToDateTime(Order.MembershipExpireDate)) == 0)
{
cnn.Open();
SqlCommand command = cnn.CreateCommand();
SqlTransaction transaction;
// Start a local transaction.
transaction = cnn.BeginTransaction("SampleTransaction");
// Must assign both transaction object and connection
// to Command object for a pending local transaction
command.Connection = cnn;
command.Transaction = transaction;
try
{
{
if (MembershipCode == null || MembershipCode == "" || MembershipCode == string.Empty)
{
command.CommandText = "insert into Users(UCode,BranchCode,UserName,Firstname,Lastname,DateOfBirth,Gender,MaritialStatus,Address,Area,City,State,Country,PinCode,MobileNo,CreatedBy,CreatedOn,IsDeleted,IsActive,Email,Photo,Address2,PhotoUrl) values('" + r + "','" + Order.BranchCode + "','" + arl_pdetails[0].ToString() + "','" + arl_pdetails[0].ToString() + "','','" + arl_pdetails[1].ToString() + "','" + arl_pdetails[2].ToString() + "','','','','1','1','1','','" + Order.MobileNo + "','" + Order.MobileNo + "','" + ServerDateTime + "',0,1,'','','','')";
command.ExecuteNonQuery();
command.CommandText = "insert into CCRMMembershipCodification(SerialNo,MembershipCode,BranchCode,Year,Month) values(" + al[0].ToString() + ",'" + r + "','" + Order.BranchCode + "','" + Convert.ToString(Year) + "','" + Convert.ToString(Month) + "')";
command.ExecuteNonQuery();
}
command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',1,'FREEZING','" + Order.Freezing + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
command.ExecuteNonQuery();
command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',3,'UPGRADATION','" + Order.Upgrade + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
command.ExecuteNonQuery();
command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',4,'CHANGE','" + Order.Change + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
command.ExecuteNonQuery();
command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',5,'TRANSFER TRANSFER','" + Order.Transfer + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
command.ExecuteNonQuery();
command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',6,'PERSON TRANSFER','" + Order.Transfer + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
command.ExecuteNonQuery();
command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',8,'HOLD','" + Order.Transfer + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
command.ExecuteNonQuery();
command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',9,'Paused','" + Order.Paused + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
command.ExecuteNonQuery();
command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',10,'Convert','" + Order.Convert + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
command.ExecuteNonQuery();
command.CommandText = "insert into CCRMMEnquireStatus(MobileNo,EnquireTypeNo,MobileDeviceID,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + Order.MobileNo + "','" + Order.EnquireTypeNo + "','" + Order.MobileDeviceID + "','" + Order.MobileNo + "','" + ServerDateTime + "',0,1)";
command.ExecuteNonQuery();
command.CommandText = "insert into CCRMMembership(MembershipCode,BranchCode,PlanCode,MembershipExpireDate,CreatedBy,CreatedOn,IsDeleted,IsActive,SlotCode,PackageCode,StartDate,TrainerCode,InvoiceID,Receipt,SerialNo,Year,Month,PlanCostCode,DurationId,EnquireTypeNo,EnquireTypeIncentives) values('" + r + "','" + Order.BranchCode + "','" + Order.PlanCode + "','" + Order.MembershipExpireDate + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1,'" + Order.SlotCode + "','" + Order.PackageCode + "','" + Order.MembershipStartDate + "','" + Order.TrainerCode + "','" + Invoice + "','" + ReceiptNo() + "'," + SerialNo + ",'" + Year + "','" + Month + "','" + Order.PlanCostCode + "','" + Order.DurationId + "','" + Order.EnquireTypeNo + "','" + Order.EnquireTypeNo + "')";
command.ExecuteNonQuery();
command.CommandText = "insert into FAInvoice(InvoiceID,GSTCode,FAPaymentModes,MembershipCode,PayableAmount,AmountDue,GymFees,TrainerFees,IGSTableAmount,IGST,CGST,SGST,DueDate,CreatedBy,CreatedOn,IsDeleted,IsActive,FinalAmount,FAPaymentModes2,PayableAmount2,PromoCode,ReferenceID,DiscountAmount,TrainerCode,Receipt,EnquireTypeNo,SlotPrice,PlanCost,PaymentDate,RemainingAmount,Wallet,OrderId,Currency) values('" + Invoice + "','" + GSTCode + "','PY6','" + r + "','" + Order.PayableAmount + "','" + Order.AmountDue + "','" + GYMFEE + "','" + PersonalTrainer + "','" + IGSTableAmount + "','" + IGST + "','" + CGST + "','" + SGST + "','" + Order.DueDate + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1,'" + Order.FinalAmount + "','0','" + Order.PayableAmount2 + "','" + Order.PromoCode + "','','" + Order.DiscountAmount + "','" + Order.TrainerCode + "','" + ReceiptNo() + "','" + Order.EnquireTypeNo + "','" + Order.SlotPrice + "','" + Order.PlanCost + "','" + Order.TransactionDate + "','0.0','" + Order.Wallet + "','" + Order.OrderId + "','" + Order.Currency + "')";
command.ExecuteNonQuery();
transaction.Commit();
cnn.Close();
List <OffLineRazorPaymentPost> dbPaymentPost = new List <OffLineRazorPaymentPost>();
OffLineRazorPaymentPost dashboardlistpackage = new OffLineRazorPaymentPost {
invoice = Convert.ToString(Invoice), memberShipCode = Convert.ToString(r), orderId = Convert.ToString(Order.OrderId)
};
dbPaymentPost.Add(dashboardlistpackage);
// int val = SendMessage(Order.MobileNo, arl_pdetails[0].ToString());
RPFO.status = "success";
RPFO.value = dbPaymentPost;
sJSONResponse = JsonConvert.SerializeObject(RPFO);
}
}
catch (Exception ex)
{
try
{
transaction.Rollback();
RPFO.status = "Fail";
}
catch (Exception ex2)
{
RPFO.status = "Fail";
}
}
sJSONResponse = JsonConvert.SerializeObject(RPFO);
}
else
{
List <ErrorMessage> ErrorMessage = new List <ErrorMessage>();
ErrorMessage erm_ErrorMessage = new ErrorMessage {
errorMessage = "Plan Already Exist"
};
ErrorMessage.Add(erm_ErrorMessage);
RPFOM.status = "Fail";
RPFOM.value = ErrorMessage;
sJSONResponse = JsonConvert.SerializeObject(RPFOM);
}
return(sJSONResponse);
}
public Object PostPaymentDetails([FromBody] CapturePaymentDetails Order)
{
string sJSONResponse = "";
try
{
RazorPaymentFinalOutput RPFO = new RazorPaymentFinalOutput();
string r = "";
DataSet ds_PaymentDetailsPost = new DataSet();
DataTable dt_AppType = new DataTable();
string ServerDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);
ArrayList arl_pdetails = GetPersonDetailsByMobileNo(Order.MobileNo);
PaymentDetailsGet Pdetails = new PaymentDetailsGet();
int Year = DateTime.Now.Year - 2000;
int Month = DateTime.Now.Month;
// Clients Unique COde
ArrayList al = new ArrayList();
string MembershipCode = GetMembersExistance(Order.MobileNo);
if (Order.EnquireTypeNo == 2)
{
r = "";
}
else
{
if (MembershipCode == null || MembershipCode == "" || MembershipCode == string.Empty)
{
al = MCode("1104");
r = (String)al[1].ToString();
}
else
{
r = MembershipCode;
}
}
// Invoice Generation
string Invoice = "N" + UniqueGeneration2();
int UID = UIDNew("1104");
if (InvoiceCheck(Invoice) != 0)
{
Invoice = "N" + UniqueGeneration2();
}
string ReceiptNos = ReceiptNo();
cnn.Open();
SqlCommand command = cnn.CreateCommand();
SqlTransaction transaction;
// Start a local transaction.
transaction = cnn.BeginTransaction("SampleTransaction");
// Must assign both transaction object and connection
// to Command object for a pending local transaction
command.Connection = cnn;
command.Transaction = transaction;
try
{
{
if (Order.EnquireTypeNo != 2)
{
if (MembershipCode == null || MembershipCode == "" || MembershipCode == string.Empty)
{
command.CommandText = "insert into Users(UCode,BranchCode,UserName,Firstname,Lastname,DateOfBirth,Gender,MaritialStatus,Address,Area,City,State,Country,PinCode,MobileNo,CreatedBy,CreatedOn,IsDeleted,IsActive,Email,Photo,Address2,PhotoUrl) values('" + r + "','1104','" + arl_pdetails[0].ToString() + "','" + arl_pdetails[0].ToString() + "','','" + arl_pdetails[1].ToString() + "','" + arl_pdetails[2].ToString() + "','','','','','','','','" + Order.MobileNo + "','" + Order.MobileNo + "','" + ServerDateTime + "',0,1,'','','','')";
command.ExecuteNonQuery();
command.CommandText = "insert into CCRMMembershipCodification(SerialNo,MembershipCode,BranchCode,Year,Month) values(" + al[0].ToString() + ",'" + r + "','1104','" + Convert.ToString(Year) + "','" + Convert.ToString(Month) + "')";
command.ExecuteNonQuery();
}
//command.CommandText = "insert into CCRMMEnquireStatus(MobileNo,EnquireTypeNo,MobileDeviceID,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + Order.MobileNo + "','" + Order.EnquireTypeNo + "','" + Order.MobileDeviceID + "','" + Order.MobileNo + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
command.CommandText = "insert into PaymentGateway(GatewayProviderName,OrderId,BranchCode,MemberShipCode,Invoice,MobileNo,ModeOfPayment,payment_capture,Amount,Currency,Discount,receipt,TransactionDate,CreatedOn,CreatedBy,IsDeleted,IsActive) values('GPN001','" + Order.OrderId + "','1104','" + r + "','" + Invoice + "','" + Order.MobileNo + "','" + Order.ModeOfPayment + "','" + Order.PaymentId + "','" + Order.Amount + "','INR','" + Order.DiscountAmount + "','" + ReceiptNos + "','" + Order.TransactionDate + "','" + ServerDateTime + "','" + Order.CreatedBy + "',0,1)";
command.ExecuteNonQuery();
command.CommandText = "insert into OnlinePackagePurchase(BranchCode,MembershipCode,MobileNo,EnquireTypeNo,PackageID,StartDate,EndDate,ActualPrice,NumberOfSession,NumberOfDaysValidity,MobileDeviceID,Invoice,Discount,Comment,CreatedBy,CreatedOn,IsDeleted,IsActive) values('1104','" + r + "','" + Order.MobileNo + "','" + Order.EnquireTypeNo + "','" + Order.PackageID + "','" + Order.StartDate + "','" + Order.EndDate + "','" + Order.ActualPrice + "','" + Order.NumberOfSession + "','" + Order.NumberOfDaysValidity + "','" + Order.MobileDeviceID + "','" + Invoice + "','" + Order.DiscountAmount + "','','" + Order.MobileNo + "','" + ServerDateTime + "',0,1)";
command.ExecuteNonQuery();
//command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',1,'FREEZING','" + Order.Freezing + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
//command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',3,'UPGRADATION','" + Order.Upgrade + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
//command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',4,'CHANGE','" + Order.Change + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
//command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',5,'TRANSFER TRANSFER','" + Order.Transfer + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
//command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',6,'PERSON TRANSFER','" + Order.Transfer + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
//command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',8,'HOLD','" + Order.Transfer + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
//command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',9,'Paused','" + Order.Paused + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
//command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',10,'Convert','" + Order.Convert + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
}
else
{
//command.CommandText = "insert into CCRMMEnquireStatus(MobileNo,EnquireTypeNo,MobileDeviceID,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + Order.MobileNo + "','" + Order.EnquireTypeNo + "','" + Order.MobileDeviceID + "','" + Order.MobileNo + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
command.CommandText = "insert into PaymentGateway(GatewayProviderName,OrderId,BranchCode,MemberShipCode,Invoice,MobileNo,ModeOfPayment,payment_capture,Amount,Currency,Discount,receipt,TransactionDate,CreatedOn,CreatedBy,IsDeleted,IsActive) values('GPN001','" + Order.OrderId + "','1104','" + r + "','" + Invoice + "','" + Order.MobileNo + "','" + Order.ModeOfPayment + "','" + Order.PaymentId + "','" + Order.Amount + "','INR','" + Order.DiscountAmount + "','" + ReceiptNos + "','" + Order.TransactionDate + "','" + ServerDateTime + "','" + Order.CreatedBy + "',0,1)";
command.ExecuteNonQuery();
command.CommandText = "insert into OnlinePackagePurchase(BranchCode,MembershipCode,MobileNo,EnquireTypeNo,PackageID,StartDate,EndDate,ActualPrice,NumberOfSession,NumberOfDaysValidity,MobileDeviceID,Invoice,Discount,Comment,CreatedBy,CreatedOn,IsDeleted,IsActive) values('1104','" + r + "','" + Order.MobileNo + "','" + Order.EnquireTypeNo + "','" + Order.PackageID + "','" + Order.StartDate + "','" + Order.EndDate + "','" + Order.ActualPrice + "','" + Order.NumberOfSession + "','" + Order.NumberOfDaysValidity + "','" + Order.MobileDeviceID + "','" + Invoice + "','" + Order.DiscountAmount + "','','" + Order.MobileNo + "','" + ServerDateTime + "',0,1)";
command.ExecuteNonQuery();
//command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',1,'FREEZING','" + Order.Freezing + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
//command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',3,'UPGRADATION','" + Order.Upgrade + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
//command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',4,'CHANGE','" + Order.Change + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
//command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',5,'TRANSFER TRANSFER','" + Order.Transfer + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
//command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',6,'PERSON TRANSFER','" + Order.Transfer + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
//command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',8,'HOLD','" + Order.Transfer + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
//command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',9,'Paused','" + Order.Paused + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
//command.CommandText = "insert into FacilityOpted(MembershipCode,SMFDID,FacilityName,Opted,Invoice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + r + "',10,'Convert','" + Order.Convert + "','" + Order.Invoice + "','" + Order.CreatedBy + "','" + ServerDateTime + "',0,1)";
//command.ExecuteNonQuery();
}
transaction.Commit();
cnn.Close();
List <RazorPaymentPost> dbPaymentPost = new List <RazorPaymentPost>();
RazorPaymentPost dashboardlistpackage = new RazorPaymentPost {
invoice = Convert.ToString(Invoice), memberShipCode = Convert.ToString(r), orderId = Convert.ToString(Order.OrderId)
};
dbPaymentPost.Add(dashboardlistpackage);
nfc.PushToMobile("", "Alert From PostPaymentDetails");
int val = SendMessage(Order.MobileNo, arl_pdetails[0].ToString());
RPFO.status = "success";
RPFO.value = dbPaymentPost;
sJSONResponse = JsonConvert.SerializeObject(RPFO);
}
}
catch (Exception ex)
{
try
{
transaction.Rollback();
RPFO.status = "Fail";
}
catch (Exception ex2)
{
RPFO.status = "Fail";
}
}
sJSONResponse = JsonConvert.SerializeObject(RPFO);
}
catch (Exception ec)
{
}
return(sJSONResponse);
}
