public int Update(CmsSupport model)
{
return((int)SqlHelper.ExecuteScalar(SqlConnection, CommonHelper.Config.GetFullyQualifiedName("CmsSupport_Update")
, model.Id, CommonHelper.Null.GetNull(model.Name), CommonHelper.Null.GetNull(model.Email), CommonHelper.Null.GetNull(model.Phone), model.IsRead, CommonHelper.Null.GetNull(model.ContentSent),
model.IsConfirm, CommonHelper.Null.GetNull(model.ContentConfirm)
, CommonHelper.Null.GetNull(model.ConfirmBy), CommonHelper.Null.GetNull(model.CreatedDate)));
}
public int Insert(CmsSupport model)
{
var deciResult = SqlHelper.ExecuteScalar(SqlConnection, CommonHelper.Config.GetFullyQualifiedName("CmsSupport_Insert")
, CommonHelper.Null.GetNull(model.Name), CommonHelper.Null.GetNull(model.Email), CommonHelper.Null.GetNull(model.Phone), model.IsRead, CommonHelper.Null.GetNull(model.ContentSent),
model.IsConfirm, CommonHelper.Null.GetNull(model.ContentConfirm)
, CommonHelper.Null.GetNull(model.ConfirmBy), CommonHelper.Null.GetNull(model.CreatedDate));
return(CommonHelper.Convert.ConvertToInt32(deciResult));
}
public ActionResult Edit(CmsSupport sysModel)
{
try
{
#region Redirect Request
int succcess = 0;
if (sysModel.Id > 0)
{
var objTemporary = _sysAction.GetById(sysModel.Id);
if (AuthorizeUser.IsAction(Ultity.Constant.Edit) || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll))
{
sysModel.CreatedBy = objTemporary.CreatedBy;
sysModel.ModifiedDate = DateTime.Now;
sysModel.ModifiedBy = WebSecurity.CurrentUserId;
sysModel.CreatedDate = objTemporary.CreatedDate;
sysModel.IsRead = true;
succcess = _sysAction.Update(sysModel);
}
else
{
succcess = 1;
}
}
else
{
if (AuthorizeUser.IsAction(Ultity.Constant.Add) || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll))
{
sysModel.CreatedBy = WebSecurity.CurrentUserId;
sysModel.ModifiedBy = null;
sysModel.CreatedDate = DateTime.Now;
sysModel.ModifiedDate = null;
succcess = _sysAction.Insert(sysModel);
}
else
{
succcess = 1;
}
}
if (succcess > 0)
{
return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success }));
}
return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail }));
#endregion Redirect Request
}
catch (Exception exception)
{
Ultity.TFunction.WriteToLog(exception);
}
return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail }));
}
public ActionResult GetById(int?id)
{
var objTemporary = new CmsSupport();
try
{
int editId = id.HasValue ? id.Value : 0;
if (editId > 0)
{
string sWhere = " Id IN (" + id.ToString() + ") ";
string sSet = "IsRead = 1";
new SysAdminAction <CmsSupport>().Updates(sSet, sWhere);
objTemporary = _sysAction.GetById(editId);
}
return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success, Data = objTemporary }));
}
catch (Exception exception)
{
Ultity.TFunction.WriteToLog(exception);
return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail }));
}
}
