public ActionResult Create(Goods_TypeModel good_typeModel) { if (Session["login_status"] != null) { int[] z = (int[])Session["function_id"]; if (z.Contains(2)) { Good good = new Good(); Goods_Tariff goods_tariff = new Goods_Tariff(); if (ModelState.IsValid) { var is_exist = (from g in db.Goods join gtf in db.Goods_Tariff on g.goods_id equals gtf.goods_id where g.goods_name == good_typeModel.goods_name select g).Count(); if (is_exist > 0) { TempData["errorMessage"] = "This Entry Already Exist"; } else { good.goods_type_id = good_typeModel.goods_type_id; good.goods_code = good_typeModel.goods_code; good.goods_name = good_typeModel.goods_name; good.status_id = 1; good.created_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd"); good.updated_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd"); db.Goods.Add(good); db.SaveChanges(); goods_tariff.goods_id = good.goods_id; goods_tariff.goods_tariff = good_typeModel.goods_tariff; goods_tariff.currency_id = good_typeModel.currency_id; goods_tariff.ispercentage = good_typeModel.ispercentage; goods_tariff.unit_of_measure_id = good_typeModel.unit_of_measure_id; goods_tariff.created_date = DateTime.Now; goods_tariff.end_date = Convert.ToDateTime("9999-12-31"); db.Goods_Tariff.Add(goods_tariff); db.SaveChanges(); db.Update_Levi_Entry(); db.Update_Levi(); TempData["errorMessage"] = "Goods Added Successfully"; } return RedirectToAction("Index"); } return RedirectToAction("Index"); } else { return RedirectToAction("../Home/Dashboard"); } } else { return RedirectToAction("../Home"); } }
public ActionResult Create(Goods_TypeModel good_typeModel) { Good good = new Good(); Goods_Tariff goods_tariff = new Goods_Tariff(); if (ModelState.IsValid) { var is_exist = (from g in db.Goods where g.goods_name == good_typeModel.goods_name select g).Count(); if (is_exist > 0) { TempData["errorMessage"] = "This Goods Already Exist"; } else { good.goods_type_id = good_typeModel.goods_type_id; good.goods_name = good_typeModel.goods_name; good.status_id = 1; good.created_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd"); good.updated_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd"); db.Goods.Add(good); db.SaveChanges(); goods_tariff.goods_id = good.goods_id; goods_tariff.goods_tariff = good_typeModel.goods_tariff; goods_tariff.ispercentage = good_typeModel.ispercentage; goods_tariff.unit_of_measure_id = good_typeModel.unit_of_measure_id; goods_tariff.created_date = DateTime.Now; goods_tariff.end_date = Convert.ToDateTime("9999-12-31"); db.Goods_Tariff.Add(goods_tariff); db.SaveChanges(); db.Update_Levi_Entry(); db.Update_Levi(); TempData["errorMessage"] = "Goods Added Successfully"; } return RedirectToAction("Index"); } return RedirectToAction("Index"); }
public ActionResult Edit(Goods_TypeModel good_typeModel) { if (Session["login_status"] != null) { int[] z = (int[])Session["function_id"]; if (z.Contains(2)) { var file_name = ""; int good_id = Convert.ToInt32(TempData["goods_id"]); Good good_new = db.Goods.Find(good_id); int goods_tariff_id = Convert.ToInt32(TempData["goods_tariff_id"]); Goods_Tariff goods_tariff = db.Goods_Tariff.Find(goods_tariff_id); Goods_Tariff goods_tariff_new = new Goods_Tariff(); if (ModelState.IsValid) { var is_exist = (from g in db.Goods join gtf in db.Goods_Tariff on g.goods_id equals gtf.goods_id where g.goods_name == good_typeModel.goods_name && g.goods_id != good_id select g).Count(); if (is_exist > 0) { TempData["errorMessage"] = "This Entry Already Exist"; } else { if (good_typeModel.upload_document != null) { //following code is used for document adding and storing in App_Data folder HttpPostedFileBase file = Request.Files.Get("upload_document"); if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName)) { file_name = file.FileName; string fileContentType = file.ContentType; byte[] fileBytes = new byte[file.ContentLength]; file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength)); var FileLocation = Path.Combine(Server.MapPath("~/App_Data"), file_name); file.SaveAs(FileLocation); } } good_new.goods_type_id = good_typeModel.goods_type_id; good_new.goods_code = good_typeModel.goods_code; good_new.goods_name = good_typeModel.goods_name; good_new.status_id = good_typeModel.status_id; good_new.created_date = TempData["created_date"].ToString(); good_new.updated_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd"); db.Entry(good_new).State = EntityState.Modified; db.SaveChanges(); goods_tariff.end_date = DateTime.Now; db.Entry(goods_tariff).State = EntityState.Modified; db.SaveChanges(); goods_tariff_new.goods_id = good_new.goods_id; goods_tariff_new.goods_tariff = good_typeModel.goods_tariff; goods_tariff_new.currency_id = good_typeModel.currency_id; goods_tariff_new.ispercentage = good_typeModel.ispercentage; goods_tariff_new.unit_of_measure_id = good_typeModel.unit_of_measure_id; if (good_typeModel.upload_document != null) { goods_tariff_new.dcument_name = file_name; } else if (TempData["document_name"] != null) { goods_tariff_new.dcument_name = TempData["document_name"].ToString(); } else { goods_tariff_new.dcument_name = null; } goods_tariff_new.created_date = DateTime.Now; goods_tariff_new.end_date = Convert.ToDateTime("9999-12-31"); db.Goods_Tariff.Add(goods_tariff_new); db.SaveChanges(); TempData["errorMessage"] = "Edited Successfully"; } return RedirectToAction("Index"); } return RedirectToAction("Index"); } else { return RedirectToAction("../Home/Dashboard"); } } else { return RedirectToAction("../Home"); } }
public ActionResult Edit(Goods_TypeModel good_typeModel) { int good_id = Convert.ToInt32(TempData["goods_id"]); Good good_new = db.Goods.Find(good_id); int goods_tariff_id = Convert.ToInt32(TempData["goods_tariff_id"]); Goods_Tariff goods_tariff = db.Goods_Tariff.Find(goods_tariff_id); Goods_Tariff goods_tariff_new = new Goods_Tariff(); if (ModelState.IsValid) { var is_exist = (from g in db.Goods where g.goods_name == good_typeModel.goods_name && g.goods_id != good_id select g).Count(); if (is_exist > 0) { TempData["errorMessage"] = "This Goods Already Exist"; } else { good_new.goods_type_id = good_typeModel.goods_type_id; good_new.goods_name = good_typeModel.goods_name; good_new.status_id = good_typeModel.status_id; good_new.created_date = TempData["created_date"].ToString(); good_new.updated_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd"); db.Entry(good_new).State = EntityState.Modified; db.SaveChanges(); goods_tariff.end_date = DateTime.Now; db.Entry(goods_tariff).State = EntityState.Modified; db.SaveChanges(); goods_tariff_new.goods_id = good_new.goods_id; goods_tariff_new.goods_tariff = good_typeModel.goods_tariff; goods_tariff_new.ispercentage = good_typeModel.ispercentage; goods_tariff_new.unit_of_measure_id = good_typeModel.unit_of_measure_id; goods_tariff_new.created_date = DateTime.Now; goods_tariff_new.end_date = Convert.ToDateTime("9999-12-31"); db.Goods_Tariff.Add(goods_tariff_new); db.SaveChanges(); TempData["errorMessage"] = "Edited Successfully"; } return RedirectToAction("Index"); } return RedirectToAction("Index"); }