public IdentitySlideItem GetSlideItemById(int Id)
{
var info = new IdentitySlideItem();
var sqlCmd = @"M_SlideItem_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 = ExtractSlideItemData(reader);
}
}
}
}
catch (Exception ex)
{
var strError = "Failed to execute M_SlideItem_GetById. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(info);
}
public bool UpdateSlideItem(IdentitySlideItem identity)
{
//Common syntax
var sqlCmd = @"M_SlideItem_Update";
//For parameters
var parameters = new Dictionary <string, object>
{
{ "@Id", identity.Id },
{ "@SlideId", identity.SlideId },
{ "@Title", identity.Title },
{ "@Description", identity.Description },
{ "@ImageUrl", identity.ImageUrl },
{ "@Link", identity.Link },
{ "@LinkAction", identity.LinkAction },
{ "@SortOrder", identity.SortOrder },
{ "@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_SlideItem_Update. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(true);
}
private SlideItemUpdateModel RenderEditSlideItemModel(IdentitySlideItem identity)
{
var editModel = new SlideItemUpdateModel();
editModel.Id = identity.Id;
editModel.Title = identity.Title;
editModel.SlideId = identity.SlideId;
editModel.Description = identity.Description;
editModel.CurrentImageUrl = identity.ImageUrl;
editModel.Link = identity.Link;
editModel.LinkAction = identity.LinkAction;
editModel.SortOrder = identity.SortOrder;
editModel.Status = identity.Status;
return(editModel);
}
private IdentitySlideItem ExtractSlideItemData(IDataReader reader)
{
var record = new IdentitySlideItem();
//Seperate properties
record.Id = Utils.ConvertToInt32(reader["Id"]);
record.SlideId = Utils.ConvertToInt32(reader["SlideId"]);
record.Title = reader["Title"].ToString();
record.Description = reader["Description"].ToString();
record.ImageUrl = reader["ImageUrl"].ToString();
record.Link = reader["Link"].ToString();
record.LinkAction = Utils.ConvertToInt32(reader["LinkAction"]);
record.SortOrder = Utils.ConvertToInt32(reader["SortOrder"]);
record.CreatedDate = reader["CreatedDate"] == DBNull.Value ? null : (DateTime?)reader["CreatedDate"];
record.Status = Utils.ConvertToInt32(reader["Status"]);
return(record);
}
private IdentitySlideItem ExtractUpdateSlideItemFormData(SlideItemUpdateModel formData)
{
var coverImg = string.Empty;
if (formData.ImageUpload != null)
{
if (formData.ImageUpload[0] != null)
{
var apiReturn = CdnServices.UploadImagesAsync(formData.ImageUpload, formData.SlideId.ToString(), "Slide").Result;
if (apiReturn != null)
{
if (apiReturn.Data != null)
{
var resultData = JsonConvert.DeserializeObject <List <string> >(apiReturn.Data.ToString());
var returnData = new List <string>();
if (resultData.HasData())
{
coverImg = resultData[0];
}
}
}
}
}
if (string.IsNullOrEmpty(coverImg))
{
coverImg = formData.CurrentImageUrl;
}
var myIdetity = new IdentitySlideItem();
myIdetity.Id = formData.Id;
myIdetity.Title = formData.Title;
myIdetity.SlideId = formData.SlideId;
myIdetity.Description = formData.Description;
myIdetity.ImageUrl = coverImg;
myIdetity.Link = formData.Link;
myIdetity.LinkAction = formData.LinkAction;
myIdetity.SortOrder = formData.SortOrder;
myIdetity.Status = formData.Status;
return(myIdetity);
}
public int InsertSlideItem(IdentitySlideItem identity)
{
//Common syntax
var sqlCmd = @"M_SlideItem_Insert";
var newId = 0;
//For parameters
var parameters = new Dictionary <string, object>
{
{ "@SlideId", identity.SlideId },
{ "@Title", identity.Title },
{ "@Description", identity.Description },
{ "@ImageUrl", identity.ImageUrl },
{ "@Link", identity.Link },
{ "@LinkAction", identity.LinkAction },
{ "@SortOrder", identity.SortOrder },
{ "@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_SlideItem_Insert. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(newId);
}
