public ActionResult Team_Update([DataSourceRequest] DataSourceRequest request,
[Bind(Prefix = "models")] IEnumerable <CRM_Team> listTeam)
{
var dbConn = Helpers.OrmliteConnection.openConn();
IEnumerable <CRM_Team> u = new CRM_Team[] { };
if (asset.Create)
{
if (listTeam != null)
{
var w = new CRM_Team();
foreach (var team in listTeam)
{
var list = dbConn.Select <CRM_Team>(s => s.ID == team.ID).SingleOrDefault(); // CRM_Team.GetCRM_Team(team.ID);
list.LastUpdatedUser = currentUser.UserName;
list.LastUpdatedDateTime = DateTime.Now;
list.TeamID = team.TeamID;
list.Manager = team.Manager;
list.TeamName = team.TeamName;
list.FKUnit = team.FKUnit;
list.Active = team.Active;
dbConn.Update(list);
}
return(Json(new { success = true }));
}
ModelState.AddModelError("", "Model not valid");
return(Json(u.ToDataSourceResult(request, ModelState)));
}
else
{
ModelState.AddModelError("", "You don't have permission to create record");
return(Json(u.ToDataSourceResult(request, ModelState)));
}
}
public ActionResult getListTeam()
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
var data = CRM_Team.GetAllCRM_Teams();
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Team_Create([DataSourceRequest] DataSourceRequest request,
[Bind(Prefix = "models")] IEnumerable <CRM_Team> listTeam)
{
var dbConn = Helpers.OrmliteConnection.openConn();
IEnumerable <CRM_Team> u = new CRM_Team[] { };
if (asset.Create)
{
if (listTeam != null)
{
foreach (var team in listTeam)
{
var _team = dbConn.Select <CRM_Team>(s => s.ID == team.TeamID).SingleOrDefault(); //CRM_Team.GetCRM_Team(team.TeamID);
if (_team != null)
{
ModelState.AddModelError("", "TeamID is already exist: " + team.TeamID);
return(Json(listTeam.ToDataSourceResult(request, ModelState)));
}
var w = new CRM_Team();
if (w.TeamName == null)
{
w.TeamName = "";
}
w.TeamID = team.TeamID;
w.Manager = team.Manager;
w.TeamName = team.TeamName;
w.FKUnit = team.FKUnit;
w.Active = true;
w.CreatedDatetime = DateTime.Now;
w.CreatedUser = currentUser.UserName;
w.LastUpdatedUser = "";
w.LastUpdatedDateTime = DateTime.Parse("1900-01-01");
dbConn.Save(w);
}
return(Json(new { success = true }));
}
ModelState.AddModelError("", "Model not valid");
return(Json(u.ToDataSourceResult(request, ModelState)));
}
else
{
ModelState.AddModelError("", "You don't have permission to create record");
return(Json(u.ToDataSourceResult(request, ModelState)));
}
}
