public static int Add(Product obj)
{
ProductDataMapper objCaller = new ProductDataMapper();
return objCaller.Add(obj);
}
public static void Update(Product obj)
{
ProductDataMapper objCaller = new ProductDataMapper();
objCaller.Update(obj);
}
private void EditMode()
{
if (ObjectID > 0)
{
Product _pro = new Product();
_pro = ProductManager.GetByID(ObjectID);
if (null == _pro)
return;
txtName.Text = _pro.Name;
txtSerial.Text = _pro.Serial;
txtValue.Text = _pro.Value;
txtPrivatePrice.Text = _pro.PrivatePrice.ToString();
txtPublicprice.Text = _pro.PublicPrice.ToString();
ddlCategory.SelectedValue = _pro.CategoryID.ToString();
dtProductionDate.DbSelectedDate = _pro.ProducingDate;
txtTax.Text = _pro.Tax.ToString();
txtDscount.Text = _pro.Discount.ToString();
plcControls.Visible = true;
}
}
public void PopulateProduct(SqlDataReader _dtr, Product obj)
{
int columnIndex = 0;
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_NAME);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Name = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_SERIAL);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Serial = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_PUBLICPRICE);
if (!_dtr.IsDBNull(columnIndex))
{
obj.PublicPrice = _dtr.GetDouble((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_PRIVATEPRICE);
if (!_dtr.IsDBNull(columnIndex))
{
obj.PrivatePrice = _dtr.GetDouble((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_CATEGORYID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.CategoryID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_PRODUCINGDATE);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ProducingDate = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_EXPIRYDATE);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ExpiryDate = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_VALUE);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Value = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_TAX);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Tax = _dtr.GetDouble((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_PICTURE1);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Picture1 = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_PICTURE2);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Picture2 = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_WEIGHT);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Weight = _dtr.GetDouble((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_HEIGHT);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Height = _dtr.GetDouble((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_TAX);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Tax = _dtr.GetDouble((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_DISCOUNT);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Discount = _dtr.GetDouble((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_ISDELETED);
if (!_dtr.IsDBNull(columnIndex))
{
obj.IsDeleted = _dtr.GetBoolean((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_QUANTITY);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Quantity = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ProductDataMapper.CN_PRODUCT_PROVIDER);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Provider = _dtr.GetInt32((columnIndex));
}
}
public int Add(Product obj)
{
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = PCN_PRODUCT_ADD;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(PN_PRODUCT_ID, SqlDbType.Int);
parameterID.Value = obj.ID;
parameterID.Direction = ParameterDirection.Output;
_command.Parameters.Add(parameterID);
SqlParameter parameterName = new SqlParameter(PN_PRODUCT_NAME, SqlDbType.NVarChar);
parameterName.Value = obj.Name;
parameterName.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterName);
SqlParameter parameterSerial = new SqlParameter(PN_PRODUCT_SERIAL, SqlDbType.NVarChar);
parameterSerial.Value = obj.Serial;
parameterSerial.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterSerial);
SqlParameter parameterPublicPrice = new SqlParameter(PN_PRODUCT_PUBLICPRICE, SqlDbType.Decimal);
parameterPublicPrice.Value = obj.PublicPrice;
parameterPublicPrice.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterPublicPrice);
SqlParameter parameterPrivatePrice = new SqlParameter(PN_PRODUCT_PRIVATEPRICE, SqlDbType.Decimal);
parameterPrivatePrice.Value = obj.PrivatePrice;
parameterPrivatePrice.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterPrivatePrice);
SqlParameter parameterCategoryID = new SqlParameter(PN_PRODUCT_CATEGORYID, SqlDbType.Int);
parameterCategoryID.Value = obj.CategoryID;
parameterCategoryID.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterCategoryID);
SqlParameter parameterProducingDate = new SqlParameter(PN_PRODUCT_PRODUCINGDATE, SqlDbType.NVarChar);
parameterProducingDate.Value = obj.ProducingDate;
parameterProducingDate.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterProducingDate);
SqlParameter parameterExpiryDate = new SqlParameter(PN_PRODUCT_EXPIRYDATE, SqlDbType.NVarChar);
parameterExpiryDate.Value = obj.ExpiryDate;
parameterExpiryDate.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterExpiryDate);
SqlParameter parameterValue = new SqlParameter(PN_PRODUCT_VALUE, SqlDbType.NVarChar);
parameterValue.Value = obj.Value;
parameterValue.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterValue);
SqlParameter parameterTax = new SqlParameter(PN_PRODUCT_TAX, SqlDbType.Decimal);
parameterTax.Value = obj.Tax;
parameterTax.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterTax);
SqlParameter parameterPicture1 = new SqlParameter(PN_PRODUCT_PICTURE1, SqlDbType.NVarChar);
parameterPicture1.Value = obj.Picture1;
parameterPicture1.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterPicture1);
SqlParameter parameterPicture2 = new SqlParameter(PN_PRODUCT_PICTURE2, SqlDbType.NVarChar);
parameterPicture2.Value = obj.Picture2;
parameterPicture2.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterPicture2);
SqlParameter parameterWeight = new SqlParameter(PN_PRODUCT_WEIGHT, SqlDbType.Decimal);
parameterWeight.Value = obj.Weight;
parameterWeight.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterWeight);
SqlParameter parameterHeight = new SqlParameter(PN_PRODUCT_HEIGHT, SqlDbType.Decimal);
parameterHeight.Value = obj.Height;
parameterHeight.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterHeight);
SqlParameter parameterDiscount = new SqlParameter(PN_PRODUCT_DISCOUNT, SqlDbType.Decimal);
parameterDiscount.Value = obj.Discount;
parameterDiscount.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterDiscount);
SqlParameter parameterIsDeleted = new SqlParameter(PN_PRODUCT_ISDELETED, SqlDbType.Bit);
parameterIsDeleted.Value = obj.IsDeleted;
parameterIsDeleted.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterIsDeleted);
SqlParameter parameterQuantity = new SqlParameter(PN_PRODUCT_QUANTITY, SqlDbType.Int);
parameterQuantity.Value = obj.Quantity;
parameterQuantity.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterQuantity);
SqlParameter parameterProvider = new SqlParameter(PN_PRODUCT_PROVIDER, SqlDbType.Int);
parameterProvider.Value = obj.Provider;
parameterProvider.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterProvider);
#endregion;
_connection.Open();
_command.ExecuteNonQuery();
_connection.Close();
obj.ID = Convert.ToInt32(parameterID.Value);
return obj.ID;
}
void btnSaveUpdate_Click(object sender, EventArgs e)
{
Product pro = new Product();
if (ObjectID <= 0)
{
try
{
pro.IsDeleted = false;
pro.IsDeleted = false;
pro.Name = txtName.Text;
pro.CategoryID = Convert.ToInt32(ddlCategory.SelectedValue);
pro.Discount = Convert.ToDouble(txtDscount.Text);
pro.ExpiryDate = rtExpiryDate.SelectedDate.Value.ToShortDateString();
pro.Height = 0;
pro.PrivatePrice = Convert.ToDouble(txtPrivatePrice.Text);
pro.ProducingDate = dtProductionDate.SelectedDate.Value.ToShortDateString();
pro.Provider = 0;
pro.PublicPrice = Convert.ToDouble(txtPublicprice.Text);
pro.Quantity = 0;
pro.Serial = txtSerial.Text;
pro.Tax = Convert.ToDouble(txtTax.Text);
pro.Value = txtValue.Text;
pro.Weight = 0;
ProductManager.Add(pro);
AddMode();
dvProblems.InnerText = "Saved Successfully";
}
catch (Exception ex)
{
dvProblems.InnerText = ex.ToString();
}
}
else
{
try
{
pro = ProductManager.GetByID(ObjectID);
if (null == pro)
{
dvProblems.InnerText = Resources.ExpressCMS.ResourceManager.GetString(ConstantsManager.UnknowErronOccures);
return;
}
pro.IsDeleted = false;
pro.Name = txtName.Text;
pro.CategoryID = Convert.ToInt32(ddlCategory.SelectedValue);
pro.Discount = Convert.ToDouble(txtDscount.Text);
pro.ExpiryDate = rtExpiryDate.SelectedDate.Value.ToShortDateString();
pro.Height = 0;
pro.PrivatePrice = Convert.ToDouble(txtPrivatePrice.Text);
pro.ProducingDate = dtProductionDate.SelectedDate.Value.ToShortDateString();
pro.Provider = 0;
pro.PublicPrice = Convert.ToDouble(txtPublicprice.Text);
pro.Quantity = 0;
pro.Serial = txtSerial.Text;
pro.Tax = Convert.ToDouble(txtTax.Text);
pro.Value = txtValue.Text;
pro.Weight = 0;
ProductManager.Update(pro);
EditMode();
dvProblems.InnerText = "Saved Successfully";
}
catch (Exception ex)
{
dvProblems.InnerText = ex.ToString();
}
}
BindGrid();
}
public Product GetProduct(SqlDataReader _dtr, IList<Product> colobj)
{
Product obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_PRODUCT_ID].ToString())).SingleOrDefault();
if (null == obj)
{
obj = new Product();
colobj.Add(obj);
}
return obj;
}
public IList<Product> GetByCategoryID(int catID)
{
Product obj = null;
IList<Product> colobj = null;
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = PCN_PRODUCT_GETBYCATEGORY;
SqlParameter parameterCategoryID = new SqlParameter(PN_PRODUCT_CATEGORYID, SqlDbType.Int);
parameterCategoryID.Value = obj.CategoryID;
parameterCategoryID.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterCategoryID);
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new Product();
colobj = new List<Product>();
while (_dtreader.Read())
{
obj = GetProduct(_dtreader, colobj);
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return colobj;
}
public IList<Product> GetAll()
{
Product obj = null;
IList<Product> colobj = null;
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = PCN_PRODUCT_GETBYID;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new Product();
colobj = new List<Product>();
while (_dtreader.Read())
{
obj = GetProduct(_dtreader, colobj);
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return colobj;
}
private void GetEntityFromReader(SqlDataReader _dtr, Product obj)
{
PopulateProduct(_dtr, obj);
}
public Product GetByID(int ID)
{
Product obj = null;
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = PCN_PRODUCT_GETBYID;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(PN_PRODUCT_ID, SqlDbType.Int);
parameterID.Value = ID;
parameterID.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterID);
#endregion;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new Product();
if (_dtreader.Read())
GetEntityFromReader(_dtreader, obj);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return obj;
}