public AddFranchiesResponse BecomeNewFranchise(AddFranchies model)
{
Logger.InsertLogsApp("Insert Franchisee start ");
AddFranchiesResponse objFranchies = new AddFranchiesResponse();
try
{
string[] insert = { model.Name.ToString(), model.Email.ToString(), model.Mobile.ToString(), model.PinCode.ToString(), model.Address.ToString(), model.CreatedBy.ToString() };
string insertFrenchies = "INSERT INTO [dbo].[FranchiesMaster]([Name],[Email],[Mobile],[PinCode],[Address],[IsActive],[CreatedDate],[CreatedBy]) VALUES (@1,@2,@3,@4,@5,1,GetDate(),@6);Select SCOPE_IDENTITY()";
int sourceid = dbc.ExecuteScalarQueryWithParams(insertFrenchies, insert);
if (sourceid > 0)
{
objFranchies.response = "1";
objFranchies.FranchieId = sourceid.ToString();
objFranchies.message = "Thank you for registering. We will contact you very soon!";
ClsCommon.SendFranchiesEmail(model.Email, model.Name, model.Mobile, model.Address, model.PinCode);
}
else
{
objFranchies.response = "0";
objFranchies.FranchieId = "0";
objFranchies.message = "Please Try Again!!";
}
}
catch (Exception ex)
{
objFranchies.response = "0";
objFranchies.FranchieId = "0";
objFranchies.message = "Please Try Again!!";
}
return(objFranchies);
}
public int CreateAlternateOrder(string Customerid, string transid, string Address, string paidAmount, string Quantity, string buywith, string discountamount = "", string Redemeamount = "", string coupanCode = "")
{
try
{
Logger.InsertLogsApp("PlaceOrder CreateAlternateOrder start : step 1");
if (discountamount == "")
{ discountamount = "0"; }
if (Redemeamount == "")
{ Redemeamount = "0"; }
if (coupanCode == "")
{ coupanCode = "0"; }
decimal totalamount = 0;
decimal totalgram = 0;
decimal totaloffer = 0;
decimal totalsaving = 0;
decimal totalquantity = 0;
decimal shiprate = 0;
decimal newprice = 0, NewTotalAmount = 0;
string startdate = dbCon.getindiantime().ToString("dd/MMM/yyyy HH:mm:ss");
DataTable ShipperList = dbCon.GetAllActiveShipperDetails();
string qrypncd = "select Pincode from [CustomerAddress] where Id="+Address +"and CustomerId="+Customerid;
DataTable dtpncd = dbCon.GetDataTable(qrypncd);
int pincode = int.Parse(dtpncd.Rows[0]["Pincode"].ToString());
foreach (DataRow dr in ShipperList.Rows)
{
int ShipperId = int.Parse(dr["Id"].ToString());
Logger.InsertLogsApp("PlaceOrder CreateAlternateOrder CheckAvailability : step 2");
var value = dbCon.CheckAvailability(pincode, ShipperId);
if (value > 0)
{
Logger.InsertLogsApp("PlaceOrder CreateAlternateOrder CheckAvailability start : step 3");
//string querystr = "select * from Product where IsActive=1 and IsDeleted=0 and [StartDate]<='" + startdate + "' and [EndDate]>='" + startdate + "' and id=1045";
string querystr = "select * from Product Where StartDate<='" + dbCon.getindiantime().ToString("dd/MMM/yyyy HH:mm:ss") + "' and EndDate>='" + dbCon.getindiantime().ToString("dd/MMM/yyyy HH:mm:ss") + "'";
DataTable dtmain = dbCon.GetDataTable(querystr);
if (dtmain != null && dtmain.Rows.Count > 0)
{
Logger.InsertLogsApp("PlaceOrder CreateAlternateOrder dtmain start : step 4");
int productid = Convert.ToInt32(dtmain.Rows[0]["Id"]);
decimal offer = 0, price = 0,buywithprice=0;
offer = Convert.ToDecimal(dtmain.Rows[0]["Offer"]);
//for check pincode servicebility
//DataTable dtZippcode = dbCon.GetDataTable("select ZipPostalCode from [Address] where Id=" + Address);
// objorder.IsServicable = ChecoutCheckPinCode(dtZippcode.Rows[0]["ZipPostalCode"].ToString(), productid.ToString()).ToString();
string productname = dtmain.Rows[0]["Name"].ToString();
int gram = 0;
int quantity = Convert.ToInt32(Quantity);
price = Convert.ToDecimal(dtmain.Rows[0]["Mrp"]);
decimal finalamount= 0,newfinalamount=0;
finalamount = Convert.ToDecimal(dtmain.Rows[0]["Mrp"]) * quantity;
if(buywith =="1")
{
buywithprice = Convert.ToDecimal(dtmain.Rows[0]["Mrp"]);
newfinalamount = Convert.ToDecimal(dtmain.Rows[0]["Mrp"]) * quantity;
}
else if(buywith =="2")
{
buywithprice = Convert.ToDecimal(dtmain.Rows[0]["BuyWith1FriendExtraDiscount"]);
newfinalamount = Convert.ToDecimal(dtmain.Rows[0]["BuyWith1FriendExtraDiscount"]) * quantity;
}
else if(buywith =="6")
{
buywithprice = Convert.ToDecimal(dtmain.Rows[0]["BuyWith5FriendExtraDiscount"]);
newfinalamount = Convert.ToDecimal(dtmain.Rows[0]["BuyWith5FriendExtraDiscount"]) * quantity;
}
decimal PricePerUnit = Math.Round(newfinalamount / quantity);
decimal FixedPrice = Convert.ToDecimal(dtmain.Rows[0]["FixedShipRate"]);
totaloffer += offer * quantity;
if (totaloffer > 0)
{
newprice = newfinalamount - offer;
}
else
{
newprice = newfinalamount;
}
gram = Convert.ToInt32(dtmain.Rows[0]["Unit"].ToString());
totalgram += (gram * quantity);
shiprate = Convert.ToDecimal(dtmain.Rows[0]["Offer"].ToString());
if (dtmain.Rows[0]["FixedShipRate"].ToString() != null && shiprate > 0)
NewTotalAmount = newprice + shiprate;
else
NewTotalAmount = newprice;
//vaishnavi Changes
totalamount = Math.Round(NewTotalAmount);
string[] param = { Address };
DataTable dtAddress = dbCon.GetDataTableWithParams("select [CustomerId],[FirstName],[LastName],[CountryId],[StateId],[CityId],[Address],[MobileNo],[PinCode] from [CustomerAddress] where [IsDeleted]=0 and [IsActive]=1 and Id=@1", param);
if (dtAddress != null && dtAddress.Rows.Count > 0)
{
if (paidAmount == "")
{
paidAmount = "0";
}
string insertquery = "insert into AlterNetOrder([OrderGuid],[CustomerId],[AddressId],[OrderStatusId],[OrderDiscount],[OrderMRP],[OrderTotal],[RefundedAmount],[CustomerIp],[ShippingMethod],[Deleted],[CreatedOnUtc],[TotalQty],[PaidAmount],[TotalGram],[TotalSaving],[Customer_Redeem_Amount],[TrnId],[IsPaymentDone],[OrderSourceId],[CustOfferCode],[RefferedOfferCode],[PaymentGatewayId],[BuyWith],[UpdatedOnUtc]) values (@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,GETDATE(),@12,@13,@14,@15,@16,@17,@18,@19,@20,@21,@22,@23,GETDATE());Select SCOPE_IDENTITY()";
string[] param1 = { Guid.NewGuid().ToString(), Customerid, Address, "10", discountamount, finalamount.ToString(), newfinalamount.ToString(), "0", dbCon.GetIP4Address().ToString(), ShipperId.ToString(), "0", quantity.ToString(), paidAmount, totalgram.ToString(), totalsaving.ToString(), Redemeamount, transid, "0", "3", coupanCode, "", "1" ,buywith};
int Orderrslt = dbCon.ExecuteScalarQueryWithParams(insertquery, param1);
if (Orderrslt > 0)
{
string gst = "select [TaxValue] from [GstTaxCategory] where Id=" + dtmain.Rows[0]["GSTTaxId"].ToString();
DataTable dtgstv = dbCon.GetDataTable(gst);
string insertquery1 = "insert into [AlternetOrderItem](OrderId,[ProductId],[Quantity],[MrpPerUnit],[DiscountPerUnit],[ExtraDiscountPerUnit],[SGSTValuePerUnit],[SGSTAmountPerUnit],[CGSTValuePerUnit],[CGSTAmountPerUnit],[IGSTValuePerUnit],[IGSTAmountPerUnit],[TaxablePerUnit],[TotalAmount],[ProductName],[BuyWith],[BuyWithPerUnit],[CreatedOnUtc]) values (@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13,@14,@15,@16,@17,GETDATE());Select SCOPE_IDENTITY()";
string[] param11 = { Orderrslt.ToString(), productid.ToString(), quantity.ToString(), price.ToString(), discountamount, offer.ToString(), "0", "0", "0", "0", "0", "0", dtgstv.Rows[0]["TaxValue"].ToString(), paidAmount, productname, buywith.ToString(), buywithprice.ToString() };
int result11 = dbCon.ExecuteScalarQueryWithParams(insertquery1, param11);
return result11;
}
else
{
return 0;
}
}
}
}
else
{
return 0;
}
}
}
catch
{
return 0;
}
return 0;
}
public int CreateOrderFromAlternetOrder(string txnId, string amount)
{
try
{
int AlternetOrderId = 0;
int OrderId = 0;
int addressid = 0;
int cust_id = 0;
decimal redeemedamount = 0;
#region Insert Order
DataTable Get_ALternetOrder = dbCon.GetDataTable("select * from AlterNetOrder where TrnId='" + txnId + "' order by CreatedOnUtc desc;");
if (Get_ALternetOrder != null && Get_ALternetOrder.Rows.Count > 0)
{
for (int order = 0; order < Get_ALternetOrder.Rows.Count; order++)
{
try
{
decimal.TryParse(Get_ALternetOrder.Rows[0]["Customer_Redeem_Amount"].ToString(), out redeemedamount);
int.TryParse(Get_ALternetOrder.Rows[0]["Id"].ToString(), out AlternetOrderId);
int.TryParse(Get_ALternetOrder.Rows[0]["AddressId"].ToString(), out addressid);
int.TryParse(Get_ALternetOrder.Rows[0]["CustomerId"].ToString(), out cust_id);
if (addressid == 0)
{
DataTable add_id = dbCon.GetDataTable("select Top 1 Address_Id from CustomerAddress where CustomerId = " + cust_id + " order by Id desc;");
if (add_id != null && add_id.Rows.Count > 0)
{
if (addressid == 0)
{
int.TryParse(add_id.Rows[0]["Id"].ToString(), out addressid);
}
}
}
#region ORDER INSERT PROCESS
string[] insert =
{
Get_ALternetOrder.Rows[0]["OrderGuid"].ToString(),
Get_ALternetOrder.Rows[0]["CustomerId"].ToString(),
addressid.ToString(),
Get_ALternetOrder.Rows[0]["OrderStatusId"].ToString(),
Get_ALternetOrder.Rows[0]["OrderDiscount"].ToString(),
Get_ALternetOrder.Rows[0]["OrderMRP"].ToString(),
Get_ALternetOrder.Rows[0]["OrderTotal"].ToString(),
Get_ALternetOrder.Rows[0]["ShippingMethod"].ToString(),
Get_ALternetOrder.Rows[0]["TotalQty"].ToString(),
amount,
Get_ALternetOrder.Rows[0]["TotalGram"].ToString(),
Get_ALternetOrder.Rows[0]["Customer_Redeem_Amount"].ToString(),
txnId,
Get_ALternetOrder.Rows[0]["IsPaymentDone"].ToString(),
Get_ALternetOrder.Rows[0]["CustOfferCode"].ToString(),
Get_ALternetOrder.Rows[0]["RefferedOfferCode"].ToString(),
Get_ALternetOrder.Rows[0]["PaymentGatewayId"].ToString(),
Get_ALternetOrder.Rows[0]["BuyWith"].ToString(),
};
string cmd = "INSERT INTO [dbo].[Order]([OrderGuid],[CustomerId],[AddressId],[OrderStatusId],[OrderDiscount],[OrderMRP],[OrderTotal],[ShippingId],[TotalQTY],[PaidAmount],[TotalGram],[CustReedeemAmount],[TRNID],[IsPaymentDone],[CustOfferCode],[RefferedOfferCode],[PaymentGatewayId],[BuyWith],[CreatedOnUtc],[UpdatedOnUtc]) VALUES(@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13,@14,@15,@16,@17,@18,DATEADD(MINUTE, 330, GETUTCDATE()),DATEADD(MINUTE, 330, GETUTCDATE())); SELECT SCOPE_IDENTITY();";
OrderId = dbCon.ExecuteScalarQueryWithParams(cmd, insert);
if (OrderId == 0)
{
Logger.InsertLogs(Test0555.Logger.InvoiceLOGS.InvoiceLogLevel.Error, txnId, 0, false, "1.Order Id not generated", " ");
return(0);
//PRINT ERROR : ORDER ID 0
}
else
{
}
#endregion
if (AlternetOrderId > 0 && OrderId > 0)
{
#region Insert OrderItem
DataTable Get_AlternetOrderItem = dbCon.GetDataTable("SELECT * FROM [AlterNetOrderItem] where OrderId = '" + Get_ALternetOrder.Rows[order]["Id"].ToString() + "' order by CreatedOnUtc desc;");
if (Get_AlternetOrderItem != null && Get_AlternetOrderItem.Rows.Count > 0)
{
for (int orderitem = 0; orderitem < Get_AlternetOrderItem.Rows.Count; orderitem++)
{
try
{
string[] insertitem =
{
OrderId.ToString(),
Get_AlternetOrderItem.Rows[orderitem]["ProductId"].ToString(),
Get_AlternetOrderItem.Rows[orderitem]["Quantity"].ToString(),
Get_AlternetOrderItem.Rows[orderitem]["MrpPerUnit"].ToString(),
Get_AlternetOrderItem.Rows[orderitem]["BuyWithPerUnit"].ToString(),
Get_AlternetOrderItem.Rows[orderitem]["DiscountPerUnit"].ToString(),
Get_AlternetOrderItem.Rows[orderitem]["ExtraDiscountPerUnit"].ToString(),
Get_AlternetOrderItem.Rows[orderitem]["SGSTValuePerUnit"].ToString(),
Get_AlternetOrderItem.Rows[orderitem]["SGSTAmountPerUnit"].ToString(),
Get_AlternetOrderItem.Rows[orderitem]["CGSTValuePerUnit"].ToString(),
Get_AlternetOrderItem.Rows[orderitem]["CGSTAmountPerUnit"].ToString(),
Get_AlternetOrderItem.Rows[orderitem]["IGSTValuePerUnit"].ToString(),
Get_AlternetOrderItem.Rows[orderitem]["IGSTAmountPerUnit"].ToString(),
Get_AlternetOrderItem.Rows[orderitem]["TaxablePerUnit"].ToString(),
Get_AlternetOrderItem.Rows[orderitem]["TotalAmount"].ToString(),
Get_AlternetOrderItem.Rows[orderitem]["ProductName"].ToString(),
Get_AlternetOrderItem.Rows[orderitem]["BuyWith"].ToString(),
};
string cmditem = "INSERT INTO [dbo].[OrderItem] ([OrderId] ,[ProductId] ,[Quantity] ,[MrpPerUnit],[BuyWithPerUnit],[DiscountPerUnit],[ExtraDiscountPerUnit],[SGSTValuePerUnit],[SGSTAmountPerUnit],[CGSTValuePerUnit],[CGSTAmountPerUnit],[IGSTValuePerUnit],[IGSTAmountPerUnit],[TaxablePerUnit],[TotalAmount],[ProductName],[BuyWith],[CreatedOnUtc]) VALUES (@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13,@14,@15,@16,@17,DATEADD(MINUTE, 330, GETUTCDATE())); SELECT SCOPE_IDENTITY();";
int OrderItemId = dbCon.ExecuteScalarQueryWithParams(cmditem, insertitem);
try
{
if (OrderItemId > 0 && redeemedamount > 0)
{
string Drwallet = "insert into [Customer_Wallet_History] ([CustomerId],[Dr_Amount],[Cr_Amount],[DOC],[Wallet_Type],[Message],[OrderId],[Amount]) values (@1,@2,@3,GETDATE(),@4,@5,@6,@7);Select SCOPE_IDENTITY()";
string[] paramDRWallet = { cust_id.ToString(), redeemedamount.ToString(), "0", "System", "OrderId " + OrderId.ToString() + "", OrderId.ToString(), "0" };
int DR_rslt = dbCon.ExecuteScalarQueryWithParams(Drwallet, paramDRWallet);
}
}
catch (Exception)
{
}
if (OrderItemId == 0)
{
Logger.InsertLogs(Test0555.Logger.InvoiceLOGS.InvoiceLogLevel.Error, txnId, 0, false, "1.Order Item not generated", " ");
return(0);
//PRINT ERROR : ORDER ITEM ID 0
}
}
catch (Exception ex)
{
Logger.InsertLogs(Test0555.Logger.InvoiceLOGS.InvoiceLogLevel.Error, txnId, 0, false, "OrderItem Id not generated" + txnId, ex.Message.ToString());
return(0);
//PRINT ERROR
}
finally
{
dbCon.closeConnection();
}
}
}
else
{
Logger.InsertLogs(Test0555.Logger.InvoiceLOGS.InvoiceLogLevel.Error, txnId, 0, false, "1.EMPTY DATA TABLE FOUND OF ALTERNET-ORDERITEM", " ");
// EMPTY DATA TABLE FOUND OF ALTERNET-ORDERITEM!
return(0);
}
#endregion
}
else
{
return(0);
//PRINT ERROR
}
}
catch (Exception ex)
{
Logger.InsertLogs(Test0555.Logger.InvoiceLOGS.InvoiceLogLevel.Error, txnId, 0, false, "Order Id not generated", ex.Message.ToString());
return(0);
}
finally
{
dbCon.closeConnection();
}
}
#region SendFIRSTOrderSMS
if (OrderId != 0)
{
try
{
DataTable dtcheck = dbCon.GetDataTable("select distinct Customer.Id,Customer.Mobile from Customer inner join [Order] on [Order].CustomerId=[Customer].Id where Customer.Id=" + cust_id + " group by Customer.Id,Customer.Mobile having count([Order].Id)>=1");
string data = "SELECT [Order].OrderMRP, [Order].AddressId, [Order].OrderTotal,[Order].CustOfferCode, CONVERT(varchar, Product.EndDate,106)+' '+ CONVERT(varchar, Product.EndDate,108) as lastdate FROM [Order] INNER JOIN OrderItem ON [Order].Id = OrderItem.OrderId INNER JOIN Product ON OrderItem.ProductId = Product.Id where [Order].Id=" + OrderId;
DataTable dtdata = dbCon.GetDataTable(data);
string price = "Rs." + dtdata.Rows[0]["OrderTotal"].ToString();
string date = dtdata.Rows[0]["lastdate"].ToString();
string orderidid = OrderId.ToString();
string offcode = dbCon.Base64Encode(orderidid);
DataTable dtcustomerwp = dbCon.GetDataTable("select ISNULL(IsInWhatsappGroup,0) as IsInWhatsappGroup FROM Customer where Customer.Id=" + cust_id);
var IsInWhatsappGroup = Convert.ToBoolean(dtcustomerwp.Rows[0]["IsInWhatsappGroup"]);
var AddId = dtdata.Rows[0]["AddressId"].ToString();
DataTable dtcustomerzip = dbCon.GetDataTable("select PinCode FROM CustomerAddress where Id=" + AddId);
var zipcode = dtcustomerzip.Rows[0]["PinCode"].ToString();
DataTable dtwpurl = dbCon.GetDataTable("select Url FROM WhatsappUrls where zipcode=" + zipcode);
var wpurl = dtwpurl.Rows[0]["Url"].ToString();
if (dtcheck.Rows.Count > 0)
{
string SMS_Text11 = "Your SoSho order " + OrderId + " for COD " + price + " placed. Delivery in 1-2 days." +
Environment.NewLine + "Join us to receive exciting offer from sosho click here " + wpurl;
//string SMS_Text11 = "Your OrderNo:"+ OrderId +" has been Successfully Placed.";
dbCon.SendSMS(dtcheck.Rows[0]["Mobile"].ToString(), SMS_Text11);
//if (!IsInWhatsappGroup)
//{
// string smstxt = "Join us to receive exciting offer from sosho click here " + wpurl;
// dbCon.SendSMS(dtcheck.Rows[0]["Mobile"].ToString(), smstxt);
//}
}
}
catch (Exception e)
{
}
}
#endregion
//#region SendFIRSTOrderSMS
//if (OrderId != 0)
//{
// try
// {
// DataTable dtcheck = dbCon.GetDataTable("select distinct Customer.Id,Customer.Mobile from Customer inner join [Order] on [Order].CustomerId=[Customer].Id where [Customer].Email is not null and Customer.Id=" + cust_id + " group by Customer.Id,Customer.Mobile having count([Order].Id)>=1");
// if (dtcheck.Rows.Count > 0)
// {
// string SMS_Text11 = "Your OrderNo:"+ OrderId +" has been Successfully Placed.";
// int res1 = dbCon.Customer_Wallet_SMS(dtcheck.Rows[0]["Mobile"].ToString(), SMS_Text11);
// }
// }
// catch (Exception e)
// {
// }
//}
//#endregion
//#region sendMail
//string sendMailTemplete = @"select * from MessageTemplate where Id=1";
//DataTable dtCustomersendMail = dbCon.GetDataTable(sendMailTemplete);
//if (dtCustomersendMail != null && dtCustomersendMail.Rows.Count > 0)
//{
// string Body = dtCustomersendMail.Rows[0]["Body"].ToString();
// StringBuilder sb = new StringBuilder();
// sb.Append(Body);
// string ToEmail = dbCon.GetEmailFromCustomerId(cust_id.ToString());
// sb.Replace("%OrderId%", OrderId.ToString());
// decimal PaidAmount = Convert.ToDecimal(amount);
// sb.Replace("%PaidAmount%", PaidAmount.ToString("0.##"));
// double s= SendNotificationEmail("Thank you for your order on salebhai.com", sb.ToString(), "1", "*****@*****.**", "Salebhai", ToEmail, ToEmail, "1");
//}
//#endregion
}
#endregion
return(OrderId);
}
catch (Exception ex)
{
Logger.InsertLogs(Test0555.Logger.InvoiceLOGS.InvoiceLogLevel.Error, txnId, 0, false, "1.EMPTY DATA TABLE FOUND", " ");
return(0);
}
finally
{
dbCon.closeConnection();
}
}