internal static void FillFromReader(ProductImage ProductImage, SqlDataReader reader)
{
int colIndex = 0;
colIndex = reader.GetOrdinal(CN_PROD_IMAGE_ID);
if (!reader.IsDBNull(colIndex))
ProductImage.ID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_PROD_PRODUCT_ID);
if (!reader.IsDBNull(colIndex))
ProductImage.ProductID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_PROD_IMAGE_NAME);
if (!reader.IsDBNull(colIndex))
ProductImage.Image = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_PROD_IMAGE_IS_COVER_IMAGE);
if (!reader.IsDBNull(colIndex))
ProductImage.IsCoverImage = reader.GetBoolean(colIndex);
colIndex = reader.GetOrdinal(ECommerceDataMapperBase.CN_ECO_LAN_NAME);
if (!reader.IsDBNull(colIndex))
ProductImage.ImageCaption = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_PROD_IMAGE_IS_DELETED);
if (!reader.IsDBNull(colIndex))
ProductImage.IsDeleted = reader.GetBoolean(colIndex);
colIndex = reader.GetOrdinal(ECommerceDataMapperBase.CN_ECO_LAN_LAN_ID);
if (!reader.IsDBNull(colIndex))
ProductImage.LanguageID = reader.GetInt32(colIndex);
}
internal static int Add(ProductImage entity)
{
ProductImage ProductImageEntity = (ProductImage)(entity);
using (SqlConnection sqlConnection = new SqlConnection(CMSCoreBase.CMSCoreConnectionString))
{
SqlCommand sqlCommand = new SqlCommand(SN_PRODUCT_IMAGE_ADD, sqlConnection);
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter sqlParameter = null;
sqlParameter = new SqlParameter(PN_PROD_IMAGE_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Output;
sqlParameter.Value = ProductImageEntity.ID;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_PROD_PRODUCT_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = ProductImageEntity.ProductID;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_PROD_IMAGE_NAME, System.Data.SqlDbType.NVarChar);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = ProductImageEntity.Image;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_PROD_IMAGE_IS_COVER_IMAGE, System.Data.SqlDbType.Bit);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = ProductImageEntity.IsCoverImage;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_PROD_IMAGE_CAPTION, System.Data.SqlDbType.NVarChar);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = ProductImageEntity.ImageCaption;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(ECommerceDataMapperBase.PN_MODULE_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = (int)CMSEnums.ECommerceModule.ProductImage;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(ECommerceDataMapperBase.PN_ECO_LAN_LAN_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = ProductImageEntity.LanguageID;
sqlCommand.Parameters.Add(sqlParameter);
try
{
sqlCommand.Connection.Open();
sqlCommand.ExecuteNonQuery();
sqlCommand.Connection.Close();
ProductImageEntity.ID = Convert.ToInt32(sqlCommand.Parameters[PN_PROD_IMAGE_ID].Value);
}
catch (Exception ex)
{
throw ex;
}
}
return ProductImageEntity.ID;
}
internal static ProductImage GetProductImage(List<ProductImage> ProductImages, SqlDataReader reader)
{
int colIndex = 0;
colIndex = reader.GetOrdinal(CN_PROD_IMAGE_ID);
int value = reader.GetInt32(colIndex);
ProductImage ProductImage = ProductImages.Where(c => c.ID == value).FirstOrDefault();
if (ProductImage == null)
{
ProductImage = new ProductImage();
ProductImages.Add(ProductImage);
}
return ProductImage;
}
internal static ProductImage GetProductImage(int id, int languageID)
{
ProductImage productImage = null;
using (SqlConnection sqlConnection = new SqlConnection(CMSCoreBase.CMSCoreConnectionString))
{
SqlCommand sqlCommand = new SqlCommand(SN_PRODUCT_IMAGE_GET_BY_ID, sqlConnection);
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter sqlParameter = null;
sqlParameter = new SqlParameter(PN_PROD_IMAGE_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = id;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(ECommerceDataMapperBase.PN_MODULE_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = (int)CMSEnums.ECommerceModule.ProductImage;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(ECommerceDataMapperBase.PN_ECO_LAN_LAN_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = languageID;
sqlCommand.Parameters.Add(sqlParameter);
sqlCommand.Connection.Open();
using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection))
{
while (sqlDataReader.Read())
{
productImage = new ProductImage();
FillFromReader(productImage, sqlDataReader);
}
sqlDataReader.Close();
sqlCommand.Connection.Close();
}
}
return productImage;
}
void btnSaveProdcutImage_Click(object sender, EventArgs e)
{
try
{
ProductImage productImage = null;
List<string> imagesNames = ucSWFUploadProductImage.GetFilesName();
if (imagesNames != null && imagesNames.Count > 0)
{
for (int i = 0; i <= imagesNames.Count - 1; i++)
{
productImage = new ProductImage
{
Image = imagesNames[i],
ImageCaption = txtCaption.Text,
IsCoverImage = cbIsCoverImage.Checked,
LanguageID = CMSContext.LanguageID,
ModuleID = (int)CMSEnums.ECommerceModule.ProductImage,
IsDeleted = false,
ProductID = SelecedProductId,
};
ProductImageManager.Add(productImage);
}
}
FillProdcutImages(SelecedProductId);
BeginProductImageAddMode();
}
catch (Exception ex)
{
dvProdcutImageProblems.Visible = true;
dvProdcutImageProblems.InnerText = ex.ToString();
}
finally
{
upnlProductImage.Update();
}
}
public static int Add(ProductImage productImage)
{
return ProductImageDataMapper.Add(productImage);
}
public static void Update(ProductImage productImage)
{
ProductImageDataMapper.Update(productImage);
}
public static void AddOtherLanguage(ProductImage productImage)
{
ProductImageDataMapper.AddOtherLanguage(productImage);
}
