public bool AddNewGroup(Tbl_Group Group)
{
try
{
//check if user already exists
var res = from t in db.Tbl_Group
where t.Group_ID == Group.Group_ID
select t;
if (res.Count() == 0)
{
db.Tbl_Group.Add(Group);
db.SaveChanges();
return(true);
}
else
{
Tbl_Group grp = res.FirstOrDefault();
grp.Active = Group.Active;
grp.Description = Group.Description;
grp.GroupName = Group.GroupName;
grp.LastUpdateDate = Group.LastUpdateDate;
grp.LastUpdateTime = Group.LastUpdateTime;
grp.LastUpdateUser_ID = Group.LastUpdateUser_ID;
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
//_logRepository.Insert(new Log() { Type = LogType.Error, Priority = LogPriority.High, Description = ex.Message, PageUrl = "AddNewGroup", CreatedOn = DateTime.Now.ToString("yyyy-MM-dd HH:mm"), UpdatedOn = DateTime.Now.ToString("yyyy-MM-dd HH:mm") });
return(false);
}
}
public ActionResult Create(FormCollection form)
{
using (var Db = new ProjectWebEntities())
{
var gr = new Tbl_Group();
try
{
gr.Name = form["groupname"];
gr.Description = form["description"];
//gr.UserID = WebContext.Current.UserId;
Db.Tbl_Group.Add(gr);
Db.SaveChanges();
ViewBag.Message = "Successful";
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
string err = "";
var exs = dbEx.EntityValidationErrors;
foreach (var e in dbEx.EntityValidationErrors)
{
foreach (var erEx in e.ValidationErrors)
{
err += erEx.ErrorMessage + " | ";
}
}
//ViewBag.Message = err;
logger.Error("An Error Happened! ", dbEx);
}
return(RedirectToAction("Index", "RightGroup"));
}
}
public ActionResult SubmitGroup(GroupModel model)
{
HttpSessionStateBase session = HttpContext.Session;
try
{
Tbl_Group tg = new Tbl_Group();
tg.GroupName = model.GroupName;
tg.Active = model.IsActive_ID;
tg.Description = model.Description;
tg.Group_ID = model.Group_ID;
tg.LastUpdateUser_ID = Convert.ToInt32(session["UserID"]);
tg.LastUpdateDate = DateTime.Now.ToString("yyyy-MM-dd");
tg.LastUpdateTime = DateTime.Now.ToString("HH:mm");
if (_groupService.AddNewGroup(tg))
{
var gridModel = new DataSourceResult
{
ExtraData = new GroupModel
{
Message = Message.OperationSuccessful,
MessageColor = "green"
},
Total = 1
};
return(Json(gridModel));
}
else
{
var gridModel = new DataSourceResult
{
ExtraData = new GroupModel
{
Message = Message.OperationUnsuccessful,
MessageColor = "red"
},
Total = 1
};
return(Json(gridModel));
}
}
catch (Exception ex)
{
var gridModel = new DataSourceResult
{
ExtraData = new GroupModel
{
Message = Message.OperationUnsuccessful,
MessageColor = "red"
},
Total = 1
};
return(Json(gridModel));
}
}
public ActionResult GroupEdit(int id)
{
Tbl_Group q = new Tbl_Group();
q = db.Tbl_Group.Where(a => a.Group_ID == id).SingleOrDefault();
GroupAddModel model = new GroupAddModel();
model.ID = q.Group_ID;
model.Name = q.Group_Name;
return(View(model));
}
public ActionResult GroupAdd(GroupAddModel model)
{
Tbl_Group q = new Tbl_Group();
q.Group_Name = model.Name;
db.Tbl_Group.Add(q);
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
return(RedirectToAction("GroupList", "Setting"));
}
else
{
return(View());
}
}
public void EditGroup(Tbl_Group Group)
{
//try
//{
// var res = from t in _GroupRepository.Table
// where t.Id == Group.Id
// select t;
// if (res.Count() > 0)
// {
// _GroupRepository.Update(Group);
// }
//}
//catch (Exception ex)
//{
// _logRepository.Insert(new Log() { Type = LogType.Error, Priority = LogPriority.High, Description = ex.Message, PageUrl = "EditGroup", CreatedOn = DateTime.Now.ToString("yyyy-MM-dd HH:mm"), UpdatedOn = DateTime.Now.ToString("yyyy-MM-dd HH:mm") });
//}
}
public ActionResult GroupEdit(LanguageAddModel model)
{
Tbl_Group q = new Tbl_Group();
q = db.Tbl_Group.Where(a => a.Group_ID == model.ID).SingleOrDefault();
q.Group_Name = model.Name;
db.Entry(q).State = System.Data.Entity.EntityState.Modified;
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
return(RedirectToAction("GroupList", "Setting"));
}
else
{
return(View());
}
}
public ActionResult destroyGroup([DataSourceRequest] DataSourceRequest request, Tbl_Group model)
{
using (var Db = new ProjectWebEntities())
{
try
{
var gr = Db.Tbl_Group.SingleOrDefault(w => w.Id == model.Id);
Db.Tbl_Group.Remove(gr);
Db.SaveChanges();
}
catch (Exception ex)
{
logger.Error("An Error Happened! ", ex);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
}
