public ActionResult Test()
{
HG_Orders.OrderAmt(42, 0);
WalletAmt walletAmt = WalletAmt.GetUnusedWalletAmt(42, 6);
return(Content("0"));
}
public ActionResult DiscntCharges(Int64 SeatingId, int Type = 0, int ID = 0, Int64 OID = 0)
{
OrdDiscntChrge ordDiscntChrge = new OrdDiscntChrge();
if (SeatingId > 0)
{
HG_Tables_or_Sheat SeatingObj = new HG_Tables_or_Sheat().GetOne(SeatingId);
List <HG_Orders> orders = new HG_Orders().GetListByGetDate(DateTime.Now, DateTime.Now);
var ObjOrder = orders.Find(x => x.Table_or_SheatId == SeatingId && x.TableOtp == SeatingObj.Otp);
if (ObjOrder != null && ObjOrder.Status != "3" && ObjOrder.Status != "4")
{
ordDiscntChrge.OID = ObjOrder.OID;
}
ordDiscntChrge.Type = Type;
ordDiscntChrge.SeatingId = SeatingId;
ordDiscntChrge.SeatingOtp = SeatingObj.Otp;
}
else if (ID > 0)
{
ordDiscntChrge = OrdDiscntChrge.GetOne(ID);
Type = ordDiscntChrge.Type;
}
else if (OID > 0 && Type != 0)
{
ordDiscntChrge.Type = Type;
ordDiscntChrge.OID = OID;
}
return(View(ordDiscntChrge));
}
public static Feedbk SubmitFeedBk(Int64 OID)
{
Feedbk feedBack = Feedbk.GetOne(OID);
// public int FeedBkId { get; set; }
//public int OrgId { get; set; }
//public Int64 OrderId { get; set; }
//public int FeedbkFormId { get; set; }
if (feedBack.FeedBkId == 0)
{
HG_Orders hG_Orders = new HG_Orders().GetOne(OID);
HG_Tables_or_Sheat hG_Tables_Or_Sheat = new HG_Tables_or_Sheat().GetOne(hG_Orders.Table_or_SheatId);
feedBack = new Feedbk();
feedBack.FeedbkFormId = hG_Tables_Or_Sheat.FDBKId;
feedBack.OrgId = hG_Orders.OrgId;
feedBack.OrderId = OID;
feedBack.save();
return(feedBack);
}
else
{
return(feedBack);
}
}
public ActionResult SaveDiscntCharge(OrdDiscntChrge discntCharge)
{
if (discntCharge.Remark == null)
{
discntCharge.Remark = "";
}
if (discntCharge.Title == null || discntCharge.Title.Replace(" ", "") == "")
{
return(Json(new { msg = "Title required" }, JsonRequestBehavior.AllowGet));
}
if (discntCharge.Amt > 0 && discntCharge.Tax > 0)
{
return(Json(new { msg = "fill Single Option" }, JsonRequestBehavior.AllowGet));
}
if (discntCharge.Amt <= 0 && discntCharge.Tax <= 0)
{
return(Json(new { msg = "value cannot be zero" }, JsonRequestBehavior.AllowGet));
}
if (discntCharge.ID > 0)// modify discnt charges
{
discntCharge.Save();
}
else if (discntCharge.OID > 0 && discntCharge.SeatingId == 0)//edit Order
{
discntCharge.Save();
HG_Orders hG_Orders = new HG_Orders().GetOne(discntCharge.OID);
if (hG_Orders.OID > 0)
{
if (hG_Orders.DisntChargeIDs != "" && hG_Orders.DisntChargeIDs != "0")
{
hG_Orders.DisntChargeIDs = hG_Orders.DisntChargeIDs + "," + discntCharge.ID;
}
else
{
hG_Orders.DisntChargeIDs = discntCharge.ID.ToString();
}
hG_Orders.Save();
}
}
else if (discntCharge.OID > 0 && discntCharge.SeatingId > 0)
{
DiscntCharge.ListDiscntChrge.Add(discntCharge);
OrdDiscntChrge.RemoveDiscntCharge(discntCharge.SeatingId, discntCharge.SeatingOtp, discntCharge.OID);
}
else
{
DiscntCharge.ListDiscntChrge.Add(discntCharge);
}
return(Json(new { data = discntCharge }, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveEditOrder(Int64 OID, int PMode)
{
var UserInfo = Request.Cookies["UserInfo"];
var UserType = UserInfo["UserType"];
HG_Orders ObjOrder = new HG_Orders().GetOne(OID);
if (UserType != "SA")
{
if (ObjOrder.Create_Date < DateTime.Now.AddDays(-2).Date)
{
return(Json(new { msg = "Can't Modify Order After 2 days" }));
}
if (ObjOrder.PaymentStatus == 3 && PMode != ObjOrder.PaymentStatus)
{
return(Json(new { msg = "Can't change Payment mode" }));
}
if (ObjOrder.PaymentStatus != 3 && PMode == 3)
{
return(Json(new { msg = "Can't change Payment To foodDo" }));
}
}
ObjOrder.PaymentStatus = PMode;
var OrderItems = new HG_OrderItem().GetAll(OID);
var OrderItemsWithouTicket = OrderItems.FindAll(x => x.TickedNo == 0);
if (OrderItemsWithouTicket.Count > 0)
{
List <HG_Ticket> list = new HG_Ticket().GetAll(ObjOrder.OrgId, onDate: ObjOrder.Create_Date);
HG_Ticket objticket = new HG_Ticket()
{
OrgId = ObjOrder.OrgId, OID = ObjOrder.OID, TicketNo = list.Count + 1, DeliveryCharge = 0, CreationDate = ObjOrder.Create_Date
};
int Ticketno = objticket.save();
foreach (var OrdItem in OrderItemsWithouTicket)
{
OrdItem.TickedNo = Ticketno;
OrdItem.Save();
}
}
var CompletedCancelItems = OrderItems.FindAll(x => x.Status == 3 || x.Status == 4);
if (ObjOrder.PaymentStatus > 0 && OrderItems.Count == CompletedCancelItems.Count)
{
ObjOrder.Status = "3";// mark completed
}
ObjOrder.Save();
return(Json(new { data = OID }, JsonRequestBehavior.AllowGet));
}
public JObject ApplyWallet(string Jobj)
{
JObject obj = JObject.Parse(Jobj);
Wallet wallet = new Wallet();
wallet.WalletId = 0;
wallet.CID = int.Parse(obj["CID"].ToString());
wallet.OID = int.Parse(obj["OID"].ToString());
wallet.CashBkId = 0;
wallet.CashBkAmt = 0;
wallet.DeductedAmt = double.Parse(obj["DeductedAmt"].ToString());;
wallet.AmtActiveOn = DateTime.Now;
wallet.OrgId = int.Parse(obj["OrgId"].ToString());
wallet.Save();
JObject result = new JObject();
if (wallet.WalletId > 0)
{
OrdDiscntChrge ordDiscntChrge = new OrdDiscntChrge();
ordDiscntChrge.ID = 0;
ordDiscntChrge.Title = "CashBack";
ordDiscntChrge.OID = wallet.OID;
ordDiscntChrge.Type = 1;
ordDiscntChrge.Amt = wallet.DeductedAmt;
ordDiscntChrge.Tax = 0;
ordDiscntChrge.Remark = "CashBack Amount";
ordDiscntChrge.Save();
HG_Orders hG_Orders = new HG_Orders().GetOne(wallet.OID);
if (hG_Orders.OID > 0)
{
if (hG_Orders.DisntChargeIDs != "" && hG_Orders.DisntChargeIDs != "0")
{
hG_Orders.DisntChargeIDs = hG_Orders.DisntChargeIDs + "," + ordDiscntChrge.ID;
}
else
{
hG_Orders.DisntChargeIDs = ordDiscntChrge.ID.ToString();
}
hG_Orders.Save();
}
result.Add("Status", 200);
}
else
{
result.Add("Status", 400);
}
return(result);
}
public ActionResult Delete(int ID)
{
HG_Tables_or_Sheat ObjTable = new HG_Tables_or_Sheat().GetOne(ID);
if (ObjTable != null)
{
List <HG_Orders> listord = new HG_Orders().GetAll(ObjTable.OrgId);
listord = listord.FindAll(x => x.Table_or_SheatId == ObjTable.Table_or_RowID);
if (listord.Count > 0)
{
// Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Json(new { msg = "Already Used in " + listord.Count.ToString() + " Orders" }, JsonRequestBehavior.AllowGet));
}
else
{
HG_Tables_or_Sheat.Dell(ObjTable.Table_or_RowID);
}
}
return(Json(new { data = "1" }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetDetails(List <HG_OrderItem> CompletedItems)
{
BalanceStatement bObj = new BalanceStatement();
List <BalanceStatement> jObjList = new List <BalanceStatement>();
List <HG_Orders> OrdersDetails = new List <HG_Orders>();
List <HG_OrganizationDetails> OrgList = new List <HG_OrganizationDetails>();
List <HG_Orders> OrdrList = new List <HG_Orders>();
int LastEntryNo = 0;
double LastBalance = 0.00;
List <PaytmResn> Onlinepayment = new List <PaytmResn>();
double totalAmount = 0.00;
HG_Orders ord = new HG_Orders().GetOne(CompletedItems[0].OID);
if (ord.PaymentStatus == 1 || ord.PaymentStatus == 2)
{
for (int i = 0; i < CompletedItems.Count; i++)
{
OrdrList = new HG_Orders().GetAll(CompletedItems[i].OrgId, Status: 3);
HG_Orders Ord = OrdrList.Find(x => x.OID == CompletedItems[i].OID);
totalAmount += Ord.DeliveryCharge;
totalAmount += CompletedItems[i].Count * CompletedItems[i].Price;
}
Ledger LedgerDetails = Ledger.GetAllList().Where(x => x.DebtorType == 1 &&
x.OrgId == CompletedItems[0].OrgId).FirstOrDefault();
bObj.Date = DateTime.Now;
bObj.Amount = totalAmount;
bObj.OrgId = LedgerDetails.OrgId;
bObj.OrderId = CompletedItems[0].OID;
BalanceStatement TotalBalance = BalanceStatement.GetAllForBalanceCalculation(CompletedItems[0].OrgId).Last();
bObj.Balance = TotalBalance.Balance + totalAmount;
bObj.isCash = true;
BalanceStatement Obj = new BalanceStatement();
HG_Orders od = new HG_Orders().GetOne(bObj.OrderId);
Ledger LedgerDetail = Ledger.GetAllList().Where(x => x.DebtorType == 1 &&
x.OrgId == bObj.OrgId).FirstOrDefault();
if (od.PaymentStatus == 1 || od.PaymentStatus == 2)
{
double amt = (bObj.Amount * LedgerDetails.MarginOnCash) / 100;
Obj.CRAmount = (amt) + ((amt * LedgerDetails.TaxOnAboveMargin) / 100);
Obj.TaxOnCash = LedgerDetails.TaxOnAboveMargin;
}
else if (od.PaymentStatus == 3)
{
double amt = (bObj.Amount * LedgerDetails.MarginOnline) / 100;
Obj.CRAmount = (amt) + ((amt * LedgerDetails.TaxOnAboveMarginOnline) / 100);
Obj.TaxOnOnline = LedgerDetails.TaxOnAboveMarginOnline;
}
Obj.Date = bObj.Date;
// Obj.Amount = Amount;
BalanceStatement TBalance = BalanceStatement.GetAllForBalanceCalculation(bObj.OrgId).Last();
Obj.Balance = TBalance.Balance - Obj.CRAmount;
Obj.OrgId = bObj.OrgId;
Obj.OrderId = bObj.OrderId;
Obj.Narration = "Commission of Order No." + bObj.OrderId;
Obj.SaveCRValue();
}
else if (ord.PaymentStatus == 3)
{
double OAmount = 0.00;
Onlinepayment = PaytmResn.GetAll();
PaytmResn paytmTxn = Onlinepayment.Find(x => x.OID == CompletedItems[0].OID);
totalAmount += ord.DeliveryCharge;
totalAmount += Convert.ToDouble(paytmTxn.PaidAmount);
Ledger LedgerDetails = Ledger.GetAllList().Where(x => x.DebtorType == 1 &&
x.OrgId == CompletedItems[0].OrgId).FirstOrDefault();
bObj.Date = DateTime.Now;
bObj.Amount = totalAmount;
bObj.OrgId = LedgerDetails.OrgId;
bObj.OrderId = CompletedItems[0].OID;
BalanceStatement TotalBalance = BalanceStatement.GetAllForBalanceCalculation(CompletedItems[0].OrgId).Last();
bObj.Balance = TotalBalance.Balance + totalAmount;
bObj.Narration = "Online Payment of Order No." + CompletedItems[0].OID;
bObj.isCash = false;
bObj.SaveCRValue();
BalanceStatement Obj = new BalanceStatement();
HG_Orders od = new HG_Orders().GetOne(bObj.OrderId);
Ledger LedgerDetail = Ledger.GetAllList().Where(x => x.DebtorType == 1 &&
x.OrgId == bObj.OrgId).FirstOrDefault();
if (od.PaymentStatus == 1 || od.PaymentStatus == 2)
{
double amt = (bObj.Amount * LedgerDetails.MarginOnCash) / 100;
Obj.CRAmount = (amt) + ((amt * LedgerDetails.TaxOnAboveMargin) / 100);
Obj.TaxOnCash = LedgerDetails.TaxOnAboveMargin;
}
else if (od.PaymentStatus == 3)
{
double amt = (bObj.Amount * LedgerDetails.MarginOnline) / 100;
Obj.CRAmount = (amt) + ((amt * LedgerDetails.TaxOnAboveMarginOnline) / 100);
Obj.TaxOnOnline = LedgerDetails.TaxOnAboveMarginOnline;
if (ord.PaymentStatus == 3 && ord.Status == "4")
{
double RefundAmt = bObj.Amount - OAmount;
double GetRefundAmt = (RefundAmt * 2) / 100;
double GetRefundAmtwithTax = GetRefundAmt + ((GetRefundAmt * LedgerDetails.TaxOnAboveMarginOnline) / 100);
Obj.CRAmount = Obj.CRAmount + GetRefundAmtwithTax;
}
}
Obj.Date = bObj.Date;
// Obj.Amount = Amount;
BalanceStatement TBalance = BalanceStatement.GetAllForBalanceCalculation(bObj.OrgId).Last();
Obj.Balance = TBalance.Balance - Obj.CRAmount;
Obj.OrgId = bObj.OrgId;
Obj.OrderId = bObj.OrderId;
Obj.Narration = "Commission of Order No." + bObj.OrderId;
Obj.SaveCRValue();
//===================================================================================================================
Receipt ReceiptEntry = new Receipt();
ReceiptEntry.BalanceStatementId = bObj.BID;
ReceiptEntry.Date = bObj.Date;
ReceiptEntry.Amount = bObj.Amount;
ReceiptEntry.Particular = "Online Payment of Order No." + CompletedItems[0].OID;
try
{
LastEntryNo = Receipt.GetAllList(0, 0).Select(s => s.EntryNo).Last();
}
catch (Exception ex)
{
ex.ToString();
}
if (LastEntryNo > 0)
{
ReceiptEntry.EntryNo = LastEntryNo + 1;
}
else
{
ReceiptEntry.EntryNo = 1;
}
ReceiptEntry.OrgId = bObj.OrgId;
string Customer = "Customer";
string Paytm = "Paytm";
string Bank = "BANK";
string CurrentLiabilities = "Current Liabilities";
Ledger CutomerLedger = Ledger.GetAllList().Where(x => x.Name.ToLower() == Customer.ToLower()).FirstOrDefault();
Ledger Paytmledger = Ledger.GetAllList().Where(x => x.Name.ToLower() == Paytm.ToLower()).FirstOrDefault();
ReceiptEntry.CRLedgerId = CutomerLedger.ID;
ReceiptEntry.DRLedgerId = Paytmledger.ID;
Group BankGroup = Group.GetAll().Where(x => x.Name.ToLower() == Bank.ToLower()).FirstOrDefault();
Group CurrentLiabilitiesGroup = Group.GetAll().Where(x => x.Name.ToLower() == CurrentLiabilities.ToLower()).FirstOrDefault();
ReceiptEntry.CRGroupId = CurrentLiabilitiesGroup.ID;
ReceiptEntry.DRGroupId = BankGroup.ID;
try
{
LastBalance = Receipt.GetAllList(0, 0).Select(s => s.Balance).Last();
}
catch (Exception ex)
{
ex.ToString();
}
if (LastBalance > 0)
{
ReceiptEntry.Balance = LastBalance + ReceiptEntry.Amount;
}
else
{
ReceiptEntry.Balance = ReceiptEntry.Amount;
}
ReceiptEntry.Save();
}
return(Json(new { data = bObj }, JsonRequestBehavior.AllowGet));
}
// Insert Into Balance Stement After Registration from Calaculation start Date
public ActionResult InsertIntoBalanceStementAfterRegistration(DateTime CalaculationStartFrom, int OrgId)
{
BalanceStatement bObj = new BalanceStatement();
List <BalanceStatement> jObjList = new List <BalanceStatement>();
List <HG_Orders> OrdersDetails = new List <HG_Orders>();
List <HG_OrganizationDetails> OrgList = new List <HG_OrganizationDetails>();
List <HG_Orders> OrdrList = new List <HG_Orders>();
OrdrList = new HG_Orders().GetAll(OrgId, Status: 3);
List <PaytmResn> Onlinepayment = new List <PaytmResn>();
int LastEntryNo = 0;
double LastBalance = 0.00;
foreach (var ord in OrdrList)
{
double totalAmt = 0.00;
List <HG_OrderItem> orderitemlist = new HG_OrderItem().GetAll(ord.OID);
orderitemlist = orderitemlist.FindAll(x => x.Status == 3 && x.OrderDate.Date >= CalaculationStartFrom.Date);//only completed items
if (ord.PaymentStatus == 1 || ord.PaymentStatus == 2)
{
for (int i = 0; i < orderitemlist.Count; i++)
{
OrdrList = new HG_Orders().GetAll(orderitemlist[i].OrgId, Status: 3);
HG_Orders Ord = OrdrList.Find(x => x.OID == orderitemlist[i].OID);
totalAmt += Ord.DeliveryCharge;
totalAmt += orderitemlist[i].Count * orderitemlist[i].Price;
}
BalanceStatement Obj = new BalanceStatement();
HG_Orders od = new HG_Orders().GetOne(ord.OID);
Ledger LedgerDetail = Ledger.GetAllList().Where(x => x.DebtorType == 1 &&
x.OrgId == OrgId).FirstOrDefault();
if (od.PaymentStatus == 1 || od.PaymentStatus == 2)
{
double amt = (totalAmt * LedgerDetail.MarginOnCash) / 100;
Obj.CRAmount = (amt) + ((amt * LedgerDetail.TaxOnAboveMargin) / 100);
Obj.TaxOnCash = LedgerDetail.TaxOnAboveMargin;
}
Obj.Date = ord.Create_Date;
// Obj.Amount = Amount;
BalanceStatement TBalance = BalanceStatement.GetAllForBalanceCalculation(OrgId).Last();
Obj.Balance = TBalance.Balance - Obj.CRAmount;
Obj.OrgId = OrgId;
Obj.OrderId = ord.OID;
Obj.Narration = "Commission of Order No." + ord.OID;
Obj.SaveCRValue();
}
else if (ord.PaymentStatus == 3)
{
Onlinepayment = PaytmResn.GetAll();
PaytmResn paytmTxn = Onlinepayment.Find(x => x.OID == ord.OID);
totalAmt += ord.DeliveryCharge;
totalAmt += Convert.ToDouble(paytmTxn.PaidAmount);
if (Onlinepayment.Count > 0)
{
Ledger LedgerDetails = Ledger.GetAllList().Where(x => x.DebtorType == 1 &&
x.OrgId == OrgId).FirstOrDefault();
bObj.Date = ord.Create_Date;
bObj.Amount = totalAmt;
bObj.OrgId = LedgerDetails.OrgId;
bObj.OrderId = orderitemlist[0].OID;
BalanceStatement TotalBalance = BalanceStatement.GetAllForBalanceCalculation(OrgId).Last();
bObj.Balance = TotalBalance.Balance + totalAmt;
bObj.Narration = "Online Payment of Order No." + orderitemlist[0].OID;
bObj.isCash = false;
bObj.SaveCRValue();
//===============================================================================
BalanceStatement Obj = new BalanceStatement();
HG_Orders od = new HG_Orders().GetOne(bObj.OrderId);
Ledger LedgerDetail = Ledger.GetAllList().Where(x => x.DebtorType == 1 &&
x.OrgId == OrgId).FirstOrDefault();
if (od.PaymentStatus == 3)
{
double amt = (bObj.Amount * LedgerDetails.MarginOnline) / 100;
Obj.CRAmount = (amt) + ((amt * LedgerDetails.TaxOnAboveMarginOnline) / 100);
Obj.TaxOnOnline = LedgerDetails.TaxOnAboveMarginOnline;
if (ord.PaymentStatus == 3 && ord.Status == "4")
{
double RefundAmt = bObj.Amount - totalAmt;
double GetRefundAmt = (RefundAmt * 2) / 100;
double GetRefundAmtwithTax = GetRefundAmt + ((GetRefundAmt * LedgerDetails.TaxOnAboveMarginOnline) / 100);
Obj.CRAmount = Obj.CRAmount + GetRefundAmtwithTax;
}
}
Obj.Date = bObj.Date;
// Obj.Amount = Amount;
BalanceStatement TBalance = BalanceStatement.GetAllForBalanceCalculation(OrgId).Last();
Obj.Balance = TBalance.Balance - Obj.CRAmount;
Obj.OrgId = OrgId;
Obj.OrderId = bObj.OrderId;
Obj.Narration = "Commission of Order No." + bObj.OrderId;
Obj.SaveCRValue();
}
}
}
return(Json(new { data = bObj }, JsonRequestBehavior.AllowGet));
}
public ActionResult GenerateAllPaymentReceipt()
{
List <long> OrderIds = PaytmResn.GetAll().Select(s => s.OID).Distinct().ToList();
List <PaytmResn> Onlinepayment = PaytmResn.GetAll().Where(w => OrderIds.Contains(w.OID)).Distinct().ToList();
int LastEntryNo = 0;
double LastBalance = 0.00;
int ENo = 0;
Receipt ReceiptEntry = new Receipt();
ReceiptEntry.Date = Onlinepayment[0].TxtDate.AddHours(-24);
ReceiptEntry.ReceiptType = "Rece";
ReceiptEntry.Amount = 0.00;
ReceiptEntry.Particular = "Opening Balance";
ReceiptEntry.Save();
foreach (var OP in Onlinepayment)
{
ReceiptEntry = new Receipt();
ReceiptEntry.Date = OP.TxtDate;
ReceiptEntry.ReceiptType = "Rece";
ReceiptEntry.Amount = Convert.ToDouble(OP.PaidAmount);
ReceiptEntry.Particular = "Online Payment of Order No." + OP.OID;
ENo = ENo + 1;
ReceiptEntry.EntryNo = ENo;
HG_Orders ord = new HG_Orders().GetOne(OP.OID);
ReceiptEntry.OrgId = ord.OrgId;
string Customer = "Customer";
string Paytm = "Paytm";
string Bank = "BANK";
string CurrentLiabilities = "Current Liabilities";
Ledger CutomerLedger = Ledger.GetAllList().Where(x => x.Name.ToLower() == Customer.ToLower()).FirstOrDefault();
Ledger Paytmledger = Ledger.GetAllList().Where(x => x.Name.ToLower() == Paytm.ToLower()).FirstOrDefault();
ReceiptEntry.CRLedgerId = CutomerLedger.ID;
ReceiptEntry.DRLedgerId = Paytmledger.ID;
Group BankGroup = Group.GetAll().Where(x => x.Name.ToLower() == Bank.ToLower()).FirstOrDefault();
Group CurrentLiabilitiesGroup = Group.GetAll().Where(x => x.Name.ToLower() == CurrentLiabilities.ToLower()).FirstOrDefault();
ReceiptEntry.CRGroupId = CurrentLiabilitiesGroup.ID;
ReceiptEntry.DRGroupId = BankGroup.ID;
try
{
LastBalance = Receipt.GetAllList(0, 0).Select(s => s.Balance).Last();
}
catch (Exception ex)
{
ex.ToString();
}
if (LastBalance > 0)
{
ReceiptEntry.Balance = LastBalance + ReceiptEntry.Amount;
}
else
{
ReceiptEntry.Balance = ReceiptEntry.Amount;
}
ReceiptEntry.Save();
}
return(Json(new { data = ReceiptEntry }, JsonRequestBehavior.AllowGet));
}
public static void AddToWallet(HG_Orders ObjOrder, int AppType = 0)
{
if (ObjOrder.Status != "3")
{
return;
}
if (AppType == 1)
{
}
else if (ObjOrder.Status == "3")
{
vw_HG_UsersDetails ObjUser = new vw_HG_UsersDetails().GetSingleByUserId((int)ObjOrder.CID);
if (ObjUser.UserType != "CUST")
{
return;
}
}
Cashback cashbk = Cashback.GetAppliedCashBk(ObjOrder.OrgId, ObjOrder.Table_or_SheatId, 1);
if (cashbk != null)
{
double cashBkAmt = 0.00;
if (cashbk.Percentage > 0 && cashbk.RaiseDynamic)
{
double OrdAmt = HG_Orders.OrderAmt(ObjOrder.OID, ObjOrder.DeliveryCharge);
var AggStudy = GetOrder.GetTotalAmt(ObjOrder.OrgId);
double DynamicValue = AggStudy + (AggStudy - cashbk.BilAmt) * (cashbk.Percentage * 2 / 100);
if (DynamicValue > cashbk.BilAmt && OrdAmt > DynamicValue)
{
cashBkAmt = OrdAmt * cashbk.Percentage / 100;
}
else if (OrdAmt > cashbk.BilAmt)
{
cashBkAmt = OrdAmt * cashbk.Percentage / 100;
}
}
else if (cashbk.Percentage > 0 && cashbk.RaiseDynamic == false)
{
double OrdAmt = HG_Orders.OrderAmt(ObjOrder.OID, ObjOrder.DeliveryCharge);
// cashBkAmt = OrdAmt * cashbk.Percentage / 100;
if (OrdAmt > cashbk.BilAmt && cashbk.MaxCBLimit == 0)//unlimited;
{
cashBkAmt = OrdAmt * cashbk.Percentage / 100;
}
else if (OrdAmt > cashbk.BilAmt && cashbk.MaxCBLimit == 1)// limited
{
cashBkAmt = OrdAmt * cashbk.Percentage / 100;
if (cashBkAmt > cashbk.MaxAmt)
{
cashBkAmt = cashbk.MaxAmt;
}
}
}
if (cashBkAmt > 0)
{
Wallet wallet = new Wallet();
wallet.AmtActiveOn = DateTime.Now.AddDays(1);
wallet.CID = (int)ObjOrder.CID;
wallet.OID = ObjOrder.OID;
wallet.OrgId = ObjOrder.OrgId;
wallet.DeductedAmt = 0;
wallet.CashBkAmt = cashBkAmt;
wallet.CashBkId = cashbk.CashBkId;
wallet.Save();
string[] topics = { ObjOrder.CID.ToString() };
string Title = "foodDo";
string Msg = "You Got " + cashBkAmt.ToString("0.00") + " Rs/- Cashback ";
PushNotification.SendNotification(topics, Msg, Title, OID: ObjOrder.OID, UserRating: 400);//user-Rating 400 for cashbk notification
}
}
}
public ActionResult GetDetails(List <HG_OrderItem> CompletedItems)
{
JournalEntry jObj = new JournalEntry();
List <JournalEntry> jObjList = new List <JournalEntry>();
List <HG_Orders> OrdersDetails = new List <HG_Orders>();
List <HG_OrganizationDetails> OrgList = new List <HG_OrganizationDetails>();
double totalAmount = 0.00;
for (int i = 0; i < CompletedItems.Count; i++)
{
jObj = new JournalEntry();
totalAmount += CompletedItems[i].Count * CompletedItems[i].Price;
if (CompletedItems[i].TaxInItm == 5)
{
Ledger LedgerDetails = Ledger.GetAllList().Where(x => x.ParentGroup == 5 && x.Name == "GST Local Sale 5%").FirstOrDefault();
jObj.CRLedgerId = LedgerDetails.ID;
jObj.JEDAmount = CompletedItems[i].CostPrice;
//HG_OrganizationDetails org = OrgList.FindAll(x => x.OrgID == CompletedItems[i].OrgId).FirstOrDefault();
//if(org.State=="17")
//{
//}
}
if (CompletedItems[i].TaxInItm == 12)
{
Ledger LedgerDetails = Ledger.GetAllList().Where(x => x.ParentGroup == 5 && x.Name == "GST Local Sale 12%").FirstOrDefault();
jObj.CRLedgerId = LedgerDetails.ID;
jObj.JEDAmount = CompletedItems[i].CostPrice;
}
if (CompletedItems[i].TaxInItm == 18)
{
Ledger LedgerDetails = Ledger.GetAllList().Where(x => x.ParentGroup == 5 && x.Name == "GST Local Sale 18%").FirstOrDefault();
jObj.CRLedgerId = LedgerDetails.ID;
jObj.JEDAmount = CompletedItems[i].CostPrice;
}
if (CompletedItems[i].TaxInItm == 28)
{
Ledger LedgerDetails = Ledger.GetAllList().Where(x => x.ParentGroup == 5 && x.Name == "GST Local Sale 28%").FirstOrDefault();
jObj.CRLedgerId = LedgerDetails.ID;
jObj.JEDAmount = CompletedItems[i].CostPrice;
}
jObjList.Add(jObj);
}
jObj.Date = DateTime.Now;
jObj.Amount = totalAmount;
jObj.GroupId = 5;
HG_Orders ord = new HG_Orders().GetOne(CompletedItems[0].OID);
if (ord.Status == "1")
{
jObj.Narration = "Payment of Order No." + CompletedItems[0].OID;
}
else
{
jObj.Narration = "Online Payment of Order No." + CompletedItems[0].OID;
}
jObj.Save(jObjList);
return(Json(new { data = jObj }, JsonRequestBehavior.AllowGet));
}
//=========FEEDBACK API===========
public JObject FeedBack(Int64 OID, int CID)
{
HG_Orders hG_Orders = new HG_Orders().GetOne(OID);
HG_Tables_or_Sheat Seating = new HG_Tables_or_Sheat().GetOne(hG_Orders.Table_or_SheatId);
JObject respose = new JObject();
if (Seating.FDBKId > 0)// feedback applied in seating
{
FeedbkForm feedbkForm = FeedbkForm.GetOne(Seating.FDBKId);
List <FeedBackQue> feedBackQues = FeedBackQue.GetAll(feedbkForm.Id);
feedBackQues = feedBackQues.FindAll(x => x.Status);
feedBackQues = feedBackQues.OrderBy(x => x.OrderNo).ToList();
respose.Add("Status", 200);
JArray jArray = new JArray();
foreach (var question in feedBackQues)
{
JObject jObject = new JObject();
jObject.Add("QID", question.ID);
jObject.Add("Title", question.Title);
jObject.Add("QuestionType", question.QuestionType);
jObject.Add("FeedBkFormID", question.FeedBkFormID);
if (question.Title.Contains("ITEM FEEDBACK") && (question.QuestionType == 0 || question.QuestionType == 3))
{
jObject["Title"] = "ITEM FEEDBACK";
List <HG_OrderItem> hG_OrderItems = new HG_OrderItem().GetAll(OID);
hG_OrderItems = hG_OrderItems.FindAll(x => x.Status == 3);
hG_OrderItems = hG_OrderItems.FindAll(x => x.OrdById == CID);
JArray itemfeedbks = new JArray();
for (int i = 0; i < hG_OrderItems.Count; i++)
{
HG_Items Objfood = new HG_Items().GetOne(hG_OrderItems[i].FID);
JObject ItemJobj = new JObject();
ItemJobj.Add("ItmId", hG_OrderItems[i].FID);//FID is ItemId
ItemJobj.Add("ItmName", Objfood.Items);
itemfeedbks.Add(ItemJobj);
}
jObject.Add("Items", itemfeedbks);
}
if (question.QuestionType == 1)
{
List <FeedbkObj> objectivesList = FeedbkObj.GetAll(question.ID);
FeedbkObj firstt = objectivesList.FirstOrDefault();
jObject.Add("ObjectiveType", firstt.ObjectiveType);
jObject.Add("Objectives", JArray.FromObject(objectivesList));
}
jArray.Add(jObject);
}
//=====add customer review comment in last at feedback
JObject jObject2 = new JObject();
jObject2.Add("QID", 0);
jObject2.Add("Title", "");
jObject2.Add("QuestionType", 5);
jObject2.Add("FeedBkFormID", 0);
jArray.Add(jObject2);
respose.Add("Questions", jArray);
}
else
{
respose.Add("Status", 400);
}
return(respose);
}
