public void product_historyupdateupdateid(Product_historyinfo productid)
{
try
{
using (RMSDataContext db = new RMSDataContext())
{
var obj = (from o in db.product_histories where o.ProductID == productid.ProductID select o).First();
obj.ProductID = productid.ProductID;
obj.ProductName = productid.ProductName;
obj.Product_imageID = productid.Product_imageID;
obj.Product_image = productid.Product_image;
obj.Product_Description = productid.Product_description;
obj.Manufacture_date = productid.Manufacture_date;
obj.Manufacture_Country = Convert.ToDateTime(productid.Manufacture_Country);
obj.Manufacture_date = productid.Manufacture_date;
obj.Product_Expired_date = productid.Product_Expired_date;
obj.Purchase_price = productid.Purchase_price.ToString();
obj.Size = productid.Size;
obj.Category = productid.Category;
obj.Color = productid.Color;
obj.BrandID = productid.BrandID;
obj.BrandName = productid.BrandName;
db.SubmitChanges();
}
}
catch (Exception ex)
{
Product_historyinfo product_his = new Product_historyinfo();
}
}
public void deleteproducthistory(Product_historyinfo deleteproducthis)
{
try
{
using (RMSDataContext db = new RMSDataContext())
{
var obj = (from o in db.product_histories where o.ProductID == deleteproducthis.ProductID select o).First();
db.product_histories.DeleteOnSubmit(obj);
db.SubmitChanges();
}
}
catch (Exception ex)
{
Product_historyinfo product_his = new Product_historyinfo();
}
}
protected void btnproducthistorysave_Click(object sender, EventArgs e)
{
Product_historyinfo phinfo = new Product_historyinfo();
ProductHistoryController phcon = new ProductHistoryController();
phinfo.ProductName = txtproductname.Text;
phinfo.Product_image = txtproductimage.Text;
phinfo.Product_description = txtproductdescription.Text;
phinfo.Category = txtcatagory.Text;
phinfo.BrandID = txtbrandid.Text;
phinfo.BrandName = txtbrandname.Text;
phinfo.Color = txtcolor.Text;
phinfo.Size = txtsize.Text;
phinfo.Purchase_price = Convert.ToDecimal(txtpruchesprice.Text);
phinfo.Manufacture_date = Convert.ToDateTime(txtmanufacturedate.Text);
phinfo.Product_Expired_date = Convert.ToDateTime(txtproductexpiredate.Text);
phinfo.Manufacture_Country = txtmanufacturecountry.Text;
phinfo.Inserted_date = Convert.ToDateTime(txtinserteddate.Text);
phcon.InsertProductHistory(phinfo);
callprouductview();
}
public void InsertProduct_History(Product_historyinfo phinfo)
{
using (RMSDataContext db = new RMSDataContext())
{
product_history pd = new product_history();
pd.ProductID = phinfo.ProductID;
pd.ProductName = phinfo.ProductName;
pd.Product_image = phinfo.Product_image;
pd.Product_imageID = phinfo.Product_imageID;
pd.Product_Description = phinfo.Product_description;
pd.Category = phinfo.Category;
pd.BrandID = phinfo.BrandID;
pd.Color = phinfo.Color;
pd.Size = phinfo.Size;
pd.Purchase_price = Convert.ToString(phinfo.Purchase_price);
pd.Product_Expired_date = phinfo.Product_Expired_date;
pd.Inserted_date = phinfo.Inserted_date;
//pd.Manufacture_Country = phinfo.Manufacture_Country;
db.product_histories.InsertOnSubmit(pd);
db.SubmitChanges();
}
}
public List <Product_historyinfo> SelectallProduct_historyinfo()
{
try {
List <Product_historyinfo> lstpinfo = new List <Product_historyinfo>();
using (RMSDataContext db = new RMSDataContext())
{
Product_historyinfo pinfo;
var b = (from c in db.product_histories select c).ToList();
foreach (var obj in b)
{
pinfo = new Product_historyinfo();
pinfo.ProductID = obj.ProductID;
pinfo.ProductName = obj.ProductName;
pinfo.Product_image = obj.Product_image;
pinfo.Product_imageID = obj.Product_imageID;
pinfo.Product_description = obj.Product_Description;
pinfo.Category = obj.Category;
pinfo.BrandName = obj.BrandName;
pinfo.BrandID = obj.BrandID;
pinfo.Color = obj.Color;
pinfo.Size = obj.Size;
pinfo.Purchase_price = Convert.ToDecimal(obj.Purchase_price);
pinfo.Manufacture_date = obj.Manufacture_date;
pinfo.Product_Expired_date = obj.Product_Expired_date;
pinfo.Manufacture_Country = obj.Manufacture_Country.ToString();
pinfo.Inserted_date = obj.Inserted_date;
lstpinfo.Add(pinfo);
}
return(lstpinfo);
}
}
catch (Exception ex)
{
return(new List <Product_historyinfo>());
}
}
public void DelectProductHistory(Product_historyinfo phinfo)
{
pda0.deleteproducthistory(phinfo);
}
public void UpdateProductHistory(Product_historyinfo phinfo)
{
pda0.product_historyupdateupdateid(phinfo);
}
public void InsertProductHistory(Product_historyinfo phinfo)
{
pda0.InsertProduct_History(phinfo);
}