public bool Update(IdentitySlide identity)
{
//Common syntax
var sqlCmd = @"M_Slide_Update";
//For parameters
var parameters = new Dictionary <string, object>
{
{ "@Id", identity.Id },
{ "@Name", identity.Name },
{ "@Code", identity.Code },
{ "@SlideType", identity.SlideType },
{ "@CssClass", identity.CssClass },
{ "@DelayTime", identity.DelayTime },
{ "@Configs", identity.Configs },
{ "@Status", identity.Status }
};
try
{
using (var conn = new SqlConnection(_connectionString))
{
MsSqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, sqlCmd, parameters);
}
}
catch (Exception ex)
{
var strError = "Failed to execute M_Slide_Update. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(true);
}
public IdentitySlide GetById(int Id)
{
var info = new IdentitySlide();
var sqlCmd = @"M_Slide_GetById";
var parameters = new Dictionary <string, object>
{
{ "@Id", Id }
};
try
{
using (var conn = new SqlConnection(_connectionString))
{
using (var reader = MsSqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, sqlCmd, parameters))
{
while (reader.Read())
{
info = ExtractSlideData(reader);
}
}
}
}
catch (Exception ex)
{
var strError = "Failed to execute M_Slide_GetById. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(info);
}
public int Insert(IdentitySlide identity)
{
//Common syntax
var sqlCmd = @"M_Slide_Insert";
var newId = 0;
//For parameters
var parameters = new Dictionary <string, object>
{
{ "@Name", identity.Name },
{ "@Code", identity.Code },
{ "@SlideType", identity.SlideType },
{ "@CssClass", identity.CssClass },
{ "@DelayTime", identity.DelayTime },
{ "@Configs", identity.Configs },
{ "@Status", identity.Status }
};
try
{
using (var conn = new SqlConnection(_connectionString))
{
var returnObj = MsSqlHelper.ExecuteScalar(conn, CommandType.StoredProcedure, sqlCmd, parameters);
newId = Convert.ToInt32(returnObj);
}
}
catch (Exception ex)
{
var strError = "Failed to execute M_Slide_Insert. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(newId);
}
private IdentitySlide ExtractCreateFormData(SlideCreateModel formData)
{
var myIdetity = new IdentitySlide();
myIdetity.Name = formData.Name;
myIdetity.Code = formData.Code;
myIdetity.SlideType = formData.SlideType;
myIdetity.CssClass = formData.CssClass;
myIdetity.DelayTime = formData.DelayTime;
myIdetity.Status = formData.Status;
return(myIdetity);
}
private SlideEditModel RenderEditModel(IdentitySlide identity)
{
var editModel = new SlideEditModel();
editModel.Id = identity.Id;
editModel.Name = identity.Name;
editModel.Code = identity.Code;
editModel.SlideType = identity.SlideType;
editModel.CssClass = identity.CssClass;
editModel.DelayTime = identity.DelayTime;
editModel.Status = identity.Status;
return(editModel);
}
private IdentitySlide ExtractSlideData(IDataReader reader)
{
var record = new IdentitySlide();
//Seperate properties
record.Id = Utils.ConvertToInt32(reader["Id"]);
record.Name = reader["Name"].ToString();
record.Code = reader["Code"].ToString();
record.SlideType = reader["SlideType"].ToString();
record.CssClass = reader["CssClass"].ToString();
record.DelayTime = Utils.ConvertToInt32(reader["DelayTime"]);
record.Configs = reader["Configs"].ToString();
record.Status = Utils.ConvertToInt32(reader["Status"]);
return(record);
}
//[AccessRoleChecker]
public ActionResult Index(ManageSlideModel model)
{
int currentPage = 1;
int pageSize = SystemSettings.DefaultPageSize;
if (string.IsNullOrEmpty(model.SearchExec))
{
model.SearchExec = "Y";
if (!ModelState.IsValid)
{
ModelState.Clear();
}
}
if (Request["Page"] != null)
{
currentPage = Utils.ConvertToInt32(Request["Page"], 1);
}
var filter = new IdentitySlide
{
Keyword = !string.IsNullOrEmpty(model.Keyword) ? model.Keyword.Trim() : null,
Status = model.Status == null ? -1 : (int)model.Status
};
try
{
model.SearchResults = _mainStore.GetByPage(filter, currentPage, SystemSettings.DefaultPageSize);
if (model.SearchResults != null && model.SearchResults.Count > 0)
{
model.TotalCount = model.SearchResults[0].TotalCount;
model.CurrentPage = currentPage;
model.PageSize = pageSize;
}
}
catch (Exception ex)
{
this.AddNotification(NotifSettings.Error_SystemBusy, NotificationType.ERROR);
logger.Error("Failed to get data because: " + ex.ToString());
return(View(model));
}
return(View(model));
}
public List <IdentitySlide> GetAll(IdentitySlide filter, int currentPage, int pageSize)
{
//Common syntax
var sqlCmd = @"M_Slide_GetAll";
List <IdentitySlide> listData = null;
//For paging
int offset = (currentPage - 1) * pageSize;
//For parameters
var parameters = new Dictionary <string, object>
{
{ "@Name", filter.Name },
{ "@Code", filter.Code },
{ "@Status", filter.Status },
{ "@TuNgay", filter.FromDate },
{ "@DenNgay", filter.ToDate },
{ "@Offset", offset },
{ "@PageSize", pageSize },
};
try
{
using (var conn = new SqlConnection(_connectionString))
{
using (var reader = MsSqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, sqlCmd, parameters))
{
listData = ParsingListSlideFromReader(reader);
}
}
}
catch (Exception ex)
{
var strError = "Failed to execute M_Slide_GetAll. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(listData);
}
