private string MutationNumberNew(int?asset_id)
{
tr_asset_registration tr_asset = db.tr_asset_registration.Find(asset_id);
ms_asmin_company company = db.ms_asmin_company.Find(tr_asset.company_id);
ms_department department = db.ms_department.Find(tr_asset.department_id);
ms_asset_category category = db.ms_asset_category.Find(tr_asset.category_id);
string code = string.Empty;
code += "M";
code += company.company_code;
code += department.department_code;
code += category.category_code;
code += DateTime.Today.Year;
code += DateTime.Today.Month.ToString().PadLeft(2, '0');
var _lastno = (from dr in db.tr_disposal_request
where dr.disposal_number.Contains(code)
orderby dr.request_id descending
select dr).ToList <tr_disposal_request>();
if (_lastno.Count > 0)
{
tr_disposal_request lastno = _lastno.FirstOrDefault();
string currentno = (Convert.ToInt32(lastno.disposal_number.Substring((lastno.disposal_number.Length - 2), 2)) + 1).ToString();
code += currentno.PadLeft(2, '0');
}
else
{
code += "01";
}
code += "-";
code += tr_asset.asset_number.Substring((tr_asset.asset_number.Length - 2), 2);
return(code);
}
public ActionResult DeleteConfirmed(int id)
{
ms_asmin_company ms_asmin_company = db.ms_asmin_company.Find(id);
db.ms_asmin_company.Remove(ms_asmin_company);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "company_id,company_code,company_name,fl_active,created_date,created_by,updated_date,updated_by,deleted_date,deleted_by,org_id")] ms_asmin_company ms_asmin_company)
{
if (ModelState.IsValid)
{
db.Entry(ms_asmin_company).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ms_asmin_company));
}
public ActionResult Create([Bind(Include = "company_id,company_code,company_name,fl_active,created_date,created_by,updated_date,updated_by,deleted_date,deleted_by,org_id")] ms_asmin_company ms_asmin_company)
{
if (ModelState.IsValid)
{
db.ms_asmin_company.Add(ms_asmin_company);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ms_asmin_company));
}
// GET: asmin_company/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ms_asmin_company ms_asmin_company = db.ms_asmin_company.Find(id);
if (ms_asmin_company == null)
{
return(HttpNotFound());
}
return(View(ms_asmin_company));
}
public JsonResult CrudCompany()
{
if (UserProfile.UserId != 0)
{
if (Request.Form["oper"] == "add")
{
//prepare for insert data
ms_asmin_company ms_asmin_company = new ms_asmin_company();
ms_asmin_company.company_code = Request.Form["company_code"];
ms_asmin_company.company_name = Request.Form["company_name"];
ms_asmin_company.fl_active = Request.Form["rec_isactive"] == "Yes" ? true : false;
//ms_asmin_company.fl_active = true;
ms_asmin_company.created_by = UserProfile.UserId;
ms_asmin_company.created_date = DateTime.Now;
ms_asmin_company.updated_by = UserProfile.UserId;
ms_asmin_company.updated_date = DateTime.Now;
ms_asmin_company.org_id = UserProfile.OrgId;
ms_asmin_company.deleted_by = null;
ms_asmin_company.deleted_date = null;
//db.ms_asmin_company.Add(ms_asmin_company);
db.Entry(ms_asmin_company).State = EntityState.Added;
db.SaveChanges();
return(Json("Insert", JsonRequestBehavior.AllowGet));
}
else if (Request.Form["oper"] == "edit")
{
if (IsNumeric(Request.Form["company_id"].ToString()))
{
//prepare for update data
int id = Convert.ToInt32(Request.Form["company_id"]);
ms_asmin_company ms_asmin_company = db.ms_asmin_company.Find(id);
ms_asmin_company.company_code = Request.Form["company_code"];
ms_asmin_company.company_name = Request.Form["company_name"];
ms_asmin_company.fl_active = Request.Form["rec_isactive"] == "Yes" ? true : false;
//ms_asmin_company.fl_active = true;
ms_asmin_company.updated_by = UserProfile.UserId;
ms_asmin_company.updated_date = DateTime.Now;
db.Entry(ms_asmin_company).State = EntityState.Modified;
db.SaveChanges();
return(Json("Update", JsonRequestBehavior.AllowGet));
}
else
{
//prepare for insert data
ms_asmin_company ms_asmin_company = new ms_asmin_company();
ms_asmin_company.company_code = Request.Form["company_code"];
ms_asmin_company.company_name = Request.Form["company_name"];
ms_asmin_company.created_by = 1;
ms_asmin_company.fl_active = Request.Form["rec_isactive"] == "Yes" ? true : false;
//ms_asmin_company.fl_active = true;
ms_asmin_company.created_by = UserProfile.UserId;
ms_asmin_company.created_date = DateTime.Now;
ms_asmin_company.updated_by = UserProfile.UserId;
ms_asmin_company.updated_date = DateTime.Now;
ms_asmin_company.org_id = UserProfile.OrgId;
ms_asmin_company.deleted_by = null;
ms_asmin_company.deleted_date = null;
//db.ms_asmin_company.Add(ms_asmin_company);
db.Entry(ms_asmin_company).State = EntityState.Added;
db.SaveChanges();
return(Json("Insert", JsonRequestBehavior.AllowGet));
}
}
else
{
if (Request.Form["oper"] == "del")
{
//for delete process
string ids = Request.Form["id"];
string[] values = ids.Split(',');
for (int i = 0; i < values.Length; i++)
{
values[i] = values[i].Trim();
//prepare for soft delete data
int id = Convert.ToInt32(values[i]);
ms_asmin_company ms_asmin_company = db.ms_asmin_company.Find(id);
ms_asmin_company.fl_active = false;
ms_asmin_company.deleted_by = UserProfile.UserId;
ms_asmin_company.deleted_date = DateTime.Now;
db.Entry(ms_asmin_company).State = EntityState.Modified;
db.SaveChanges();
}
return(Json("Delete", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("Error", JsonRequestBehavior.AllowGet));
}
}
}
else
{
return(Json("Session", JsonRequestBehavior.AllowGet));
}
}
