public ActionResult SaveResult(string SubID, string Description)
{
if (asset.View)
{
if (string.IsNullOrEmpty(SubID) || string.IsNullOrEmpty(Description))
{
return(Json(new { success = false, error = "Please input data" }));
}
else
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
using (var dbTrans = dbConn.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
var data = new DC_Telesales_ResultList();
var lastId = DC_Telesales_ResultList.GetLastID();
string a = "";
if (lastId == null)
{
a = "R000";
}
else
{
var num = lastId.Id.Substring(2, lastId.Id.ToString().Length - 2);
var id = Int16.Parse(num.ToString()) + 1;
a = "R" + String.Format("{0:000}", id);
}
data.Id = a;
data.Active = true;
data.SubId = SubID;
data.Description = Description;
data.RowCreatedTime = DateTime.Now;
data.RowCreatedUser = currentUser.UserName;
data.RowLastUpdatedTime = DateTime.Parse("1900-01-01");
data.RowLastUpdatedUser = "";
dbConn.Insert(data);
dbTrans.Commit();
return(Json(new { success = true }));
}
catch (Exception e)
{
dbTrans.Rollback();
return(Json(new { success = false, error = e.Message }));
}
}
}
}
else
{
ModelState.AddModelError("", "You don't have permission to create record ");
return(Json(new { success = false, error = "You don't have permission to create record" }));
}
}
public ActionResult Remove(string data)
{
if (asset.Delete)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
using (var dbTrans = dbConn.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
string[] separators = { "@@" };
var listRowID = data.Split(separators, StringSplitOptions.RemoveEmptyEntries);
foreach (var item in listRowID)
{
var dataCheck = new List <DC_Telesales_ResultList>();
dataCheck = dbConn.Select <DC_Telesales_ResultList>("Select * From DC_Telesales_ResultList Where SubId = '" + item + "'").ToList();
if (dataCheck.Count > 0)
{
return(Json(new { success = false, message = "Can't delete record: Self -own" }));
}
else
{
DC_Telesales_ResultList check = new DC_Telesales_ResultList();
check.Id = item;
dbConn.Delete(check);
}
}
dbTrans.Commit();
}
catch (Exception e)
{
return(Json(new { success = false, message = e }));
}
return(Json(new { success = true }));
}
}
else
{
return(Json(new { success = false, message = "You don't have permission to delete record" }));
}
}
public ActionResult Create([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <DC_Telesales_ResultList> listResult)
{
if (asset.View)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
using (var dbTrans = dbConn.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
if (listResult != null && ModelState.IsValid)
{
foreach (var item in listResult)
{
if (String.IsNullOrEmpty(item.Description))
{
ModelState.AddModelError("", "Please input field [Description]");
return(Json(listResult.ToDataSourceResult(request, ModelState)));
}
var checkDescription = dbConn.Select <DC_Telesales_ResultList>("SELECT * FROM DC_Telesales_ResultList WHERE Description = '" + item.Description + "'");
if (checkDescription.Count > 0)
{
ModelState.AddModelError("", "[Description] exist in system");
return(Json(listResult.ToDataSourceResult(request, ModelState)));
}
var lastId = DC_Telesales_ResultList.GetLastID();
string a = "";
if (lastId == null)
{
a = "R000";
}
else
{
var num = lastId.Id.Substring(2, lastId.Id.ToString().Length - 2);
var id = Int16.Parse(num.ToString()) + 1;
a = "R" + String.Format("{0:000}", id);
}
if (!string.IsNullOrEmpty(item.SubId))
{
item.SubId = item.SubId;
}
else
{
item.SubId = "0";
}
if (item.Id == item.SubId)
{
ModelState.AddModelError("", "Can't update this record: Self -own");
return(Json(listResult.ToDataSourceResult(request, ModelState)));
}
item.Active = item.Active;
item.Id = a;
item.Description = item.Description;
item.RowCreatedUser = currentUser.UserName;
item.RowCreatedTime = DateTime.Now;
item.RowLastUpdatedTime = DateTime.Parse("1900-01-01");
item.RowLastUpdatedUser = "";
dbConn.Insert(item);
dbTrans.Commit();
return(Json(new { success = true }));
}
return(Json(listResult.ToDataSourceResult(request, ModelState)));
}
else
{
ModelState.AddModelError("error", "");
return(Json(new { success = false }));
}
}
catch (Exception e)
{
dbTrans.Rollback();
return(Json(new { success = false, error = e.Message }));
}
}
}
else
{
ModelState.AddModelError("", "You don't have permission to create record ");
return(Json(listResult.ToDataSourceResult(request, ModelState)));
}
}
