public bool Delete(Guid Id)
{
bool toReturn = false;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
ProductRegisterEntity _ProductRegisterEntity = new ProductRegisterEntity(Id);
if (adapter.FetchEntity(_ProductRegisterEntity))
{
adapter.DeleteEntity(_ProductRegisterEntity);
toReturn = true;
}
}
return toReturn;
}
ProductRegisterEntity getRegister()
{
ProductRegisterEntity register = new ProductRegisterEntity();
register.Id = Guid.NewGuid();
register.UserName = Util.CurrentUserName;
register.ProductName = Filter.GetStringNoHtml(txtProductName.Text.Trim(), ProductRegisterFields.ProductName.MaxLength);
register.Abstract = Filter.GetStringNoHtml(txtAbstract.Text.Trim(), ProductRegisterFields.Abstract.MaxLength);
register.Warranty = Filter.GetStringNoHtml(txtWarranty.Text.Trim(), ProductRegisterFields.Warranty.MaxLength);
register.Detail = Filter.GetMaxStringFilter(txtDetail.Value.Trim());
register.PriceBuy = FNumber.ConvertDecimal(txtPriceBuy.Text.Trim());
register.PriceSell = FNumber.ConvertDecimal(txtPriceSell.Text.Trim());
register.Quantity = FNumber.ConvertInt(txtQuantity.Text.Trim());
register.CompanyName = Filter.GetStringNoHtml(txtCompanyName.Text.Trim(), ProductRegisterFields.CompanyName.MaxLength);
register.CompanyPhone = Filter.GetStringNoHtml(txtCompanyPhone.Text.Trim(), ProductRegisterFields.CompanyPhone.MaxLength);
register.CompanyEmail = Filter.GetMaxString(txtCompanyEmail.Text.Trim(), ProductRegisterFields.CompanyEmail.MaxLength);
register.CompanyNumberTax = Filter.GetStringNoHtml(txtCompanyNumberTax.Text.Trim(), ProductRegisterFields.CompanyNumberTax.MaxLength);
register.CompanyAddress = Filter.GetStringNoHtml(txtCompanyAddress.Text.Trim(), ProductRegisterFields.CompanyAddress.MaxLength);
register.Note = Filter.GetStringNoHtml(txtNote.Text.Trim(), ProductRegisterFields.Note.MaxLength);
register.Thumbnail = "";
if (fileUpload.HasFile)
{
register.Thumbnail = FileUploadControl.FullPath(fileUpload, register.ProductName, ProductRegisterFields.Thumbnail.MaxLength, EnumsFile.Thumbnails);
}
return register;
}
public ProductRegisterEntity Insert(string UserName, string ProductName, string Abstract, string Thumbnail, string Warranty, int Quantity, decimal PriceBuy, decimal PriceSell, string Detail, DateTime CreatedDate, bool Approved, string CompanyName, string CompanyPhone, string CompanyAddress, string CompanyNumberTax, string CompanyEmail, string Note)
{
ProductRegisterEntity _ProductRegisterEntity = new ProductRegisterEntity();
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
_ProductRegisterEntity.UserName = UserName;
_ProductRegisterEntity.ProductName = ProductName;
_ProductRegisterEntity.Abstract = Abstract;
_ProductRegisterEntity.Thumbnail = Thumbnail;
_ProductRegisterEntity.Warranty = Warranty;
_ProductRegisterEntity.Quantity = Quantity;
_ProductRegisterEntity.PriceBuy = PriceBuy;
_ProductRegisterEntity.PriceSell = PriceSell;
_ProductRegisterEntity.Detail = Detail;
_ProductRegisterEntity.CreatedDate = CreatedDate;
_ProductRegisterEntity.Approved = Approved;
_ProductRegisterEntity.CompanyName = CompanyName;
_ProductRegisterEntity.CompanyPhone = CompanyPhone;
_ProductRegisterEntity.CompanyAddress = CompanyAddress;
_ProductRegisterEntity.CompanyNumberTax = CompanyNumberTax;
_ProductRegisterEntity.CompanyEmail = CompanyEmail;
_ProductRegisterEntity.Note = Note;
adapter.SaveEntity(_ProductRegisterEntity, true);
}
return _ProductRegisterEntity;
}
public ProductRegisterEntity Insert(ProductRegisterEntity _ProductRegisterEntity)
{
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
adapter.SaveEntity(_ProductRegisterEntity, true);
}
return _ProductRegisterEntity;
}
public bool Update(ProductRegisterEntity _ProductRegisterEntity, RelationPredicateBucket filter)
{
bool toReturn = false;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
adapter.UpdateEntitiesDirectly(_ProductRegisterEntity, filter);
toReturn = true;
}
return toReturn;
}
public bool Update(ProductRegisterEntity _ProductRegisterEntity)
{
bool toReturn = false;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(ProductRegisterFields.Id == _ProductRegisterEntity.Id);
filter.PredicateExpression.Add(_PredicateExpression);
adapter.UpdateEntitiesDirectly(_ProductRegisterEntity, filter);
toReturn = true;
}
return toReturn;
}
public ProductRegisterEntity SelectOne(Guid Id)
{
ProductRegisterEntity toReturn = null;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
ProductRegisterEntity _ProductRegisterEntity = new ProductRegisterEntity(Id);
if (adapter.FetchEntity(_ProductRegisterEntity))
{
toReturn = _ProductRegisterEntity;
}
}
return toReturn;
}
