public ActionResult Remove(string data)
{
if (asset.View)
{
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)
{
DC_TeleSale_AnnouncementByCS check = new DC_TeleSale_AnnouncementByCS();
check.Id = int.Parse(item);
dbConn.Delete(check);
}
dbTrans.Commit();
}
catch (Exception e)
{
log.Error(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 SaveAnnouncementTeleSale(string Message, string Impact)
{
if (asset.View)
{
if (string.IsNullOrEmpty(Message) || string.IsNullOrEmpty(Impact))
{
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_TeleSale_AnnouncementByCS();
data.Impact = Impact;
data.Message = Message;
data.RowCreatedTime = DateTime.Now;
data.RowCreatedUser = currentUser.UserName;
data.RowLastUpdatedTime = DateTime.Parse("1900-01-01");
data.RowLastUpdatedUser = "";
data.Status = true;
dbConn.Insert(data);
dbTrans.Commit();
return(Json(new { success = true }));
}
catch (Exception e)
{
dbTrans.Rollback();
return(Json(new { success = false, error = e.Message }));
}
}
}
}
else
{
return(Json(new { success = false, error = "You don't have permission to create record " }));
}
}