public ActionResult SaveTransactions(string currCode, string userId, string transactionType, string Rate, string ForeignAmount, string LocalAmount, string AvgCost, string AvgStock, string print) { LinqMasterDataContext mastContext = new LinqMasterDataContext(); System.Data.Linq.ISingleResult <SaveTransactionResult> ret = mastContext.SaveTransaction(userId, currCode, transactionType, Convert.ToDecimal(Rate), Convert.ToDecimal(ForeignAmount), Convert.ToDecimal(LocalAmount), Convert.ToDecimal(AvgCost), Convert.ToDouble(AvgStock)); decimal TranNo = 0; TranNo = ret.First <SaveTransactionResult>().TranNo; //if (ret != null && ret.Any()) //{ // foreach (var item in ret) // { // TranNo = item.TranNo; // } //} var compDetails = mastContext.tblCompanies.FirstOrDefault(); var AdditionaValues = new { currCode = currCode, transactionType = transactionType, ForeignAmount = ForeignAmount, LocalAmount = LocalAmount, Rate = Rate, TranNo = TranNo }; if (print == "true") { PrintReceipt(TranNo, currCode, userId, transactionType, Rate, ForeignAmount, LocalAmount, AvgCost); } return(Json(new { compDetails, AdditionaValues }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetExchangeRates(string currencyCode) { LinqMasterDataContext mastContext = new LinqMasterDataContext(); var convertionList = mastContext.GetLocationCurrency("L1", currencyCode).First(); return(Json(convertionList, JsonRequestBehavior.AllowGet));; }
public ActionResult GetExchangeDate(string hi) { LinqMasterDataContext a = new LinqMasterDataContext(); var varCurr = (from curr in a.TblCurrencies select new CurrencyCodes { Code = curr.CurrencyCode, Description = curr.CurrencyName, Varience = Convert.ToDecimal(curr.Varience) }).ToList <CurrencyCodes>(); var varUsers = (from usrs in a.TblUserMasters select new UserMaster { UserId = usrs.UserId, Description = usrs.Description, Password = usrs.Password }).ToList <UserMaster>(); return(Json(new { varCurr, varUsers }, JsonRequestBehavior.AllowGet)); }
public void PrintReceipt(decimal TranNo, string currCode, string userId, string transactionType, string Rate, string ForeignAmount, string LocalAmount, string AvgCost) { LinqMasterDataContext mastContext = new LinqMasterDataContext(); PrintTransaction rcpt = new PrintTransaction(); var compDetails = mastContext.tblCompanies.FirstOrDefault(); //var AdditionaValues = new { currCode = currCode, transactionType = transactionType, ForeignAmount = ForeignAmount, LocalAmount = LocalAmount, Rate = Rate }; rcpt.Description = compDetails.Description; rcpt.Address1 = compDetails.Address1; rcpt.Address2 = compDetails.Address2; rcpt.Address3 = compDetails.Address3; rcpt.Phone = compDetails.Phone; rcpt.TranNo = TranNo.ToString(); rcpt.CurCode = currCode; rcpt.TranType = transactionType; rcpt.TaxRef = compDetails.TaxRef; rcpt.ForeignAmt = ForeignAmount; rcpt.LocalAmt = LocalAmount; rcpt.Rate = Rate; rcpt.print(); }