public ActionResult Create(DebitNoteProductModel debitProduct)
{
try
{
using (DoorEntities db = new DoorEntities())
{
if (debitProduct.Debit_Note.id == 0)
{
Debit_Note usingData = this.convertDebit(debitProduct.Debit_Note, "create");
db.Debit_Note.Add(usingData);
db.SaveChanges();
return(Json(new { success = true, message = "Save Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(View());
}
}
}
catch
{
return(View());
}
}
public Debit_Note getLastID()
{
using (DoorEntities db = new DoorEntities())
{
return(db.Debit_Note.OrderByDescending(x => x.id).First()); //.FirstOrDefault<Debit_Note>();
}
}
public ActionResult AddEditViewUsers(int id = 0)
{
if (id == 0)
{
return(View());
}
else
{
using (DoorEntities db = new DoorEntities())
{
temUserData = db.Users.Where(x => x.user_id == id).FirstOrDefault <User>();
UsersModel usingData = new UsersModel();
usingData.beg_date = temUserData.beg_date;
usingData.username = temUserData.username;
usingData.user_id = temUserData.user_id;
usingData.username = temUserData.username;
usingData.password = temUserData.password;
usingData.fullname = temUserData.fullname;
usingData.sex = temUserData.sex;
usingData.role = temUserData.role;
usingData.personal_info = temUserData.personal_info;
usingData.last_change_by = temUserData.last_change_by;
usingData.last_change_on = temUserData.last_change_on;
usingData.create_by = temUserData.create_by;
usingData.create_on = temUserData.create_on;
usingData.extra = temUserData.extra;
//ViewData["input"] = enable;
return(View(usingData));
//UsersModel userData = new UsersModel();
//return View(userData);
}
}
}
public ActionResult Delete(int id)
{
try
{
// TODO: Add delete logic here
using (DoorEntities db = new DoorEntities())
{
//User userData = db.Users.Where( x => x.user_id == id).FirstOrDefault<User>();
//userData.end_date = DateTime.Now;
var userUpdate = new User()
{
user_id = id, end_date = DateTime.Now, last_change_by = "rithy2", last_change_on = DateTime.Now
};
db.Users.Attach(userUpdate);
db.Entry(userUpdate).Property(x => x.end_date).IsModified = true;
db.Entry(userUpdate).Property(x => x.last_change_on).IsModified = true;
db.Entry(userUpdate).Property(x => x.last_change_by).IsModified = true;
//db.Users.Remove(userData);
db.SaveChanges();
return(Json(new { success = true, message = "Delete user successfully" }, JsonRequestBehavior.AllowGet));
}
//return RedirectToAction("Index");
}
catch
{
return(View());
}
}
public ActionResult LoadUser()
{
using (DoorEntities doorDB = new DoorEntities())
{
List <User> UserList = doorDB.Users.Where(x => x.end_date > DateTime.Now).ToList <User>();
return(Json(new { data = UserList }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult LoadDebitNote()
{
using (DoorEntities doorDB = new DoorEntities())
{
List <Debit_Note> DebitNoteList = doorDB.Debit_Note.Where(x => x.end_date > DateTime.Now).ToList <Debit_Note>();
//DebitNoteModel usingData = new DebitNoteModel();
// usingData.debit_id = DebitNoteList.debit
return(Json(new { data = DebitNoteList }, JsonRequestBehavior.AllowGet));
}
}
// GET: Edit user
public ActionResult EditDebitNote(int id = 0)
{
if (id == 0)
{
return(View());
}
else
{
//return RedirectToAction("AddEditViewDebit", "DebitNote", new { @id = id });
using (DoorEntities db = new DoorEntities())
{
temDebitData = db.Debit_Note.Where(x => x.id == id).FirstOrDefault <Debit_Note>();
Debit_Note debitNote = db.Debit_Note.Where(x => x.id == id).FirstOrDefault <Debit_Note>();
DebitNoteModel debitNoteData = new DebitNoteModel();
List <Debit_Product> DebitProduct = db.Debit_Product.Where(x => x.debit_id == id).ToList <Debit_Product>();
//static List<DebitNoteModel> debitPruductData = new List<DebitNoteModel>();
DebitNoteProductModel DebitNoteProduct = new DebitNoteProductModel();
debitNoteData.id = debitNote.id;
debitNoteData.debit_id = debitNote.debit_id;
debitNoteData.start_date = debitNote.start_date;
debitNoteData.end_date = debitNote.end_date;
debitNoteData.create_by = debitNote.create_by;
debitNoteData.create_on = debitNote.create_on;
debitNoteData.edit_by = debitNote.edit_by;
debitNoteData.paying_date = debitNote.paying_date;
debitNoteData.reference = debitNote.reference;
debitNoteData.record_date = debitNote.record_date;
debitNoteData.customer_name = debitNote.customer_name;
debitNoteData.billing_to = debitNote.billing_to;
debitNoteData.cust_address = debitNote.cust_address;
debitNoteData.customer_phone = debitNote.customer_phone;
debitNoteData.bl = debitNote.bl;
debitNoteData.container_number = debitNote.container_number;
debitNoteData.commodity = debitNote.commodity;
debitNoteData.package_number = debitNote.package_number;
debitNoteData.vessel = debitNote.vessel;
debitNoteData.voy = debitNote.voy;
debitNoteData.advance_money = debitNote.advance_money;
DebitNoteProduct.Debit_Note = debitNoteData;
DebitNoteProduct.DebitProductList = DebitProduct;
return(View("Edit", DebitNoteProduct));
}
}
}
public ActionResult AddEditDebitProduct(int productID)
{
DoorEntities db = new DoorEntities();
DebitProductModel product = new DebitProductModel();
if (productID > 0)
{
Debit_Product debit_product = db.Debit_Product.SingleOrDefault(x => x.product_id == productID);
product = this.convertProduct(debit_product);
}
else
{
}
return(PartialView("product", product));
}
public User GetUser(int id = 0)
{
using (DoorEntities db = new DoorEntities())
{
if (id == 0)
{
User oldUserData = db.Users.Where(x => x.end_date > DateTime.Now).FirstOrDefault <User>();
return(oldUserData);
}
else
{
User oldUserData = db.Users.Where(x => x.user_id == id).FirstOrDefault <User>();
return(oldUserData);
}
}
}
public ActionResult AddEditViewUsers(User userData)
{
//var existingUser = true;
try
{
// TODO: Add insert logic here
using (DoorEntities db = new DoorEntities())
{
if (userData.user_id == 0)
{
db.Users.Add(userData);
userData.beg_date = DateTime.Now;
userData.end_date = Convert.ToDateTime("May 01 9999");
userData.create_by = "rithy";
userData.create_on = DateTime.Now;
userData.last_change_by = "rithy";
userData.last_change_on = DateTime.Now;
db.SaveChanges();
return(Json(new { success = true, message = "Save Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
//db.Entry(userData).State = EntityState.Modified;
// modify old data of end date to yesterday
this.UpdateOldUserData(userData.user_id);
db.Users.Add(userData);
userData.beg_date = DateTime.Now;
userData.last_change_by = "reach"; //temUserData.create_by;
userData.last_change_on = DateTime.Now;
db.SaveChanges();
return(Json(new { success = true, message = "Update Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
catch
{
return(View());
}
}
// GET: View user detail
public ActionResult Create()
{
using (DoorEntities db = new DoorEntities())
{
DebitNoteModel debitNoteData = new DebitNoteModel();
DebitNoteProductModel DebitNoteProduct = new DebitNoteProductModel();
Debit_Note debit_last_data = getLastID();
int id = debit_last_data.id + 1;
string id_st = "No2018-" + id;
debitNoteData.debit_fullId = id_st;
DebitNoteProduct.Debit_Note = debitNoteData;
DebitNoteProduct.DebitProductList = new List <Debit_Product>();
return(View("Create", DebitNoteProduct));
}
}
public ActionResult Login(LoginModel objUser, string returnUrl)
{
if (ModelState.IsValid)
{
using (DoorEntities db = new DoorEntities())
{
var obj = db.Users.Where(a => a.username.Equals(objUser.username) && a.end_date > DateTime.Now).FirstOrDefault();
if (obj != null)
{
Session["UserID"] = obj.user_id.ToString();
Session["UserName"] = obj.username.ToString();
FormsAuthentication.SetAuthCookie(objUser.username, true);
string ReturnUrl = Convert.ToString(Request.QueryString["url"]);
if (!string.IsNullOrWhiteSpace(returnUrl))
{
return(Redirect(returnUrl));
}
return(View("Home"));
}
}
}
ViewBag.Message = "Invalide Username or Password";
return(View(objUser));
}
