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); }