public JsonResult Update(TicketMonth entity)
{
TicketMonth user = db.TicketMonths.ToList().Find(x => x.ID.Equals(entity.ID));
user.RowID = entity.RowID;
user.ID = entity.ID;
user.Stt = entity.Stt;
user.ProcessDate = entity.ProcessDate;
user.Digit = entity.Digit;
user.Company = entity.Company;
user.TenKH = entity.TenKH;
user.CMND = entity.CMND;
user.Email = entity.Email;
user.Address = entity.Address;
user.CarKind = entity.CarKind;
user.DateStart = entity.DateStart;
user.DateEnd = entity.DateEnd;
user.Amount = entity.Amount;
user.Account = entity.Account;
user.ChargesAmount = entity.ChargesAmount;
user.DayUnLimit = entity.DayUnLimit;
user.Note = entity.Note;
user.Images = entity.Images;
user.IDPart = entity.IDPart;
db.SubmitChanges();
return(Json(new { msg = user }, JsonRequestBehavior.AllowGet));
}
public JsonResult Create(TicketMonth entity)
{
db.TicketMonths.InsertOnSubmit(entity);
db.SubmitChanges();
var rs = "Insert Successfully";
return(Json(new { msg = rs }, JsonRequestBehavior.AllowGet));
}
public ActionResult doiten(string id, FormCollection collection)
{
TicketMonth name = data.TicketMonths.Single(p => p.ID == id);
string newname = collection["txtName"];
name.TenKH = newname;
UpdateModel(name);
data.SubmitChanges();
return(RedirectToAction("XemThongTin"));
}
public ActionResult chuyen(string id)
{
SmartCard name = data.SmartCards.Single(p => p.ID == id);
TicketMonth name2 = data.TicketMonths.Single(p => p.ID == id);
name2.IDPart = "6";
name.Type = 6;
UpdateModel(name);
UpdateModel(name2);
data.SubmitChanges();
return(RedirectToAction("XemThongTin"));
}
public void AddTicketMonthLogEdit(TicketMonth ticketMonthOld, TicketMonth ticketMonthNew, string actionType, string nameUserCreateLog, string Code)
{
using (DB db = new DB(Code))
{
try
{
if (ticketMonthOld == null || ticketMonthNew == null)
{
Debug.WriteLine("TicketMonth null không thể tạo log");
return;
}
var dateTime = DateTime.Now;
var ticketLog = new TicketLog()
{
RowID = ticketMonthNew.RowID,
ProcessType = actionType,
STT = (ticketMonthOld.Stt != ticketMonthNew.Stt) ? ticketMonthOld.Stt + "->" + ticketMonthNew.Stt : ticketMonthNew.Stt + "",
ID = (!(ticketMonthOld.ID + "").Equals(ticketMonthNew.ID + "")) ? ticketMonthOld.ID + "->" + ticketMonthNew.ID : ticketMonthNew.ID + "",
DateProcess = dateTime,
Digit = (!ticketMonthOld.Digit.Equals(ticketMonthNew.Digit + "")) ? ticketMonthOld.Digit + "->" + ticketMonthNew.Digit : ticketMonthNew.Digit + "",
TenKH = (!(ticketMonthOld.TenKH + "").Equals(ticketMonthNew.TenKH + "")) ? ticketMonthOld.TenKH + "->" + ticketMonthNew.TenKH : ticketMonthNew.TenKH + "",
CMND = (!(ticketMonthOld.CMND + "").Equals(ticketMonthNew.CMND + "")) ? ticketMonthOld.CMND + "->" + ticketMonthNew.CMND : ticketMonthNew.CMND + "",
Company = (!(ticketMonthOld.Company + "").Equals(ticketMonthNew.Company + "")) ? ticketMonthOld.Company + "->" + ticketMonthNew.Company : ticketMonthNew.Company + "",
EMail = (!(ticketMonthOld.Email + "").Equals(ticketMonthNew.Email + "")) ? ticketMonthOld.Email + "->" + ticketMonthNew.Email : ticketMonthNew.Email + "",
Address = (!(ticketMonthOld.Address + "").Equals(ticketMonthNew.Address + "")) ? ticketMonthOld.Address + "->" + ticketMonthNew.Address : ticketMonthNew.Address + "",
CarKind = (!(ticketMonthOld.CarKind + "").Equals(ticketMonthNew.CarKind + "")) ? ticketMonthOld.CarKind + "->" + ticketMonthNew.CarKind : ticketMonthNew.CarKind + "",
IDPart = (ticketMonthOld.IDPart != ticketMonthNew.IDPart) ? ticketMonthOld.IDPart + "->" + ticketMonthNew.IDPart : ticketMonthNew.IDPart + "",
DateStart = (!(ticketMonthOld.DateStart + "").Equals((ticketMonthNew.DateStart + ""))) ? (ticketMonthOld.DateStart + "") + "->" + (ticketMonthNew.DateStart + "") : ticketMonthNew.DateStart + "",
DateEnd = (!(ticketMonthOld.DateEnd + "").Equals(ticketMonthNew.DateEnd + "")) ? ticketMonthOld.DateEnd + "" + "->" + (ticketMonthNew.DateEnd + "") : ticketMonthNew.DateEnd + "",
Note = (!(ticketMonthOld.Note + "").Equals(ticketMonthNew.Note + "")) ? ticketMonthOld.Note + "->" + ticketMonthNew.Note : ticketMonthNew.Note + "",
Amount = (!(ticketMonthOld.Amount + "").Equals(ticketMonthNew.Amount + "")) ? ticketMonthOld.Amount + "->" + ticketMonthNew.Amount : ticketMonthNew.Amount + "",
ChargesAmount = (!(ticketMonthOld.ChargesAmount + "").Equals(ticketMonthNew.ChargesAmount + "")) ? ticketMonthOld.ChargesAmount + "->" + ticketMonthNew.ChargesAmount : ticketMonthNew.ChargesAmount + "",
Account = nameUserCreateLog,
Images = ticketMonthOld.Images,
DayUnLimit = String.Format("{0:MMM dd yyyy hh:mm tt}", ticketMonthNew.DayUnLimit.Value + "")
};
db.TicketLogs.Add(ticketLog);
db.SaveChanges();
}
catch (Exception e)
{
Debug.WriteLine("Không thể tạo log: " + e.Message);
Debug.WriteLine("Không thể tạo log: " + e.StackTrace);
}
}
}
public void AddTicketMonthLog(TicketMonth ticketMonth, string actionType, string nameUserCreateLog, string Code)
{
using (DB db = new DB(Code))
{
try
{
if (ticketMonth == null)
{
Debug.WriteLine("TicketMonth null không thể tạo log");
return;
}
var dateTime = DateTime.Now;
var ticketLog = new TicketLog()
{
RowID = ticketMonth.RowID,
ProcessType = actionType,
STT = ticketMonth.Stt.ToString(),
ID = ticketMonth.ID,
DateProcess = dateTime,
Digit = ticketMonth.Digit,
TenKH = ticketMonth.TenKH,
CMND = ticketMonth.CMND,
Company = ticketMonth.Company,
EMail = ticketMonth.Email,
Address = ticketMonth.Address,
CarKind = ticketMonth.CarKind,
IDPart = ticketMonth.IDPart,
DateStart = ticketMonth.DateStart.ToString(),
DateEnd = ticketMonth.DateEnd.ToString(),
Note = ticketMonth.Note,
Amount = ticketMonth.Amount,
ChargesAmount = ticketMonth.ChargesAmount,
Account = nameUserCreateLog,
Images = ticketMonth.Images,
DayUnLimit = String.Format("{0:MMM dd yyyy hh:mm tt}", ticketMonth.DayUnLimit.Value),
};
db.TicketLogs.Add(ticketLog);
db.SaveChanges();
}
catch (Exception e)
{
Debug.WriteLine("Không thể tạo log: " + e.Message);
Debug.WriteLine("Không thể tạo log: " + e.StackTrace);
}
}
}
public ActionResult them(TicketMonth tiket)
{
data.TicketMonths.InsertOnSubmit(tiket);
data.SubmitChanges();
return(RedirectToAction("XemThongTin"));
}
