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