public virtual CustomerProductSizeDetail InsertCustomerProductSizeDetail(CustomerProductSizeDetail entity)
{
CustomerProductSizeDetail other = new CustomerProductSizeDetail();
other = entity;
if (entity.IsTransient())
{
string sql = @"Insert into CustomerProductSizeDetail ( [CustomerID]
,[ProductID]
,[Email]
,[bustchest]
,[waist]
,[shoulder]
,[hip]
,[neckwidth]
,[sleevesstyle]
,[trouserstyle]
,[shirtstyle]
,[heightfeet]
,[stichinginstructions] )
Values
( @CustomerID
, @ProductID
, @Email
, @bustchest
, @waist
, @shoulder
, @hip
, @neckwidth
, @sleevesstyle
, @trouserstyle
, @shirtstyle
, @heightfeet
, @stichinginstructions );
Select scope_identity()" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@CustomerProductSize", entity.CustomerProductSize)
, new SqlParameter("@CustomerID", entity.CustomerId ?? (object)DBNull.Value)
, new SqlParameter("@ProductID", entity.ProductId ?? (object)DBNull.Value)
, new SqlParameter("@Email", entity.Email ?? (object)DBNull.Value)
, new SqlParameter("@bustchest", entity.Bustchest ?? (object)DBNull.Value)
, new SqlParameter("@waist", entity.Waist ?? (object)DBNull.Value)
, new SqlParameter("@shoulder", entity.Shoulder ?? (object)DBNull.Value)
, new SqlParameter("@hip", entity.Hip ?? (object)DBNull.Value)
, new SqlParameter("@neckwidth", entity.Neckwidth ?? (object)DBNull.Value)
, new SqlParameter("@sleevesstyle", entity.Sleevesstyle ?? (object)DBNull.Value)
, new SqlParameter("@trouserstyle", entity.Trouserstyle ?? (object)DBNull.Value)
, new SqlParameter("@shirtstyle", entity.Shirtstyle ?? (object)DBNull.Value)
, new SqlParameter("@heightfeet", entity.Heightfeet ?? (object)DBNull.Value)
, new SqlParameter("@stichinginstructions", entity.Stichinginstructions ?? (object)DBNull.Value)
};
var identity = SqlHelper.ExecuteScalar(this.ConnectionString, CommandType.Text, sql, parameterArray);
if (identity == DBNull.Value)
{
throw new DataException("Identity column was null as a result of the insert operation.");
}
return(GetCustomerProductSizeDetail(Convert.ToInt32(identity)));
}
return(entity);
}
public virtual CustomerProductSizeDetail UpdateCustomerProductSizeDetail(CustomerProductSizeDetail entity)
{
if (entity.IsTransient())
{
return(entity);
}
CustomerProductSizeDetail other = GetCustomerProductSizeDetail(entity.CustomerProductSize);
if (entity.Equals(other))
{
return(entity);
}
string sql = @"Update CustomerProductSizeDetail set [CustomerID]=@CustomerID
, [ProductID]=@ProductID
, [Email]=@Email
, [bustchest]=@bustchest
, [waist]=@waist
, [shoulder]=@shoulder
, [hip]=@hip
, [neckwidth]=@neckwidth
, [sleevesstyle]=@sleevesstyle
, [trouserstyle]=@trouserstyle
, [shirtstyle]=@shirtstyle
, [heightfeet]=@heightfeet
, [stichinginstructions]=@stichinginstructions
where CustomerProductSize=@CustomerProductSize" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@CustomerProductSize", entity.CustomerProductSize)
, new SqlParameter("@CustomerID", entity.CustomerId ?? (object)DBNull.Value)
, new SqlParameter("@ProductID", entity.ProductId ?? (object)DBNull.Value)
, new SqlParameter("@Email", entity.Email ?? (object)DBNull.Value)
, new SqlParameter("@bustchest", entity.Bustchest ?? (object)DBNull.Value)
, new SqlParameter("@waist", entity.Waist ?? (object)DBNull.Value)
, new SqlParameter("@shoulder", entity.Shoulder ?? (object)DBNull.Value)
, new SqlParameter("@hip", entity.Hip ?? (object)DBNull.Value)
, new SqlParameter("@neckwidth", entity.Neckwidth ?? (object)DBNull.Value)
, new SqlParameter("@sleevesstyle", entity.Sleevesstyle ?? (object)DBNull.Value)
, new SqlParameter("@trouserstyle", entity.Trouserstyle ?? (object)DBNull.Value)
, new SqlParameter("@shirtstyle", entity.Shirtstyle ?? (object)DBNull.Value)
, new SqlParameter("@heightfeet", entity.Heightfeet ?? (object)DBNull.Value)
, new SqlParameter("@stichinginstructions", entity.Stichinginstructions ?? (object)DBNull.Value)
};
SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray);
return(GetCustomerProductSizeDetail(entity.CustomerProductSize));
}
public virtual CustomerProductSizeDetail CustomerProductSizeDetailFromDataRow(DataRow dr)
{
if (dr == null)
{
return(null);
}
CustomerProductSizeDetail entity = new CustomerProductSizeDetail();
entity.CustomerProductSize = (System.Int32)dr["CustomerProductSize"];
entity.CustomerId = dr["CustomerID"] == DBNull.Value?(System.Int32?)null : (System.Int32?)dr["CustomerID"];
entity.ProductId = dr["ProductID"] == DBNull.Value?(System.Int32?)null : (System.Int32?)dr["ProductID"];
entity.Email = dr["Email"].ToString();
entity.Bustchest = dr["bustchest"].ToString();
entity.Waist = dr["waist"].ToString();
entity.Shoulder = dr["shoulder"].ToString();
entity.Hip = dr["hip"].ToString();
entity.Neckwidth = dr["neckwidth"].ToString();
entity.Sleevesstyle = dr["sleevesstyle"].ToString();
entity.Trouserstyle = dr["trouserstyle"].ToString();
entity.Shirtstyle = dr["shirtstyle"].ToString();
entity.Heightfeet = dr["heightfeet"].ToString();
entity.Stichinginstructions = dr["stichinginstructions"].ToString();
return(entity);
}
public CustomerProductSizeDetail InsertCustomerProductSizeDetail(CustomerProductSizeDetail entity)
{
return(_iCustomerProductSizeDetailRepository.InsertCustomerProductSizeDetail(entity));
}
public CustomerProductSizeDetail UpdateCustomerProductSizeDetail(CustomerProductSizeDetail entity)
{
return(_iCustomerProductSizeDetailRepository.UpdateCustomerProductSizeDetail(entity));
}
public virtual CustomerProductSizeDetail DeleteCustomerProductSizeDetail(CustomerProductSizeDetail entity)
{
this.DeleteCustomerProductSizeDetail(entity.CustomerProductSize);
return(entity);
}
