[Authorize(Roles = "Admin,Personnel")] //Personnel
public ActionResult Insert(string ProId, string Name, string Email, string Point,
string Content, string Date, string Active, string Level)
{
CommentProduc_Model model = new CommentProduc_Model();//gọi model data
model.ProId = Convert.ToInt32(ProId);
model.Name = Name;
model.Email = Email;
model.Point = Convert.ToInt32(Point);
model.Active = Convert.ToInt32(Active);
model.Content = Content;
model.Date = DateTime.Now;
model.Level = Level;
if (connect_entity.CommentProducs.FirstOrDefault
(x => x.Content == Content) == null) // kiểm tra không được trùng tên
{
Connect.Create(model); //gọi service lưu
Resurt = 1;
}
else
{
Resurt = 0;
}
return(Json(Resurt, JsonRequestBehavior.AllowGet));
}
[Authorize(Roles = "Admin,Personnel")] //Personnel
public ActionResult Update(string Id, string ProId, string Name, string Email, string Point,
string Content, string Date, string Active, string Level)
{
CommentProduc_Model model = new CommentProduc_Model();//gọi model data
model.Id = Convert.ToInt32(Id);
model.ProId = Convert.ToInt32(ProId);
model.Name = Name;
model.Email = Email;
model.Point = Convert.ToInt32(Point);
model.Active = Convert.ToInt32(Active);
model.Content = Content;
model.Date = DateTime.Now;
model.Level = Level;
Connect.Update(model); //gọi service lưu
Resurt = 1;
return(Json(Resurt, JsonRequestBehavior.AllowGet));
}
public IList <CommentProduc_Model> GetId(CommentProduc_Model model)
{
IList <CommentProduc_Model> result = new List <CommentProduc_Model>();
result = Connect_Enttity.CommentProducs.Where(x => x.Id == model.Id).Select(x => new CommentProduc_Model
{
Id = x.Id,
ProId = (int)(x.ProId),
Name = x.Name,
Email = x.Email,
Point = (int)(x.Point),
Content = x.Content,
Date = Convert.ToDateTime(x.Date),
Active = (int)(x.Active),
Level = x.Level
}).ToList();
return(result);
}
public void Update(CommentProduc_Model model)
{
var data = Connect_Enttity.CommentProducs.FirstOrDefault(x => x.Id == model.Id);
if (data != null)
{
data.ProId = (int)(model.ProId);
data.Name = model.Name;
data.Email = model.Email;
data.Point = (int)(model.Point);
data.Content = model.Content;
data.Date = Convert.ToDateTime(model.Date);
data.Active = (int)(model.Active);
data.Level = model.Level;
Connect_Enttity.SaveChanges();
Dispose();
}
}
public void Create(CommentProduc_Model model)
{
var data = Connect_Enttity.CommentProducs.FirstOrDefault(x => x.Id == model.Id);
if (data == null)
{
var entity = new CommentProduc();
entity.ProId = Convert.ToInt16(model.ProId);
entity.Name = model.Name;
entity.Email = model.Email;
entity.Point = (int)(model.Point);
entity.Content = model.Content;
entity.Date = Convert.ToDateTime(model.Date);
entity.Active = (int)(model.Active);
entity.Level = model.Level;
Connect_Enttity.CommentProducs.Add(entity);
Connect_Enttity.SaveChanges();
Dispose();
}
}
public IEnumerable <CommentProduc_Model> ReadID(CommentProduc_Model model)
{
return(GetId(model));
}
