public ActionResult ShopRiceStock(FormCollection form, RawRice worth, Pricing pricing)
{
string idd = Convert.ToString(Session["UserId"]);
var RiceName = Convert.ToString(form["RiceName"]);
worth.Date = DateTime.Now;
worth.Id = idd;
worth.Status = true;
db.RarRices.Add(worth);
db.SaveChanges();
var RawRice_id = db.RarRices.Max(m => m.RawRice_id);
pricing.item_id = RawRice_id;
pricing.item_Type = "RawRice";
pricing.Pricing_Date = DateTime.Now;
pricing.Pricing_ModifiedDate = DateTime.Now;
pricing.Status = true;
db.Pricing.Add(pricing);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult RiceStockEdit(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RawRice RawRice = db.RarRices.Find(id);
if (RawRice == null)
{
return(HttpNotFound());
}
ViewBag.Rice_category_Id = new SelectList(db.Rice_Categories.Where(m => m.Status == true).ToList(), "Rice_category_Id", "Rice_Category_Name");
return(View(RawRice));
}
public ActionResult RiceStockEdit(FormCollection form, RawRice worth, Pricing pricing)
{
string idd = Convert.ToString(Session["UserId"]);
var RiceName = Convert.ToString(form["RiceName"]);
RawRice rice = db.RarRices.Find(worth.RawRice_id);
rice.Item_Name = worth.Item_Name;
rice.Item_Code = worth.Item_Code;
rice.Packing_Id = worth.Packing_Id;
rice.Bags_qty = worth.Bags_qty;
rice.Date = DateTime.Now;
rice.Id = idd;
rice.Status = true;
db.Entry(rice).State = EntityState.Modified;
db.SaveChanges();
var price = db.Pricing.Where(p => p.item_id == worth.RawRice_id && p.item_Type == "RawRice").SingleOrDefault();
price.item_id = worth.RawRice_id;
price.item_Type = "RawRice";
price.PerBagPrice = pricing.PerBagPrice;
pricing.PerBagMarketPrice = pricing.PerBagMarketPrice;
pricing.Pricing_Total = pricing.Pricing_Total;
price.Pricing_Date = DateTime.Now;
price.Pricing_ModifiedDate = DateTime.Now;
price.Status = true;
db.Entry(price).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void PayBrokerCommision(int?RawRiceID)
{
if (RawRiceID != null)
{
RawRice rawRice = db.RarRices.Find(RawRiceID);
if (rawRice != null && !rawRice.Pay_CommissionPercentage && rawRice.BrokerCommissionPercentage > 0)
{
Transaction BrokerTransaction = new Transaction();
BrokerTransaction.isByCash = true;
BrokerTransaction.BankAccountNo = "";
foreach (var item in db.Opening_ClosingDays)
{
if (item.Date.ToShortDateString() == DateTime.Now.ToShortDateString() && !item.isClosed)
{
BrokerTransaction.Opening_ClosingDays_id = item.Opening_ClosingDays_id;
break;
}
}
BrokerTransaction.Transaction_DateTime = DateTime.Now;
BrokerTransaction.Transaction_Description = "Pay Commission to Broker " + db.Brokers.Find(db.RarRices.Find(rawRice.RawRice_id).Broker_Id).Broker_Name + " for RawRice " + rawRice.Item_Name + " Qty: " + rawRice.Bags_qty + " Packing type: " + db.Packings.Find(rawRice.Packing_Id).Packing_Type + "Kgs from Party " + db.Parties.Find(rawRice.Party_Id).Party_Name;
BrokerTransaction.Transaction_item_id = rawRice.RawRice_id;
BrokerTransaction.Transaction_item_type = BrokerTransactions.PaycommissionToBroker;
BrokerTransaction.Debit = rawRice.BrokerCommissionAmount;
BrokerTransaction.Credit = 0;
BrokerTransaction.status = true;
db.Transaction.Add(BrokerTransaction);
db.SaveChanges();
rawRice.Pay_CommissionPercentage = true;
db.Entry(rawRice).State = EntityState.Modified;
db.SaveChanges();
}
}
}
public JsonResult GetProductData(string RawRice_id)
{
if (RawRice_id == "null")
{
return(Json(new { success = false }));
}
int riceid = Convert.ToInt32(RawRice_id);
RawRice product = db.RarRices.Find(riceid);
Packing packing = db.Packings.Find(product.Packing_Id);
var rate = db.Pricing.Where(m => m.item_id == riceid && m.item_Type == "RawRice").SingleOrDefault();
var remaining = product.Bags_qty;
if (product.Bags_Sold_qty > 0)
{
remaining = product.Bags_qty - product.Bags_Sold_qty;
}
if (product != null)
{
return(Json(new { success = true, Bags_qty = remaining, Packing_Id = packing.Packing_Type, PerBagPrice = rate.PerBagPrice, PerBagMarketPrice = rate.PerBagMarketPrice }));
}
return(Json(new { success = false }));
}
public ActionResult Edit(RawRice rawRice, List <RawRiceExpense> RawRiceExpense, Pricing pricing, List <RawRice> RawRice_Remaining, List <decimal> Previous_Remainings, List <int> RawRice_Remaining_checkbox, List <int> Expense_id_delete, FormCollection form)
{
var Pay_CommissionPercentage = form["Pay_CommissionPercentage"];
decimal payedamount = Convert.ToDecimal(form["Payed_Amount"]);
if (RawRice_Remaining != null && Previous_Remainings != null && RawRice_Remaining_checkbox != null)
{
for (int i = 0; i < RawRice_Remaining.Count; i++)
{
try
{
if (RawRice_Remaining_checkbox.Where(m => m.Equals(RawRice_Remaining[i].RawRice_id)).Count() > 0)
{
Transaction rem_trans = new Transaction();
rem_trans.Transaction_item_id = RawRice_Remaining[i].RawRice_id;
rem_trans.Transaction_item_type = "RawRice Remaining";
rem_trans.Transaction_Description = "Pay Remaining Amount of " + RawRice_Remaining[i].Item_Name + " from Party " + db.Parties.Find(rawRice.Party_Id).Party_Name;
rem_trans.Transaction_DateTime = DateTime.Now;
if (form["isBankAccount"] != null)
{
rem_trans.BankAccountNo = form["BankAccountNo"];
}
else if (form["isCheckbook"] != null)
{
rem_trans.checkno = Convert.ToInt32(form["CheckNo"]);
rem_trans.BankAccountNo = form["BankAccountNo"];
}
else if (form["isCash"] != null)
{
rem_trans.isByCash = true;
rem_trans.BankAccountNo = "";
}
foreach (var item in db.Opening_ClosingDays)
{
if (item.Date.ToShortDateString() == DateTime.Now.ToShortDateString() && !item.isClosed)
{
rem_trans.Opening_ClosingDays_id = item.Opening_ClosingDays_id;
break;
}
}
rem_trans.Debit = Previous_Remainings[i];
rem_trans.Credit = 0;
rem_trans.status = true;
db.Transaction.Add(rem_trans);
payedamount = payedamount - Previous_Remainings[i];
db.SaveChanges();
}
}
catch (Exception)
{
}
}
}
string idd = Convert.ToString(Session["UserId"]);
rawRice.Id = idd;
rawRice.Status = true;
rawRice.Date = DateTime.Now;
rawRice.Bags_Sold_qty = 0;
rawRice.Pay_CommissionPercentage = (Pay_CommissionPercentage == "on") ? true : false;
db.Entry(rawRice).State = EntityState.Modified;
db.SaveChanges();
// var rawrice_id = db.RarRices.Max(m => m.RawRice_id);
if (RawRiceExpense != null)
{
foreach (var item in RawRiceExpense)
{
if (item.RawRiceExpense_Name != null)
{
item.RawRice_id = rawRice.RawRice_id;
if (item.RawRiceExpense_id == 0)
{
db.RawRiceExpense.Add(item);
}
else
{
db.Entry(item).State = EntityState.Modified;
}
}
}
}
if (Expense_id_delete != null)
{
foreach (var item in Expense_id_delete)
{
RawRiceExpense expense = db.RawRiceExpense.Find(item);
db.RawRiceExpense.Remove(expense);
}
db.SaveChanges();
}
pricing.PerBagMarketPrice = pricing.PerBagPrice;
pricing.item_id = rawRice.RawRice_id;
pricing.item_Type = "RawRice";
pricing.Pricing_Date = DateTime.Now;
pricing.Pricing_ModifiedDate = DateTime.Now;
pricing.Status = true;
db.Entry(pricing).State = EntityState.Modified;
db.SaveChanges();
foreach (var item in db.Transaction.Where(m => m.Transaction_item_id == rawRice.RawRice_id && (m.Transaction_item_type == "RawRice" || m.Transaction_item_type == BrokerTransactions.PaycommissionToBroker) && m.status))
{
db.Transaction.Remove(item);
}
db.SaveChanges();
if (rawRice.Pay_CommissionPercentage)
{
Transaction BrokerTransaction = new Transaction();
if (form["isBankAccount"] != null)
{
BrokerTransaction.BankAccountNo = form["BankAccountNo"];
}
else if (form["isCheckbook"] != null)
{
BrokerTransaction.checkno = Convert.ToInt32(form["CheckNo"]);
BrokerTransaction.BankAccountNo = form["BankAccountNo"];
}
else if (form["isCash"] != null)
{
BrokerTransaction.isByCash = true;
BrokerTransaction.BankAccountNo = "";
}
foreach (var item in db.Opening_ClosingDays)
{
if (item.Date.ToShortDateString() == DateTime.Now.ToShortDateString() && !item.isClosed)
{
BrokerTransaction.Opening_ClosingDays_id = item.Opening_ClosingDays_id;
break;
}
}
BrokerTransaction.Transaction_DateTime = DateTime.Now;
BrokerTransaction.Transaction_Description = "Pay Commission to Broker " + db.Brokers.Find(db.RarRices.Find(rawRice.RawRice_id).Broker_Id).Broker_Name + " for RawRice " + rawRice.Item_Name + " Qty: " + rawRice.Bags_qty + " Packing type: " + db.Packings.Find(rawRice.Packing_Id).Packing_Type + "Kgs from Party " + db.Parties.Find(rawRice.Party_Id).Party_Name;
BrokerTransaction.Transaction_item_id = rawRice.RawRice_id;
BrokerTransaction.Transaction_item_type = BrokerTransactions.PaycommissionToBroker;
BrokerTransaction.Debit = payedamount;
BrokerTransaction.Credit = 0;
BrokerTransaction.status = true;
db.Transaction.Add(BrokerTransaction);
db.SaveChanges();
}
Transaction trans = new Transaction();
if (form["isBankAccount"] != null)
{
trans.BankAccountNo = db.Parties.Find(rawRice.Party_Id).Party_ACcountNo;
}
else if (form["isCheckbook"] != null)
{
trans.checkno = Convert.ToInt32(form["CheckNo"]);
trans.BankAccountNo = db.Parties.Find(rawRice.Party_Id).Party_ACcountNo;
}
else if (form["isCash"] != null)
{
trans.isByCash = true;
trans.BankAccountNo = "";
}
foreach (var item in db.Opening_ClosingDays)
{
if (item.Date.ToShortDateString() == DateTime.Now.ToShortDateString() && !item.isClosed)
{
trans.Opening_ClosingDays_id = item.Opening_ClosingDays_id;
break;
}
}
trans.Transaction_DateTime = DateTime.Now;
trans.Transaction_Description = "Purchase " + rawRice.Item_Name + " Qty: " + rawRice.Bags_qty + " Packing type: " + db.Packings.Find(rawRice.Packing_Id).Packing_Type + "Kgs from Party " + db.Parties.Find(rawRice.Party_Id).Party_Name;
trans.Transaction_item_id = rawRice.RawRice_id;
trans.Transaction_item_type = "RawRice";
trans.Debit = payedamount;
trans.Credit = 0;
trans.status = true;
db.Transaction.Add(trans);
db.SaveChanges();
return(RedirectToAction("Index"));
}
