public JsonResult CheckMa(string code, int IDCabin)
{
try
{
using (var db = new MyDbDataContext())
{
DateTime today = DateTime.Now;
ProjectLibrary.Database.PromotionCodeCabin del = db.PromotionCodeCabins.FirstOrDefault(c => c.Code == code && c.IDCabin == IDCabin &&
today <= c.NgayKetThuc && today >= c.NgayBatDau && c.TrangThai == true);
if (del != null)
{
/*
* 1-het ma
* 2-ok co ma va con luot dung
* 3-loi ko co ma nao
*/
if (del.DaDung >= del.SL)
{
return(Json(new { Result = "OK", Message = "1" }));
}
else
{
del.DaDung = del.DaDung + 1;
db.SubmitChanges();
return(Json(new { Result = "OK", Message = "2" }));
}
}
return(Json(new { Result = "ERROR", Message = "3" }));
}
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", ex.Message }));
}
}
public ActionResult Create(FormCollection frm)
{
if (ModelState.IsValid)
{
try
{
var model = new ProjectLibrary.Database.PromotionCodeCabin();
model.Code = frm["txtCode"];
string[] str = frm["txtNgayBatDau"].ToString().Split('/', '-');
int day = int.Parse(str[0]);
int month = int.Parse(str[1]);
int year = int.Parse(str[2]);
model.NgayBatDau = new DateTime(year, month, day);
str = frm["txtNgayKetThuc"].ToString().Split('/', '-');
day = int.Parse(str[0]);
month = int.Parse(str[1]);
year = int.Parse(str[2]);
model.NgayKetThuc = new DateTime(year, month, day);
model.IDCabin = int.Parse(frm["txtIDCabin"].ToString());
model.IDCruise = int.Parse(frm["txtIDCruise"].ToString());
model.SL = int.Parse(frm["txtSL"].ToString());
model.DaDung = int.Parse(frm["txtDaDung"].ToString());
model.MoTa = frm["txtMoTa"].ToString();
model.TrangThai = bool.Parse(frm["txtTrangThai"].ToString());
Session["TrungMa"] = "";
List <ProjectLibrary.Database.PromotionCodeCabin> del = db.PromotionCodeCabins.Where(c => c.Code == model.Code && c.IDCabin == model.IDCabin).ToList();
if (del.Count < 1)
{
db.PromotionCodeCabins.InsertOnSubmit(model);
db.SubmitChanges();
Session["TrungMa"] = "Thêm Thành Công!";
return(RedirectToAction("Index"));
}
else
{
Session["TrungMa"] = "TrungMa";
return(RedirectToAction("AddPromotion"));
}
}
catch (Exception ex)
{
return(Json(new { success = false, Message = ex.Message }));
}
}
return(RedirectToAction("AddPromotion"));
}
public JsonResult Delete(int id)
{
try
{
using (var db = new MyDbDataContext())
{
ProjectLibrary.Database.PromotionCodeCabin del = db.PromotionCodeCabins.FirstOrDefault(c => c.ID == id);
if (del != null)
{
//xóa hết hình ảnh của phòng này
db.PromotionCodeCabins.DeleteOnSubmit(del);
db.SubmitChanges();
return(Json(new { Result = "OK", Message = "Xóa mã thành công" }));
}
return(Json(new { Result = "ERROR", Message = "mã không tồn tại" }));
}
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", ex.Message }));
}
}
