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 CheckPincodeModel CheckPincode(String Pincode)
{
CheckPincodeModel objchkpincode = new CheckPincodeModel();
DataTable ShipperList = dbCon.GetAllActiveShipperDetails();
//int pincode = 0;
try
{
if (Pincode != null && Pincode != "" && Pincode.Length == 6)
{
foreach (DataRow dr in ShipperList.Rows)
{
int ShipperId = int.Parse(dr["Id"].ToString());
int pincode = int.Parse(Pincode);
var value = dbCon.CheckAvailability(pincode, ShipperId);
if (value == 0)
{
objchkpincode.resultflag = "0";
objchkpincode.Message = "Delivery is not available in this area.";
objchkpincode.JurisdictionID = "0";
}
else
{
DataTable dtJurisdiction = dbCon.GetAllJurisdiction(pincode);
if (dtJurisdiction.Rows.Count > 0)
{
objchkpincode.resultflag = "1";
objchkpincode.Message = "Service available at " + pincode;
objchkpincode.JurisdictionID = dtJurisdiction.Rows[0]["JurisdictionID"].ToString();
}
else
{
objchkpincode.resultflag = "0";
objchkpincode.Message = "Delivery is not available in this area.";
objchkpincode.JurisdictionID = "0";
}
}
}
string Querydata = " SELECT Top 1 Z.Id, C.Id AS CityId, C.CityName, S.Id AS StateId, S.StateName " +
" from ZipCode Z " +
" LEFT JOIN CityMaster C ON C.CityName = Z.District " +
" LEFT JOIN StateMaster S ON S.StateName = Z.State " +
" where Z.IsActive = 1 AND Z.Zipcode = " + Pincode +
" Order by 1 desc ";
DataTable dtPincode = dbCon.GetDataTable(Querydata);
if (dtPincode != null && dtPincode.Rows.Count > 0)
{
string cityId = dtPincode.Rows[0]["CityId"].ToString();
string cityname = dtPincode.Rows[0]["CityName"].ToString();
string stateid = dtPincode.Rows[0]["StateId"].ToString();
string Statename = dtPincode.Rows[0]["StateName"].ToString();
objchkpincode.CountryID = "1";
objchkpincode.CountryName = "India";
objchkpincode.StateID = stateid;
objchkpincode.StateName = Statename;
objchkpincode.CityId = cityId;
objchkpincode.CityName = cityname;
}
}
else
{
objchkpincode.resultflag = "0";
objchkpincode.Message = "Enter Valid Pincode";
objchkpincode.JurisdictionID = "0";
}
}
catch (Exception ex)
{
}
return(objchkpincode);
}