// GET: /Issue/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_Issue tbl_issue = db.tbl_Issue.Find(id);
if (tbl_issue == null)
{
return(HttpNotFound());
}
return(View(tbl_issue));
}
public JsonResult DeleteConfirmed(int id)
{
string success = string.Empty;
// return Json(success, JsonRequestBehavior.AllowGet);
tbl_Issue tbl_issue = db.tbl_Issue.Find(id);
db.tbl_Issue.Remove(tbl_issue);
int result = db.SaveChanges();
if (result > 0)
{
success = "Data delete successfully";
}
// return Json(success, JsonRequestBehavior.AllowGet);
return(Json(new { result = success }));
}
public long SaveUpdateServiceIssue(ServiceIssueModel model)
{
ShomaRMEntities db = new ShomaRMEntities();
var userNameExists = db.tbl_Issue.Where(p => p.IssueID != model.IssueID && p.Issue == model.Issue).FirstOrDefault();
if (userNameExists == null)
{
if (model.IssueID == 0)
{
var IssueData = new tbl_Issue()
{
CausingIssueID = model.CausingIssueID,
ServiceIssueID = model.ServiceIssueID,
Issue = model.Issue,
};
db.tbl_Issue.Add(IssueData);
db.SaveChanges();
model.IssueID = IssueData.IssueID;
}
else
{
var SIssueData = db.tbl_Issue.Where(p => p.IssueID == model.IssueID).FirstOrDefault();
if (SIssueData != null)
{
SIssueData.CausingIssueID = model.CausingIssueID;
SIssueData.ServiceIssueID = model.ServiceIssueID;
SIssueData.Issue = model.Issue;
db.SaveChanges();
}
else
{
throw new Exception(model.Issue + " not exists in the system.");
}
}
return(model.IssueID);
}
else
{
throw new Exception(model.Issue + " already exists in the system.");
}
}
public ActionResult Edit([Bind(Include = "id,GRN,demandNo,itemId,brandId,colorId,demandQty,receiveQty,issueQty,unitId,priceId,departmentId,dateTime,calanNo")] tbl_Issue tbl_issue)
{
if (ModelState.IsValid)
{
db.Entry(tbl_issue).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.brandId = new SelectList(db.tbl_Brand, "id", "name", tbl_issue.brandId);
ViewBag.colorId = new SelectList(db.tbl_Color, "id", "name", tbl_issue.colorId);
ViewBag.demandNo = new SelectList(db.tbl_Demand, "id", "demandNo", tbl_issue.demandNo);
ViewBag.demandQty = new SelectList(db.tbl_Demand, "id", "demandNo", tbl_issue.demandQty);
ViewBag.departmentId = new SelectList(db.tbl_Department, "id", "name", tbl_issue.departmentId);
ViewBag.itemId = new SelectList(db.tbl_ItemMaster, "id", "name", tbl_issue.itemId);
ViewBag.priceId = new SelectList(db.tbl_Price, "id", "id", tbl_issue.priceId);
ViewBag.GRN = new SelectList(db.tbl_Receive, "id", "receiveNo", tbl_issue.GRN);
ViewBag.receiveQty = new SelectList(db.tbl_Receive, "id", "receiveNo", tbl_issue.receiveQty);
ViewBag.unitId = new SelectList(db.tbl_Unit, "id", "name", tbl_issue.unitId);
return(View(tbl_issue));
}
// GET: /Issue/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_Issue tbl_issue = db.tbl_Issue.Find(id);
if (tbl_issue == null)
{
return(HttpNotFound());
}
ViewBag.brandId = new SelectList(db.tbl_Brand, "id", "name", tbl_issue.brandId);
ViewBag.colorId = new SelectList(db.tbl_Color, "id", "name", tbl_issue.colorId);
ViewBag.demandNo = new SelectList(db.tbl_Demand, "id", "demandNo", tbl_issue.demandNo);
ViewBag.demandQty = new SelectList(db.tbl_Demand, "id", "demandQty", tbl_issue.demandQty);
ViewBag.departmentId = new SelectList(db.tbl_Department, "id", "name", tbl_issue.departmentId);
ViewBag.itemId = new SelectList(db.tbl_ItemMaster, "id", "name", tbl_issue.itemId);
ViewBag.priceId = new SelectList(db.tbl_Price, "id", "price", tbl_issue.priceId);
ViewBag.GRN = new SelectList(db.tbl_Receive, "id", "GRN", tbl_issue.GRN);
ViewBag.receiveQty = new SelectList(db.tbl_Receive, "id", "receiveQty", tbl_issue.receiveQty);
ViewBag.unitId = new SelectList(db.tbl_Unit, "id", "name", tbl_issue.unitId);
return(View(tbl_issue));
}
