private AccessoriesInfo GetImagesValues(DataRow dr) { AccessoriesInfo Accessories = new AccessoriesInfo(); Accessories.AttachmentId = Convert.ToInt32(dr["AttachmentId"]); if (!dr.IsNull("RefId")) { Accessories.RefId = Convert.ToInt32(dr["RefId"]); } if (!dr.IsNull("RefType")) { Accessories.RefType = Convert.ToInt32(dr["RefType"]); } if (!dr.IsNull("RefCategory")) { Accessories.RefCategory = Convert.ToString(dr["RefCategory"]); } if (!dr.IsNull("AttachmentName")) { Accessories.AttachmentName = Convert.ToString(dr["AttachmentName"]); } if (!dr.IsNull("UniqueAttachmentId")) { Accessories.UniqueAttachmentId = Convert.ToString(dr["UniqueAttachmentId"]); } return(Accessories); }
public AccessoriesViewModel() { Accessories = new AccessoriesInfo(); Images = new List <AccessoriesInfo>(); FriendlyMessage = new List <FriendlyMessage>(); }
public List <SqlParameter> SetValuesInAccessories(AccessoriesInfo accessories) { List <SqlParameter> sqlParam = new List <SqlParameter>(); if (accessories.AttachmentId != 0) { sqlParam.Add(new SqlParameter("AttachmentId", accessories.AttachmentId)); } else { sqlParam.Add(new SqlParameter("CreatedDate", accessories.CreatedDate)); sqlParam.Add(new SqlParameter("CreatedBy", accessories.CreatedBy)); } sqlParam.Add(new SqlParameter("RefId", accessories.RefId)); Logger.Debug("Accessories Controller RefId:" + accessories.RefId); sqlParam.Add(new SqlParameter("AttachmentName", accessories.AttachmentName)); Logger.Debug("Accessories Controller AttachmentName:" + accessories.AttachmentName); sqlParam.Add(new SqlParameter("UniqueAttachmentId", accessories.UniqueAttachmentId.Replace("/Upload/", string.Empty))); if (accessories.RefTypeName == "Hotel") { sqlParam.Add(new SqlParameter("@RefType", Attachment.Hotel)); } if (accessories.RefTypeName == "User") { sqlParam.Add(new SqlParameter("@RefType", Attachment.User)); } if (accessories.RefTypeName == "SightSeeing") { sqlParam.Add(new SqlParameter("@RefType", Attachment.SightSeeing)); } if (accessories.RefTypeName == "Package") { sqlParam.Add(new SqlParameter("@RefType", Attachment.Package)); } sqlParam.Add(new SqlParameter("RefCategory", accessories.RefCategory)); Logger.Debug("Accessories Controller RefCategory:" + accessories.RefCategory); sqlParam.Add(new SqlParameter("UpdatedBy", accessories.UpdatedBy)); sqlParam.Add(new SqlParameter("UpdatedDate", accessories.UpdatedDate)); return(sqlParam); }
public int Insert(AccessoriesInfo accessories) { return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInAccessories(accessories), Storeprocedures.spInsertAttachment.ToString(), CommandType.StoredProcedure))); }