public string GetVendorDetailsByUserID(int UserID, int page, int rows, string sidx, string sord, string searchkeyword, string Name,
            string BrandName, string Address, string CityName, string StateName, string CountryName, string Zip, string Mobile, string Phone, string Fax, string Email)
        {
            try
            {
                if (Utility.CommonUtility.CheckUserAuthenticated())
                {
                    var totalrows = 0;
                    List<VendorMasterBLL> lstVendorMasterBLL = VendorMasterBLL.GetAllRecordByUserID(UserID, page, rows, sidx, sord, ref totalrows, searchkeyword, Name, BrandName, Address, CityName, StateName, CountryName, Zip, Mobile, Phone, Fax, Email);
                    JavaScriptSerializer ser = new JavaScriptSerializer();
                    JqGridClass<List<VendorMasterBLL>> objGridClass = new JqGridClass<List<VendorMasterBLL>>();
                    objGridClass.totalpages = Convert.ToInt32(Math.Ceiling((double)totalrows / (double)rows));
                    objGridClass.currpage = page;
                    objGridClass.currrecords = totalrows;
                    objGridClass.rows = lstVendorMasterBLL;

                    return ser.Serialize(objGridClass);
                }
                return "Fail";
            }
            catch (Exception ex)
            {
                //ValuePad.Utility.CommonUtility.SendErrorMail(ex);
                return "Fail" + ex.Message;
            }
        }
        public string GetProductByUserID(int UserID, int page, int rows, string sidx, string sord, 
            string searchkeyword, string Name, string Descryption, string ShortCode, string VendorName, string CompanyName,
            string ProductFor, string ProductColor, string ProductCategory, string ProductSize, string Quantity, string TotalPrice,
            string PurchasePrice, string MRP, string Discount)
        {
            try
            {
                if (Utility.CommonUtility.CheckUserAuthenticated())
                {
                    var totalrows = 0;
                    List<ProductMasterBLL> lstProductMasterBLL = ProductMasterBLL.GetAllRecordByUserID(UserID, page, rows, sidx, sord, ref  totalrows,
            searchkeyword, Name, Descryption, ShortCode, VendorName, CompanyName, ProductFor,
            ProductColor, ProductCategory, ProductSize, Quantity, TotalPrice, PurchasePrice,
            MRP, Discount);
                    JavaScriptSerializer ser = new JavaScriptSerializer();
                    JqGridClass<List<ProductMasterBLL>> objGridClass = new JqGridClass<List<ProductMasterBLL>>();
                    objGridClass.totalpages = Convert.ToInt32(Math.Ceiling((double)totalrows / (double)rows));
                    objGridClass.currpage = page;
                    objGridClass.currrecords = totalrows;
                    objGridClass.rows = lstProductMasterBLL;

                    return ser.Serialize(objGridClass);
                }
                return "Fail";
            }
            catch (Exception ex)
            {
                //ValuePad.Utility.CommonUtility.SendErrorMail(ex);
                return "Fail" + ex.Message;
            }
        }