public JsonResult FillProduct(Int64 ID_Product)
 {
     try
     {
         DataTable dtbl      = new DataTable();
         BlProduct blproduct = new BlProduct();
         blproduct.MasterID   = ID_Product;
         blproduct.UserCode   = Convert.ToInt64(Session["ID_Agent"]);
         blproduct.FK_Company = Convert.ToInt64(Session["ID_Company"]);
         dtbl = blproduct.SelectAllData();
         return(Json(Converttojson(dtbl), JsonRequestBehavior.AllowGet));
     }
     catch (Exception ex)
     {
         return(Json(ex));
     }
 }
        public ActionResult UpdateProduct(BlProduct ObjBlProduct)
        {
            long statusCode = 0;

            ObjBlProduct.UserCode   = Convert.ToInt64(Session["ID_Agent"]);
            ObjBlProduct.FK_Company = Convert.ToInt64(Session["ID_Company"]);
            if (ObjBlProduct.MasterID == 0)
            {
                statusCode = ObjBlProduct.InsertData();
            }
            else
            {
                statusCode = ObjBlProduct.UpdateData();
            }

            return(Json(new { statusCode = "" + statusCode + "" }, JsonRequestBehavior.AllowGet));
        }
        public JsonResult DeleteProduct(Int64 ID_Product)
        {
            try
            {
                long      statusCode = 0;
                BlProduct blproduct  = new BlProduct();
                blproduct.MasterID   = ID_Product;
                blproduct.UserCode   = Convert.ToInt64(Session["ID_Agent"]);
                blproduct.FK_Company = Convert.ToInt64(Session["ID_Company"]);

                statusCode = blproduct.DeleteData();
                return(Json(new { statusCode = "" + statusCode + "" }, JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                return(Json(ex));
            }
        }
 public JsonResult SelectProductAll(string PageIndex = "1", string SearchItem = "")
 {
     try
     {
         int       statusCode = 1;
         DataTable dtbl       = new DataTable();
         BlProduct blproduct  = new BlProduct();
         blproduct.PageIndex  = Convert.ToInt32(PageIndex);
         blproduct.FK_Company = Convert.ToInt64(Session["ID_Company"]);
         blproduct.ProdCode   = SearchItem;
         blproduct.ProdName   = SearchItem;
         dtbl = blproduct.SelectAllData();
         return(Json(Converttojson(dtbl), JsonRequestBehavior.AllowGet));
     }
     catch (Exception ex)
     {
         ///
         return(Json(ex));
     }
 }