public ActionResult Delete_Org_AvoidCallingTime(string data)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
using (var dbTrans = dbConn.OpenTransaction(IsolationLevel.ReadCommitted))
if (asset.Delete)
{
int success = 0;
int error = 0;
try
{
string[] separators = { "@@" };
var listRowID = data.Split(separators, StringSplitOptions.RemoveEmptyEntries);
var data1 = new DC_Org_AvoidCallingTime();
foreach (var item in listRowID)
{
data1.Id = Int32.Parse(item);
dbConn.Delete(data1);
}
dbTrans.Commit();
success++;
}
catch (Exception ex)
{
return(Json(new { success = false, alert = ex.Message }));
}
return(Json(new { success = true, totalSuccess = success, totalError = error }));
}
else
{
return(Json(new { success = false, alert = "You don't have permission to delete record" }));
}
}
public ActionResult Read_Org_AvoidCallingTime([DataSourceRequest] DataSourceRequest request, string OrganizationID)
{
if (asset.View)
{
var data = new List <DC_Org_AvoidCallingTime>();
data = DC_Org_AvoidCallingTime.GetDC_Org_AvoidCallingTime(OrganizationID);
return(Json(data.ToDataSourceResult(request)));
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult Save_Org_AVoidCallingTime(string AvoidCallTime, string TimeFrameDetail, string OrganizationID)
{
if (asset.Create)
{
if (!string.IsNullOrEmpty(AvoidCallTime) && !string.IsNullOrEmpty(TimeFrameDetail))
{
try
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
using (var dbTrans = dbConn.OpenTransaction(IsolationLevel.ReadCommitted))
{
var checkexist = dbConn.Select <DC_Org_AvoidCallingTime>("SELECT * FROM DC_Org_AvoidCallingTime WHERE HeaderID = " + AvoidCallTime + " AND DetailHeaderID = " + TimeFrameDetail + " AND OrgID = '" + OrganizationID + "'");
if (checkexist.Count <= 0)
{
var data = new DC_Org_AvoidCallingTime();
data.OrgID = OrganizationID;
data.HeaderID = AvoidCallTime;
data.DetailHeaderID = TimeFrameDetail;
data.RowCreatedTime = DateTime.Now;
data.RowCreatedUser = currentUser.UserName;
data.RowLastUpdatedTime = DateTime.Parse("1900-01-01");
data.RowLastUpdatedUser = "";
dbConn.Save(data);
dbTrans.Commit();
return(Json(new { success = true }));
}
else
{
return(Json(new { success = false, error = "Avoid Call Time is exists." }));
}
}
}
catch (Exception ex)
{
return(Json(new { success = false, error = ex }));
}
}
else
{
return(Json(new { success = false, error = "Please input field (*)" }));
}
}
else
{
return(Json(new { success = false, error = "You don't have permission to add record" }));
}
}
