public List <product_imageinfo> SelectByID(string productID)
{
try
{
List <product_imageinfo> lstpiinfo = new List <product_imageinfo>();
using (RMSDataContext db = new RMSDataContext())
{
product_imageinfo piinfo;
var a = (from o in db.product_image1s where o.ProductID == productID && o.MainPic == false select o).ToList();
foreach (var obj in a)
{
piinfo = new product_imageinfo();
piinfo.Product_imageID = obj.Product_imageID;
piinfo.Images = (obj.Images.ToArray());
piinfo.MainPic = obj.MainPic;
lstpiinfo.Add(piinfo);
}
return(lstpiinfo);
}
}
catch (Exception ex)
{
return(new List <product_imageinfo>());
}
}
public List <product_imageinfo> Selectallproduct_imagecs()
{
try
{
List <product_imageinfo> lstpiinfo = new List <product_imageinfo>();
using (RMSDataContext db = new RMSDataContext())
{
product_imageinfo piinfo;
var a = (from o in db.product_images select o).ToList();
foreach (var obj in a)
{
piinfo = new product_imageinfo();
piinfo.Product_imageID = obj.Product_imageID;
piinfo.Images = obj.Images;
lstpiinfo.Add(piinfo);
}
return(lstpiinfo);
}
}
catch (Exception ex)
{
return(new List <product_imageinfo>());
}
}
public void Insertproduct_images(product_imageinfo pinfo)
{
using (RMSDataContext db = new RMSDataContext())
{
product_image tbl = new product_image();
tbl.Product_imageID = pinfo.Product_imageID;
tbl.Images = pinfo.Images;
db.product_images.InsertOnSubmit(tbl);
db.SubmitChanges();
}
}
public void DelectProductImagebyProductimgId(product_imageinfo pinfo)
{
try
{
using (RMSDataContext db = new RMSDataContext())
{
var p = (from pp in db.product_image1s where pp.Product_imageID == pinfo.Product_imageID select pp).First();
db.product_image1s.DeleteOnSubmit(p);
db.SubmitChanges();
}
}
catch (Exception ex)
{
product_imageinfo pi = new product_imageinfo();
}
}
public void UpdateProductImagebyProductId(product_imageinfo pinfo)
{
try
{
using (RMSDataContext db = new RMSDataContext())
{
var p = (from pp in db.product_image1s where pp.Product_imageID == pinfo.Product_imageID select pp).First();
p.Product_imageID = pinfo.Product_imageID;
p.Images = pinfo.Images;
db.SubmitChanges();
}
}
catch (Exception ex)
{
product_imageinfo pi = new product_imageinfo();
}
}
public void InsertProductImage(product_imageinfo pinfo)
{
try
{
using (RMSDataContext db = new RMSDataContext())
{
product_image1 pim = new product_image1();
Guid pid = Guid.NewGuid();
pim.Product_imageID = pid.ToString();
pim.ProductID = pinfo.ProductID;
System.Data.Linq.Binary file_binary = new System.Data.Linq.Binary(pinfo.Images);
pim.Images = file_binary;
pim.MainPic = pinfo.MainPic;
db.product_image1s.InsertOnSubmit(pim);
db.SubmitChanges();
}
}
catch (Exception ex) { }
}
public void InsertProductImages(product_imageinfo piInf)
{
try
{
using (RMSDataContext db = new RMSDataContext())
{
product_image1 pr = new product_image1();
Guid prid = new Guid();
pr.Product_imageID = prid.ToString();
System.Data.Linq.Binary file_binary = new System.Data.Linq.Binary(piInf.Images);
pr.Images = file_binary;
//System.Data.Linq.Binary file_binary_Main = new System.Data.Linq.Binary(piInf.MainPic);
//pr.MainPic = file_binary_Main;
pr.ProductID = piInf.ProductID;
db.product_image1s.InsertOnSubmit(pr);
db.SubmitChanges();
}
}
catch (Exception ex) { }
}
protected void btnSave_Click(object sender, EventArgs e)
{
Productinfo prinfo = new Productinfo();
ProductController pcon = new ProductController();
prinfo.ProductName = txtProductName.Text.Trim();
prinfo.Product_description = txtDesc.Text.Trim();
prinfo.Color = txtColor.Text.Trim();
prinfo.Size = txtSize.Text.Trim();
prinfo.Manufacture_Country = txtMade.Text.Trim();
prinfo.UnitPrice = Convert.ToDecimal(txtSellPrice.Text.Trim());
prinfo.Manufacture_date = Convert.ToDateTime(txtManuDate.Text.Trim());
prinfo.Expired_date = Convert.ToDateTime(txtExpDate.Text.Trim());
prinfo.Product_Expired_date = Convert.ToDateTime(txtExpDate.Text.Trim());
prinfo.BrandID = ddlBrand.SelectedItem.Value;
prinfo.CategoryID = ddlCateogry.SelectedItem.Value;
prinfo.SupplierID = ddlSupplier.SelectedItem.Value;
prinfo.UMID = ddlUM.SelectedItem.Value;
//pcon.InsertProduct(prinfo);
string productID = pcon.InsertProduct(prinfo);
Inventoryinfo invinfo = new Inventoryinfo();
Invertorycontroller invCon = new Invertorycontroller();
invinfo.ProductID = productID;
invinfo.UnitInStock = Convert.ToInt32(txtUnitStock.Text.Trim());
string invId = invCon.InsertInventory(invinfo);
ReorderInfo rinfo = new ReorderInfo();
ReorderController rcon = new ReorderController();
rinfo.ProductID = productID;
rinfo.InventoryID = invId;
rinfo.ReorderUnit = txtReorder.Text.Trim();
rcon.InsertReorder(rinfo);
Cell_Priceinfoinfo cinfo = new Cell_Priceinfoinfo();
Cell_PriceController ccon = new Cell_PriceController();
cinfo.Cell_Price1 = Convert.ToDecimal(txtBuyPrice.Text.Trim());
cinfo.Cell_Price2 = Convert.ToDecimal(txtSellPrice.Text.Trim());
cinfo.Product_id = productID;
cinfo.UMID = ddlUM.SelectedItem.Value;
ccon.InsertCell_Price(cinfo);
if (fuMain.HasFile)
{
product_imageinfo piminfo = new product_imageinfo();
ProductImageController pimcon = new ProductImageController();
piminfo.ProductID = productID;
piminfo.Images = fuMain.FileBytes;
piminfo.MainPic = true;
pimcon.InsertProductImage(piminfo);
}
if (fuLeft.HasFile)
{
product_imageinfo piminfo = new product_imageinfo();
ProductImageController pimcon = new ProductImageController();
piminfo.ProductID = productID;
piminfo.Images = fuLeft.FileBytes;
pimcon.InsertProductImage(piminfo);
}
if (FuBehind.HasFile)
{
product_imageinfo piminfo = new product_imageinfo();
ProductImageController pimcon = new ProductImageController();
piminfo.ProductID = productID;
piminfo.Images = FuBehind.FileBytes;
piminfo.MainPic = false;
pimcon.InsertProductImage(piminfo);
}
if (fuRight.HasFile)
{
product_imageinfo piminfo = new product_imageinfo();
ProductImageController pimcon = new ProductImageController();
piminfo.ProductID = productID;
piminfo.Images = fuRight.FileBytes;
piminfo.MainPic = false;
pimcon.InsertProductImage(piminfo);
}
if (fuFront.HasFile)
{
product_imageinfo piminfo = new product_imageinfo();
ProductImageController pimcon = new ProductImageController();
piminfo.ProductID = productID;
piminfo.Images = fuFront.FileBytes;
piminfo.MainPic = false;
pimcon.InsertProductImage(piminfo);
}
if (fuBottom.HasFile)
{
product_imageinfo piminfo = new product_imageinfo();
ProductImageController pimcon = new ProductImageController();
piminfo.ProductID = productID;
piminfo.Images = fuBottom.FileBytes;
piminfo.MainPic = false;
pimcon.InsertProductImage(piminfo);
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('New Product Inserted Successfully!')", true);
}
public string listingImage(product_imageinfo info)
{
return("<img onclick='ChangeImage(this)' class='slideImage' src='" + "Controller/productImgHandler1.ashx?ProIMID=" + info.Product_imageID + "' />");
}
public void DelectProductImage(product_imageinfo prinfo)
{
piDao = new product_imageDao();
piDao.DelectProductImagebyProductimgId(prinfo);
}
public void UpdateProductImage(product_imageinfo prinfo)
{
piDao = new product_imageDao();
piDao.UpdateProductImagebyProductId(prinfo);
}
public void InsertProductImage(product_imageinfo prinfo)
{
piDao = new product_imageDao();
piDao.InsertProductImage(prinfo);
}
