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");
}
