public int DeleteUserEventAndAttandanceById(int UserEventID)
{
tbl_UserEvent tbl_UserEvent = db.tbl_UserEvent.Find(UserEventID);
var result = db.Database.ExecuteSqlCommand("exec proc_as_DeleteAttandanceAndUserEvent @UeID,@UserID",
new SqlParameter("@UeID", UserEventID),
new SqlParameter("@UserID", tbl_UserEvent.UserID));
return(result);
}
public long CreateUserEvent(UserEventCreateViewModel createModel)
{
var result = CheckFromDateToDate(createModel.UeDateExpires.Value, createModel.UeWillExpires.Value, createModel.UserID.Value);
if (result == 1)
{
try
{
var model = new tbl_UserEvent();
model.EventID = createModel.EventID;
model.UserID = createModel.UserID;
model.UeCount = createModel.UeType; //Phep hay Cong tac
model.UeOk = false;
model.UeCreateDate = DateTime.Now;
model.UeDateExpires = createModel.UeDateExpires;
model.UeNote = createModel.UeNote;
model.UeWillExpires = createModel.UeWillExpires;
model.UeCount = createModel.UeType;
db.tbl_UserEvent.Add(model);
db.SaveChanges();
int UeId = model.UeID;
if (UeId > 0)
{
try
{
AttandanceDAL modelAtt = new AttandanceDAL();
createModel.UeID = model.UeID;
var kq = modelAtt.CheckCongThem(createModel);
}catch (Exception ex)
{
throw ex;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
return(result);
}
