public ActionResult Delete(string data)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
using (var dbTrans = dbConn.OpenTransaction(IsolationLevel.ReadCommitted))
if (asset.Delete)
{
try
{
string[] separators = { "@@" };
var listRowID = data.Split(separators, StringSplitOptions.RemoveEmptyEntries);
var delete = new CRM_Contract_Extra();
foreach (var item in listRowID)
{
delete.RowID = Int32.Parse(item);
dbConn.Delete(delete);
}
dbTrans.Commit();
}
catch (Exception ex)
{
return(Json(new { success = false, alert = ex.Message }));
}
return(Json(new { success = true }));
}
else
{
return(Json(new { success = false, alert = "You don't have permission to delete record" }));
}
}
public JsonResult GetExtraContractByType(string Type)
{
string text = "";
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
string nameID = "";
switch (Type)
{
case "GOI":
nameID = "GOI_CAC_DIEU_KHOAN_KHAC_GOI";
break;
case "GBANNER":
nameID = "GOI_CAC_DIEU_KHOAN_KHAC_GOI_BANNER";
break;
case "BANNER":
nameID = "THUONG_CAC_DIEU_KHOAN_KHAC";
break;
case "BAI":
nameID = "THUONG_CAC_DIEU_KHOAN_KHAC_BAI";
break;
case "FANPAGE":
nameID = "THUONG_CAC_DIEU_KHOAN_KHAC_FANPAGE";
break;
}
CRM_Contract_Extra extra = dbConn.Select <CRM_Contract_Extra>("NameID= {0}", nameID).FirstOrDefault();
if (extra != null)
{
text = extra.Content;
}
else
{
return(Json(new { success = false, content = "Không có dữ liệu" + Type }));
}
}
return(Json(new { success = true, content = text }));
}
public ActionResult Save_item(CRM_Contract_Extra req)
{
var rs = CRM_Contract_Extra.Save(req, currentUser.UserName);
return(Json(rs));
}
