public async Task <IHttpActionResult> PutRawRice_Sales_ch(int id, RawRice_Sales_ch rawRice_Sales_ch)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != rawRice_Sales_ch.rsc_id)
{
return(BadRequest());
}
db.Entry(rawRice_Sales_ch).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!RawRice_Sales_chExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IHttpActionResult> GetRawRice_Sales_ch(int id)
{
RawRice_Sales_ch rawRice_Sales_ch = await db.RawRice_Sales_ch.FindAsync(id);
if (rawRice_Sales_ch == null)
{
return(NotFound());
}
return(Ok(rawRice_Sales_ch));
}
public async Task <IHttpActionResult> PostRawRice_Sales_ch(RawRice_Sales_ch rawRice_Sales_ch)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.RawRice_Sales_ch.Add(rawRice_Sales_ch);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = rawRice_Sales_ch.rsc_id }, rawRice_Sales_ch));
}
public async Task <IHttpActionResult> DeleteRawRice_Sales_ch(int id)
{
RawRice_Sales_ch rawRice_Sales_ch = await db.RawRice_Sales_ch.FindAsync(id);
if (rawRice_Sales_ch == null)
{
return(NotFound());
}
db.RawRice_Sales_ch.Remove(rawRice_Sales_ch);
await db.SaveChangesAsync();
return(Ok(rawRice_Sales_ch));
}
public void Update_sales(FormCollection form)
{
var js = new JavaScriptSerializer();
decimal Recieved_Amount = Convert.ToDecimal(form["RecievedAmount"]);
try
{
List <int> remaining_rsp_id = js.Deserialize <List <int> >(form["remaining_rsp_id"]);
for (int i = 0; i < remaining_rsp_id.Count; i++)
{
var RawRice_Sales_pt = db.RawRice_Sales_pt.Find(remaining_rsp_id[i]);
decimal recieved = db.Transaction.Where(
m => m.status &&
m.Transaction_item_id == RawRice_Sales_pt.rsp_id &&
m.Transaction_item_type == SellingCategory.RawRice_Sales ||
m.Transaction_item_type == SellingCategory.RawRice_Sales_Remaining
).Sum(m => m.Credit);
var Remaining = RawRice_Sales_pt.rsp_Total_Amount - recieved;
Transaction trans = new Transaction();
if (form["isBankAccount"] == "true")
{
trans.BankAccountNo = form["BankAccountNo"];
}
else if (form["isCheckbook"] == "true")
{
trans.checkno = Convert.ToInt32(form["CheckNo"]);
trans.BankAccountNo = form["BankAccountNo"];
}
else if (form["isCash"] == "true")
{
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 = "Received Remaining from " + db.Parties.Find(RawRice_Sales_pt.Party_Id).Party_Name;
trans.Transaction_item_id = remaining_rsp_id[i];
trans.Transaction_item_type = SellingCategory.RawRice_Sales_Remaining;
trans.Debit = 0;
trans.Credit = Remaining;
trans.status = true;
db.Transaction.Add(trans);
db.SaveChanges();
Recieved_Amount -= Remaining;
}
}
catch (Exception ex)
{
}
RawRice_Sales_pt RawRiceSales_View = js.Deserialize <RawRice_Sales_pt>(form["rawRice_Sales_pt"]);
var RawRiceSales = db.RawRice_Sales_pt.Find(RawRiceSales_View.rsp_id);
if (RawRiceSales_View.Party.Party_Id > 0)
{
RawRiceSales.Party_Id = RawRiceSales_View.Party.Party_Id;
RawRiceSales.Party = db.Parties.Find(RawRiceSales.Party_Id);
}
else
{
var mParty = RawRiceSales_View.Party;
//string idd = Convert.ToString(Session["UserId"]);
string idd = User.Identity.GetUserId();
mParty.Id = idd;
mParty.Status = true;
db.Parties.Add(mParty);
db.SaveChanges();
RawRiceSales.Party_Id = db.Parties.Max(m => m.Party_Id);
RawRiceSales.Party = db.Parties.Find(RawRiceSales.Party_Id);
}
// RawRiceSales.Party_Id = RawRiceSales_View.Party_Id;
RawRiceSales.rsp_TotalWeight_KG = RawRiceSales_View.rsp_TotalWeight_KG;
RawRiceSales.rsp_TotalWeight_Mann = RawRiceSales_View.rsp_TotalWeight_Mann;
RawRiceSales.rsp_Total_Amount = RawRiceSales_View.rsp_Total_Amount;
RawRiceSales.rsp_Title = RawRiceSales_View.rsp_Title + " to Party " + db.Parties.Find(RawRiceSales.Party_Id).Party_Name;
RawRiceSales.rsp_status = true;
RawRiceSales.rsp_date = DateTime.Now;
db.Entry(RawRiceSales).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
int rsp_id = RawRiceSales.rsp_id;
var obj = js.DeserializeObject(form["RawRice_Sales_ch"].ToString());
List <RawRice_Sales_ch> RawRice_Sales_ch = js.Deserialize <RawRice_Sales_ch[]>(form["RawRice_Sales_ch"].ToString()).ToList();
foreach (var item in RawRice_Sales_ch)
{
var rsc = db.RawRice_Sales_ch.Find(item.rsc_id);
if (rsc == null)
{
rsc = new RawRice_Sales_ch();
}
rsc.RawRice_id = item.RawRice_id;
rsc.rsc_id = item.rsc_id;
rsc.rsc_price = item.rsc_price;
rsc.rsc_qty = item.rsc_qty;
rsc.rsc_status = item.rsc_status;
rsc.rsc_title = item.rsc_title;
rsc.rsc_Weight_kg = item.rsc_Weight_kg;
rsc.rsc_Weight_mann = item.rsc_Weight_mann;
rsc.rsp_id = rsp_id;
rsc.rsc_status = true;
if (rsc.rsc_id == 0)
{
db.RawRice_Sales_ch.Add(rsc);
db.SaveChanges();
var RawRice = db.RarRices.Find(rsc.RawRice_id);
RawRice.Bags_Sold_qty += rsc.rsc_qty;
db.Entry(RawRice).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
int rsc_qty = 0;
using (var newdb = new ApplicationDbContext())
{
rsc_qty = newdb.RawRice_Sales_ch.Where(m => m.rsc_id == item.rsc_id).Take(1).Single().rsc_qty;
}
var RawRice = db.RarRices.Find(rsc.RawRice_id);
RawRice.Bags_Sold_qty -= rsc_qty;
db.Entry(RawRice).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
db.Entry(rsc).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
RawRice = db.RarRices.Find(rsc.RawRice_id);
RawRice.Bags_Sold_qty += rsc.rsc_qty;
db.Entry(RawRice).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
List <RawRice_Sales_ch> Deleted_RawRice_Sales_ch = js.Deserialize <RawRice_Sales_ch[]>(form["Deleted_RawRice_Sales_ch"].ToString()).ToList();
foreach (var item in Deleted_RawRice_Sales_ch)
{
var RawRice = db.RarRices.Find(item.RawRice_id);
RawRice.Bags_Sold_qty -= item.rsc_qty;
db.Entry(RawRice).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
var rsc = db.RawRice_Sales_ch.Find(item.rsc_id);
rsc.rsc_status = false;
db.Entry(rsc).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
foreach (var item in db.Transaction.Where(
m => m.status &&
m.Transaction_item_id == RawRiceSales.rsp_id &&
m.Transaction_item_type == SellingCategory.RawRice_Sales
).ToList())
{
db.Transaction.Remove(item);
}
db.SaveChanges();
Transaction trans_this = new Transaction();
if (form["isBankAccount"] == "true")
{
trans_this.BankAccountNo = form["BankAccountNo"];
}
else if (form["isCheckbook"] == "true")
{
trans_this.checkno = Convert.ToInt32(form["CheckNo"]);
trans_this.BankAccountNo = form["BankAccountNo"];
}
else if (form["isCash"] == "true")
{
trans_this.isByCash = true;
trans_this.BankAccountNo = "";
}
foreach (var item in db.Opening_ClosingDays)
{
if (item.Date.ToShortDateString() == DateTime.Now.ToShortDateString() && !item.isClosed)
{
trans_this.Opening_ClosingDays_id = item.Opening_ClosingDays_id;
break;
}
}
trans_this.Transaction_DateTime = DateTime.Now;
trans_this.Transaction_Description = RawRiceSales.rsp_Title;
trans_this.Transaction_item_id = rsp_id;
trans_this.Transaction_item_type = SellingCategory.RawRice_Sales;
trans_this.Debit = 0;
trans_this.Credit = Recieved_Amount;
trans_this.status = true;
db.Transaction.Add(trans_this);
db.SaveChanges();
}
