public ActionResult Create(Levi_EntryModel levi_entryModel)
{
var end_date = "9999-12-31";
Levi_Entry levi_entry = new Levi_Entry();
if (ModelState.IsValid)
{
var is_exist = (from le in db.Levi_Entry where le.levi_name == levi_entryModel.levi_name && le.end_date == end_date select le).Count();
if (is_exist > 0)
{
TempData["errorMessage"] = "This Levy Name Already Exist";
}
else
{
levi_entry.levi_name = levi_entryModel.levi_name;
levi_entry.description = levi_entryModel.description;
levi_entry.levi_type_id = levi_entryModel.levi_type_id;
if (levi_entryModel.goods_category_id == 0)
{
levi_entry.goods_heirarchy_id = 0;
levi_entry.goods_item = null;
}
else if (levi_entryModel.goods_subcategory_id == 0)
{
levi_entry.goods_heirarchy_id = 1;
levi_entry.goods_item = levi_entryModel.goods_category_id;
}
else if (levi_entryModel.goods_type_id == 0)
{
levi_entry.goods_heirarchy_id = 2;
levi_entry.goods_item = levi_entryModel.goods_subcategory_id;
}
else if (levi_entryModel.goods_item == 0)
{
levi_entry.goods_heirarchy_id = 3;
levi_entry.goods_item = levi_entryModel.goods_type_id;
}
else
{
levi_entry.goods_heirarchy_id = 4;
levi_entry.goods_item = levi_entryModel.goods_item;
}
levi_entry.ispercentage = levi_entryModel.ispercentage;
levi_entry.levi = levi_entryModel.levi;
levi_entry.status_id = 1;
levi_entry.start_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd");
levi_entry.end_date = "9999-12-31";
levi_entry.isprocessed = false;
db.Levi_Entry.Add(levi_entry);
db.SaveChanges();
db.Update_Levi();
TempData["errorMessage"] = "Levy Added Successfully";
}
return RedirectToAction("Index");
}
return RedirectToAction("Index");
}
public ActionResult Create(Levi_EntryModel levi_entryModel)
{
if (Session["login_status"] != null)
{
int[] z = (int[])Session["function_id"];
var is_perentage_no = 0;
if (z.Contains(16))
{
var file_name = "";
var end_date = "9999-12-31";
var date_end = Convert.ToDateTime("9999-12-31");
Levi_Entry levi_entry = new Levi_Entry();
if (ModelState.IsValid)
{
var is_exist = (from le in db.Levi_Entry where le.levi_name == levi_entryModel.levi_name && le.end_date == end_date select le).Count();
if (is_exist > 0)
{
TempData["errorMessage"] = "This Levy Name Already Exist";
}
else
{
if (levi_entryModel.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);
}
}
levi_entry.levi_name = levi_entryModel.levi_name;
levi_entry.description = levi_entryModel.description;
levi_entry.levi_type_id = levi_entryModel.levi_type_id;
if (levi_entryModel.goods_category_id == 0)
{
levi_entry.goods_heirarchy_id = 0;
levi_entry.goods_item = null;
if (levi_entryModel.ispercentage == false)
{
TempData["errorMessage"] = "You can't add levy at flat rate here, there are multiple unit of measures";
return RedirectToAction("Index");
}
}
else if (levi_entryModel.goods_subcategory_id == 0)
{
is_perentage_no = (from gt in db.Goods_Tariff
join g in db.Goods on gt.goods_id equals g.goods_id
join gtp in db.Goods_Type on g.goods_type_id equals gtp.goods_type_id
join gs in db.Goods_Subcategory on gtp.goods_subcategory_id equals gs.goods_subcategory_id
join gc in db.Goods_Category on gs.goods_category_id equals gc.goods_category_id
where gc.goods_category_id == levi_entryModel.goods_category_id && gt.end_date == date_end
select gt.unit_of_measure_id).Distinct().Count();
if (is_perentage_no > 1 && levi_entryModel.ispercentage == false)
{
TempData["errorMessage"] = "You can't add levy at flat rate here, there are multiple unit of measures";
return RedirectToAction("Index");
}
levi_entry.goods_heirarchy_id = 1;
levi_entry.goods_item = levi_entryModel.goods_category_id;
}
else if (levi_entryModel.goods_type_id == 0)
{
is_perentage_no = (from gt in db.Goods_Tariff
join g in db.Goods on gt.goods_id equals g.goods_id
join gtp in db.Goods_Type on g.goods_type_id equals gtp.goods_type_id
join gs in db.Goods_Subcategory on gtp.goods_subcategory_id equals gs.goods_subcategory_id
where gs.goods_subcategory_id == levi_entryModel.goods_subcategory_id && gt.end_date == date_end
select gt.unit_of_measure_id).Distinct().Count();
if (is_perentage_no > 1 && levi_entryModel.ispercentage == false)
{
TempData["errorMessage"] = "You can't add levy at flat rate here, there are multiple unit of measures";
return RedirectToAction("Index");
}
levi_entry.goods_heirarchy_id = 2;
levi_entry.goods_item = levi_entryModel.goods_subcategory_id;
}
else if (levi_entryModel.goods_item == 0)
{
is_perentage_no = (from gt in db.Goods_Tariff
join g in db.Goods on gt.goods_id equals g.goods_id
join gtp in db.Goods_Type on g.goods_type_id equals gtp.goods_type_id
where gtp.goods_type_id == levi_entryModel.goods_type_id && gt.end_date == date_end
select gt.unit_of_measure_id).Distinct().Count();
if (is_perentage_no > 1 && levi_entryModel.ispercentage == false)
{
TempData["errorMessage"] = "You can't add levy at flat rate here, there are multiple unit of measures";
return RedirectToAction("Index");
}
levi_entry.goods_heirarchy_id = 3;
levi_entry.goods_item = levi_entryModel.goods_type_id;
}
else
{
levi_entry.goods_heirarchy_id = 4;
levi_entry.goods_item = levi_entryModel.goods_item;
}
levi_entry.ispercentage = levi_entryModel.ispercentage;
levi_entry.is_on_subtotal = Convert.ToInt32(levi_entryModel.is_on_subtotal);
levi_entry.levi = levi_entryModel.levi;
levi_entry.currency_id = levi_entryModel.currency_id;
levi_entry.status_id = 1;
levi_entry.start_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd");
levi_entry.end_date = "9999-12-31";
levi_entry.isprocessed = false;
levi_entry.document_name = file_name;
db.Levi_Entry.Add(levi_entry);
db.SaveChanges();
db.Update_Levi();
TempData["errorMessage"] = "Levy Added Successfully";
}
return RedirectToAction("Index");
}
return RedirectToAction("Index");
}
else
{
return RedirectToAction("../Home/Dashboard");
}
}
else
{
return RedirectToAction("../Home");
}
}
public ActionResult Edit(Levi_EntryModel levi_entryModel)
{
if (Session["login_status"] != null)
{
int[] z = (int[])Session["function_id"];
if (z.Contains(16))
{
var file_name = "";
var levi_entry_id = Convert.ToInt32(TempData["levi_entry_id"]);
var end_date = "9999-12-31";
Levi_Entry levi_entry = db.Levi_Entry.Find(levi_entry_id);
levi_entry.end_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd");
db.Entry(levi_entry).State = EntityState.Modified;
db.SaveChanges();
if (ModelState.IsValid)
{
var is_exist = (from le in db.Levi_Entry where le.levi_name == levi_entryModel.levi_name && le.Levi_entry_id != levi_entry_id && le.end_date == end_date select le).Count();
if (is_exist > 0)
{
TempData["errorMessage"] = "This Levy Name Already Exist";
}
else
{
if (levi_entryModel.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);
}
levi_entry.document_name = file_name;
}
else
{
levi_entry.document_name = TempData["document_name"].ToString();
}
levi_entry.levi_name = levi_entryModel.levi_name;
levi_entry.description = levi_entryModel.description;
levi_entry.levi_type_id = levi_entryModel.levi_type_id;
if (levi_entryModel.goods_category_id == 0)
{
levi_entry.goods_heirarchy_id = 0;
levi_entry.goods_item = null;
}
else if (levi_entryModel.goods_subcategory_id == 0)
{
levi_entry.goods_heirarchy_id = 1;
levi_entry.goods_item = levi_entryModel.goods_category_id;
}
else if (levi_entryModel.goods_type_id == 0)
{
levi_entry.goods_heirarchy_id = 2;
levi_entry.goods_item = levi_entryModel.goods_subcategory_id;
}
else if (levi_entryModel.goods_item == 0)
{
levi_entry.goods_heirarchy_id = 3;
levi_entry.goods_item = levi_entryModel.goods_type_id;
}
else
{
levi_entry.goods_heirarchy_id = 4;
levi_entry.goods_item = levi_entryModel.goods_item;
}
levi_entry.ispercentage = levi_entryModel.ispercentage;
levi_entry.is_on_subtotal = Convert.ToInt32(levi_entryModel.is_on_subtotal);
levi_entry.levi = levi_entryModel.levi;
levi_entry.status_id = levi_entryModel.status_id;
levi_entry.start_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd");
levi_entry.end_date = "9999-12-31";
levi_entry.isprocessed = false;
db.Levi_Entry.Add(levi_entry);
db.SaveChanges();
db.Update_Levi();
TempData["errorMessage"] = "Edited Successfully";
}
return RedirectToAction("Index");
}
return RedirectToAction("Index");
}
else
{
return RedirectToAction("../Home/Dashboard");
}
}
else
{
return RedirectToAction("../Home");
}
}
//
// GET: /Manage_Levis/Edit/5
public ActionResult Edit(int id = 0)
{
if (Session["login_status"] != null)
{
int[] z = (int[])Session["function_id"];
if (z.Contains(16))
{
var goods_category_id = 0;
var goods_subcategory_id = 0;
var goods_subcategory_name = "";
var goods_type_id = 0;
var goods_type_name = "";
var goods_id = 0;
var goods_name = "";
Levi_Entry levi_entry = db.Levi_Entry.Find(id);
Levi_EntryModel levi_entryModel = new Levi_EntryModel();
if (levi_entry.goods_heirarchy_id == 0)
{
goods_category_id = 0;
goods_subcategory_id = 0;
goods_subcategory_name = "All";
goods_type_id = 0;
goods_type_name = "All";
goods_id = 0;
goods_name = "All";
}
else if (levi_entry.goods_heirarchy_id == 1)
{
goods_category_id = Convert.ToInt32(levi_entry.goods_item);
goods_subcategory_id = 0;
goods_subcategory_name = "All";
goods_type_id = 0;
goods_type_name = "All";
goods_id = 0;
goods_name = "All";
}
else if (levi_entry.goods_heirarchy_id == 2)
{
var cateogry = from s in db.Goods_Subcategory
join c in db.Goods_Category on s.goods_category_id equals c.goods_category_id
where s.goods_subcategory_id == levi_entry.goods_item
select new { c.goods_category_id, s.goods_subcategory_name };
goods_category_id = cateogry.First().goods_category_id;
goods_subcategory_id = Convert.ToInt32(levi_entry.goods_item);
goods_subcategory_name = cateogry.First().goods_subcategory_name;
goods_type_id = 0;
goods_type_name = "All";
goods_id = 0;
goods_name = "All";
}
else if (levi_entry.goods_heirarchy_id == 3)
{
var cateogry = from t in db.Goods_Type
join s in db.Goods_Subcategory on t.goods_subcategory_id equals s.goods_subcategory_id
join c in db.Goods_Category on s.goods_category_id equals c.goods_category_id
where t.goods_type_id == levi_entry.goods_item
select new { c.goods_category_id, s.goods_subcategory_id, s.goods_subcategory_name, t.goods_type_name };
goods_category_id = cateogry.First().goods_category_id;
goods_subcategory_id = cateogry.First().goods_subcategory_id;
goods_subcategory_name = cateogry.First().goods_subcategory_name;
goods_type_id = Convert.ToInt32(levi_entry.goods_item);
goods_type_name = cateogry.First().goods_type_name;
goods_id = 0;
goods_name = "All";
}
else if (levi_entry.goods_heirarchy_id == 4)
{
var cateogry = from g in db.Goods
join t in db.Goods_Type on g.goods_type_id equals t.goods_type_id
join s in db.Goods_Subcategory on t.goods_subcategory_id equals s.goods_subcategory_id
join c in db.Goods_Category on s.goods_category_id equals c.goods_category_id
where g.goods_id == levi_entry.goods_item
select new { c.goods_category_id, s.goods_subcategory_id, t.goods_type_id, s.goods_subcategory_name, t.goods_type_name, g.goods_name };
goods_category_id = cateogry.First().goods_category_id;
goods_subcategory_id = cateogry.First().goods_subcategory_id;
goods_subcategory_name = cateogry.First().goods_subcategory_name;
goods_type_id = cateogry.First().goods_type_id;
goods_type_name = cateogry.First().goods_type_name;
goods_id = Convert.ToInt32(levi_entry.goods_item);
goods_name = cateogry.First().goods_name;
}
levi_entryModel.goods_category_id = goods_category_id;
levi_entryModel.goods_subcategory_id = goods_subcategory_id;
levi_entryModel.goods_type_id = goods_type_id;
levi_entryModel.goods_item = goods_id;
IList<SelectListItem> subactegory = new List<SelectListItem>
{
new SelectListItem{Text = goods_subcategory_name, Value = goods_subcategory_id.ToString()},
};
IList<SelectListItem> type = new List<SelectListItem>
{
new SelectListItem{Text = goods_type_name, Value = goods_type_id.ToString()},
};
IList<SelectListItem> goods_item = new List<SelectListItem>
{
new SelectListItem{Text = goods_name, Value = goods_id.ToString()},
};
var subcategory_items = from s in db.Goods_Subcategory
where s.goods_category_id == goods_category_id
select new { s.goods_subcategory_id, s.goods_subcategory_name };
var type_items = from t in db.Goods_Type
where t.goods_subcategory_id == goods_subcategory_id
select new { t.goods_type_id, t.goods_type_name };
var goodses = from g in db.Goods
where g.goods_type_id == goods_type_id
select new { g.goods_id, g.goods_name };
if (levi_entry.goods_heirarchy_id == 0)
{
ViewBag.subcategories = new SelectList(subactegory, "Value", "Text");
ViewBag.goods_type = new SelectList(type, "Value", "Text");
ViewBag.goods = new SelectList(goods_item, "Value", "Text");
}
if (levi_entry.goods_heirarchy_id == 1)
{
ViewBag.subcategories = new SelectList(subcategory_items, "goods_subcategory_id", "goods_subcategory_name");
ViewBag.goods_type = new SelectList(type, "Value", "Text");
ViewBag.goods = new SelectList(goods_item, "Value", "Text");
}
if (levi_entry.goods_heirarchy_id == 2)
{
ViewBag.subcategories = new SelectList(subcategory_items, "goods_subcategory_id", "goods_subcategory_name");
ViewBag.goods_type = new SelectList(type_items, "goods_type_id", "goods_type_name");
ViewBag.goods = new SelectList(goods_item, "Value", "Text");
}
if (levi_entry.goods_heirarchy_id == 3 || levi_entry.goods_heirarchy_id == 4)
{
ViewBag.subcategories = new SelectList(subcategory_items, "goods_subcategory_id", "goods_subcategory_name");
ViewBag.goods_type = new SelectList(type_items, "goods_type_id", "goods_type_name");
ViewBag.goods = new SelectList(goodses, "goods_id", "goods_name");
}
ViewBag.currency = new HomeController().Sos_Usd_Currency();
levi_entryModel.Levi_entry_id = levi_entry.Levi_entry_id;
levi_entryModel.levi_name = levi_entry.levi_name;
levi_entryModel.description = levi_entry.description;
levi_entryModel.levi_type_id = levi_entry.levi_type_id;
levi_entryModel.goods_heirarchy_id = levi_entry.goods_heirarchy_id;
levi_entryModel.goods_item = levi_entry.goods_item;
levi_entryModel.ispercentage = levi_entry.ispercentage;
levi_entryModel.is_on_subtotal = Convert.ToBoolean(levi_entry.is_on_subtotal);
levi_entryModel.levi = levi_entry.levi;
levi_entryModel.currency_id = levi_entry.currency_id;
levi_entryModel.status_id = levi_entry.status_id;
levi_entryModel.start_date = levi_entry.start_date;
levi_entryModel.end_date = levi_entry.end_date;
ViewBag.status = new HomeController().Status();
ViewBag.levi_type = new HomeController().Levi_Type();
ViewBag.categories = new HomeController().Category();
TempData["document_name"] = levi_entry.document_name;
TempData["levi_entry_id"] = levi_entry.Levi_entry_id;
TempData["levi_type_id"] = levi_entry.levi_type_id;
return View(levi_entryModel);
}
else
{
return RedirectToAction("../Home/Dashboard");
}
}
else
{
return RedirectToAction("../Home");
}
}
