Exemplo n.º 1
0
 public bool Add(Brand info)
 {
     bool result = false;
     try
     {
         result = WriteBrand(ProceduresNames.BrandAdd, info, true);
     }
     catch (Exception error)
     {
         throw error;
     }
     return result;
 }
Exemplo n.º 2
0
 public bool Update(Brand info)
 {
     bool result = false;
     try
     {
         result = WriteBrand(ProceduresNames.BrandUpdate, info, false);
     }
     catch (Exception error)
     {
         throw error;
     }
     return result;
 }
Exemplo n.º 3
0
        private bool WriteBrand(string ProcedureName, Brand info, bool IsNew)
        {
            bool result = false;
            try
            {
                SqlCommand command = new SqlCommand(ProcedureName, this.Connection);
                command.CommandType = CommandType.StoredProcedure;

                command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, Brand.TableColumns.NameAr), info.NameAr);
                command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, Brand.TableColumns.NameEn), info.NameEn);
                command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, Brand.TableColumns.ShortDescriptionAr), info.ShortDescriptionAr);
                command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, Brand.TableColumns.ShortDescriptionEn), info.ShortDescriptionEn);
                command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, Brand.TableColumns.Image), info.Image);

                if (!string.IsNullOrEmpty(info.DescriptionAr))
                    command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, Brand.TableColumns.DescriptionAr), info.DescriptionAr);
                else
                    command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, Brand.TableColumns.DescriptionAr), DBNull.Value);

                if (!string.IsNullOrEmpty(info.DescriptionEn))
                    command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, Brand.TableColumns.DescriptionEn), info.DescriptionEn);
                else
                    command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, Brand.TableColumns.DescriptionEn), DBNull.Value);

                if (IsNew)
                {
                    command.Parameters.Add(string.Concat(CommonStrings.AtSymbol, Brand.CommonColumns.ID), SqlDbType.Int);
                    command.Parameters[string.Concat(CommonStrings.AtSymbol, Brand.CommonColumns.ID)].Direction = ParameterDirection.Output;

                    if (info.CreatedBy.HasValue)
                        command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, Brand.CommonColumns.CreatedBy), info.CreatedBy.Value);
                    else
                        command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, Brand.CommonColumns.CreatedBy), DBNull.Value);
                }
                else
                {
                    command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, Brand.CommonColumns.ID), info.ID);

                    if (info.ModifiedBy.HasValue)
                        command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, Brand.CommonColumns.ModifiedBy), info.ModifiedBy.Value);
                    else
                        command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, Brand.CommonColumns.ModifiedBy), DBNull.Value);
                }

                this.OpenConnection();

                command.ExecuteNonQuery();

                if (IsNew)
                {
                    info.ID = Convert.ToInt32(command.Parameters[string.Concat(CommonStrings.AtSymbol, Brand.CommonColumns.ID)].Value);
                }

                result = true;
            }
            catch (Exception error)
            {
                throw error;
            }
            finally
            {
                this.CloseConnection();
            }
            return result;
        }
Exemplo n.º 4
0
        private void ReadBrandList(SqlDataReader reader, List<Brand> infoList, bool? IsArabic)
        {
            try
            {
                Brand info = null;

                if (!IsArabic.HasValue)
                {
                    while (reader.Read())
                    {
                        info = new Brand();

                        info.ID = Convert.ToInt32(reader[Brand.CommonColumns.ID]);
                        info.Image = Convert.ToString(reader[Brand.TableColumns.Image]);
                        info.NameAr = Convert.ToString(reader[Brand.TableColumns.NameAr]);
                        info.NameEn = Convert.ToString(reader[Brand.TableColumns.NameEn]);
                        info.ShortDescriptionAr = Convert.ToString(reader[Brand.TableColumns.ShortDescriptionAr]);
                        info.ShortDescriptionEn = Convert.ToString(reader[Brand.TableColumns.ShortDescriptionEn]);
                        info.CreationDate = Convert.ToDateTime(reader[Brand.CommonColumns.CreationDate]);

                        if (reader[Brand.TableColumns.DescriptionAr] != DBNull.Value)
                            info.DescriptionAr = Convert.ToString(reader[Brand.TableColumns.DescriptionAr]);

                        if (reader[Brand.TableColumns.DescriptionEn] != DBNull.Value)
                            info.DescriptionEn = Convert.ToString(reader[Brand.TableColumns.DescriptionEn]);

                        if (reader[Brand.CommonColumns.CreatedBy] != DBNull.Value)
                            info.CreatedBy = (Guid)reader[Brand.CommonColumns.CreatedBy];
                        else
                            info.CreatedBy = null;

                        if (reader[Brand.CommonColumns.ModificationDate] != DBNull.Value)
                            info.ModificationDate = Convert.ToDateTime(reader[Brand.CommonColumns.ModificationDate]);
                        else
                            info.ModificationDate = null;

                        if (reader[Brand.CommonColumns.ModifiedBy] != DBNull.Value)
                            info.ModifiedBy = (Guid)reader[Brand.CommonColumns.ModifiedBy];
                        else
                            info.ModifiedBy = null;

                        infoList.Add(info);
                    }
                }
                else
                {
                    if (IsArabic.Value)
                    {
                        while (reader.Read())
                        {
                            info = new Brand();

                            info.ID = Convert.ToInt32(reader[Brand.CommonColumns.ID]);
                            info.Image = Convert.ToString(reader[Brand.TableColumns.Image]);
                            info.NameAr = Convert.ToString(reader[Brand.TableColumns.NameAr]);
                            info.ShortDescriptionAr = Convert.ToString(reader[Brand.TableColumns.ShortDescriptionAr]);

                            if (reader[Brand.TableColumns.DescriptionAr] != DBNull.Value)
                                info.DescriptionAr = Convert.ToString(reader[Brand.TableColumns.DescriptionAr]);

                            infoList.Add(info);
                        }
                    }
                    else
                    {
                        while (reader.Read())
                        {
                            info = new Brand();

                            info.ID = Convert.ToInt32(reader[Brand.CommonColumns.ID]);
                            info.Image = Convert.ToString(reader[Brand.TableColumns.Image]);
                            info.NameEn = Convert.ToString(reader[Brand.TableColumns.NameEn]);
                            info.ShortDescriptionEn = Convert.ToString(reader[Brand.TableColumns.ShortDescriptionEn]);

                            if (reader[Brand.TableColumns.DescriptionEn] != DBNull.Value)
                                info.DescriptionEn = Convert.ToString(reader[Brand.TableColumns.DescriptionEn]);

                            infoList.Add(info);
                        }
                    }
                }
            }
            catch (Exception error)
            {
                throw error;
            }
        }