public ActionResult Index(Primission pr)
{
if (ModelState.IsValid)
{
return(View(db.Primission.Where(x => x.PrimNumber == pr.PrimNumber && x.Date == pr.Date).ToList()));
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(Primission pr)
{
if (ModelState.IsValid)
{
foreach (var i in db.EditReq)
{
db.EditReq.Remove(i);
// db.SaveChanges();
}
EditRequest e = new EditRequest();
e.PrimNumber = Convert.ToInt32(pr.PrimNumber);
e.Date = pr.Date;
db.EditReq.Add(e);
db.SaveChanges();
return(RedirectToAction("EditReq"));
}
return(View());
}
public ActionResult Create(RequestForm rf)
{
int ReqNum = 0;
DateTime date = DateTime.Today;
foreach (var i in db.Primission)
{
if (i.Date == date && i.PrimNumber > ReqNum)
{
ReqNum = i.PrimNumber;
}
}
ReqNum++;
for (int i = 0; i < rf.ProductID.Count(); i++)
{
if (rf.ProductID[i].Length == 0)
{
continue;
}
Primission pr = new Primission();
ReqN = ReqNum;
ReqDate = date;
pr.PrimNumber = ReqNum;
pr.Date = date;
pr.ClientID = rf.ClientID;
pr.CleintName = rf.CleintName;
pr.ProductID = rf.ProductID[i];
pr.ProductName = rf.ProductName[i];
pr.Outgoing = rf.Outgoing[i];
db.Primission.Add(pr);
db.SaveChanges();
}
return(RedirectToAction("NewBill"));
}
public ActionResult EditReq(RequestForm rf)
{
int ReqNum = 0;
int JournalNum = 0;
DateTime date = new DateTime();
foreach (var i in db.EditReq)
{
ReqNum = i.PrimNumber;
date = Convert.ToDateTime(i.Date);
break;
}
foreach (var i in db.Primission)
{
if (i.PrimNumber == ReqNum)
{
db.Primission.Remove(i);
// db.SaveChanges();
}
}
foreach (var i in db.Bill)
{
if (i.BillNumber == ReqNum)
{
JournalNum = Convert.ToInt32(i.DailyID);
db.Bill.Remove(i);
// db.SaveChanges();
}
}
foreach (var i in db.Data)
{
if (i.DailyNum == JournalNum)
{
db.Data.Remove(i);
// db.SaveChanges();
}
}
db.SaveChanges();
for (int i = 0; i < rf.ProductID.Count(); i++)
{
if (rf.ProductID[i].Length == 0)
{
continue;
}
Primission pr = new Primission();
ReqN = ReqNum;
ReqDate = date;
pr.PrimNumber = ReqNum;
pr.Date = date;
pr.ClientID = rf.ClientID;
pr.CleintName = rf.CleintName;
pr.ProductID = rf.ProductID[i];
pr.ProductName = rf.ProductName[i];
pr.Outgoing = rf.Outgoing[i];
db.Primission.Add(pr);
db.SaveChanges();
}
return(RedirectToAction("NewBill"));
}
