public ActionResult AddOrEdit(VT_GetFeeByConsignee_Result fee)
{
if (fee.ID == 0)
{
FeeByConsignee f = new FeeByConsignee();
f.ConsigneeID = fee.cid;
f.Name = fee.Name;
f.Price = fee.Price;
f.ShortName = fee.ShortName;
f.Unit = fee.Unit;
db.FeeByConsignees.Add(f);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
FeeByConsignee f = db.FeeByConsignees.Where(x => x.ID == fee.ID).FirstOrDefault();
f.ConsigneeID = fee.cid;
f.Name = fee.Name;
f.Price = fee.Price;
f.ShortName = fee.ShortName;
f.Unit = fee.Unit;
db.Entry(f).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(VT_GetTruckInFo_Result con)
{
if (con.ID == 0)
{
Truck truck = new Truck();
truck.DriverID = con.DriverID;
truck.TruckNo = con.TruckNo;
truck.Status = con.Status;
truck.TrailerID = con.TrailerID;
truck.Expire = con.Expire;
truck.Transit = con.Transit;
truck.OwnRent = con.OwnRent;
db.Trucks.Add(truck);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
Truck truck = db.Trucks.Where(c => c.ID == con.ID).FirstOrDefault();
truck.DriverID = con.DriverID;
truck.TruckNo = con.TruckNo;
truck.Status = con.Status;
truck.TrailerID = con.TrailerID;
truck.Expire = con.Expire;
truck.Transit = con.Transit;
truck.OwnRent = con.OwnRent;
db.Entry(truck).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEditConsignee(VT_GetConsigneeWithArea_Result con)
{
if (con.ID == 0)
{
Consignee c = new Consignee();
c.Address = con.Address;
c.Name = con.Name;
c.AreaID = con.aid;
c.ShortName = con.ShortName;
db.Consignees.Add(c);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
Consignee c = db.Consignees.Where(x => x.ID == con.ID).FirstOrDefault();
c.Address = con.Address;
c.Name = con.Name;
c.TaxCode = con.TaxCode;
c.AreaID = con.aid;
c.ShortName = con.ShortName;
db.Entry(c).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(VT_GetTripOrder_Result result)
{
if (result.CompleteDate == null)
{
db.VT_CompleteTrip(result.CntrNo, result.ID, result.TruckNo, DateTime.Now, result.Status, result.Note);
}
else
{
DateTime complete = DateTime.ParseExact(result.CompleteDate, "yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);
db.VT_CompleteTrip(result.CntrNo, result.ID, result.TruckNo, complete, result.Status, result.Note);
}
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
public ActionResult AddOrEdit(Truck con)
{
if (con.ID == 0)
{
db.Trucks.Add(con);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
db.Entry(con).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(Driver con)
{
if (con.ID == 0)
{
db.Drivers.Add(con);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
var local = db.Set <Driver>()
.Local
.FirstOrDefault(f => f.ID == con.ID);
if (local != null)
{
db.Entry(local).State = EntityState.Detached;
}
db.Entry(con).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(Unit con)
{
if (con.ID == 0)
{
db.Units.Add(con);
db.SaveChanges();
return(Json(new { success = true, message = "Lưu đơn vị tính thành công" }, JsonRequestBehavior.AllowGet));
}
else
{
var local = db.Set <Unit>()
.Local
.FirstOrDefault(f => f.ID == con.ID);
if (local != null)
{
db.Entry(local).State = EntityState.Detached;
}
db.Entry(con).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Cập nhật thành công" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(VT_GetTripOrder_Result result)
{
try
{
if (result.CompleteDate == null)
{
db.VT_CompleteTrip(result.CntrNo, result.ID, result.TruckNo, DateTime.Now, result.Status, result.Note, result.Weight);
}
else
{
DateTime complete = DateTime.ParseExact(result.CompleteDate + " 23:59", "dd/MM/yyyy HH:mm", CultureInfo.InvariantCulture);
db.VT_CompleteTrip(result.CntrNo, result.ID, result.TruckNo, complete, result.Status, result.Note, result.Weight);
}
db.SaveChanges();
return(Json(new { success = true, message = "Chỉnh sửa chi tiết thành công!" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
help.LogError(ex);
return(Json(new { success = false, message = "Lỗi chỉnh sửa chi tiết!" }, JsonRequestBehavior.AllowGet));
}
}
//ham post doi mat khau
public ActionResult ChangePass(string username, string password, string newpassword)
{
User u = db.Users.Where(x => x.Username == username && x.Password == password).FirstOrDefault();
if (u != null)
{
u.Password = newpassword;
db.SaveChanges();
FormsAuthentication.SetAuthCookie(username + "|" + u.FullName + "|" + u.RolesID, true);
return(Redirect("/Index/Index"));
}
else
{
TempData["Tag"] = "Wrong username or password!";
return(RedirectToAction("Edit", "Login", TempData));
}
}
public ActionResult AddNew(string Type, string Bill, string Note, string PickupYard, string Commodity, string Inquiry, string Payer, string Weight, string Caller,
string ConsigneeID, string ExpireDate, string Shipping, string ChangePlan, string TransportDate, string StuffDate,
string StuffWH)
{
Transaction t = new Transaction();
DateTime date = DateTime.ParseExact(ExpireDate + " 23:59", "dd/MM/yyyy HH:mm", CultureInfo.InvariantCulture);
t.CreateDate = DateTime.Now;
t.ConsigneeID = Int32.Parse(ConsigneeID);
t.Note = Note;
t.Type = Uri.UnescapeDataString(Type);
t.Total = 0;
t.TransportDate = DateTime.ParseExact(TransportDate, "dd/MM/yyyy HH:mm", CultureInfo.InvariantCulture);
t.ExpireDate = date;
t.StuffDate = StuffDate;
t.StuffingWarehouse = StuffWH;
t.ChangePlan = ChangePlan;
if (Type.Contains("Xuat"))
{
t.Booking = Bill;
}
else
{
t.Bill = Bill;
}
t.PickupYard = PickupYard;
t.staff_cd = User.Identity.Name.Split('|')[0];
t.Shipping = Shipping;
t.update_time = DateTime.Now;
t.Commodity = Commodity;
t.Inquiry = Inquiry;
t.Payer = Payer;
t.Weight = Weight;
t.Caller = Caller;
db.Transactions.Add(t);
db.SaveChanges();
int id = t.ID;
int cid = Int32.Parse(ConsigneeID);
var price = db.FeeByConsignees.Where(x => x.ConsigneeID == cid).Select(x => new { x.Name, x.ShortName }).ToList();
return(Json(new { success = true, message = "Saved Successfully", tranid = id, price }, JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(int id)
{
try
{
Zalo zalo = new Zalo();
zalo.DeleteById(id, db);
Transaction con = db.Transactions.Where(x => x.ID == id).FirstOrDefault <Transaction>();
db.Transactions.Remove(con);
db.SaveChanges();
return(Json(new { success = true, message = "Xóa giao dịch thành công!" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
help.LogError(ex);
return(Json(new { success = false, message = "Lỗi xóa giao dịch!" }, JsonRequestBehavior.AllowGet));
}
}