Exemple #1
0
        public ActionResult GetItemByID(int itemId)
        {
            BO_Item obj = new BussinessObject.BO_Item();

            obj = BL_Item.GetItemByID(itemId);
            return(Json(obj, JsonRequestBehavior.AllowGet));
        }
        //Get Generated Item Code
        #region [Get Item Code]

        private string GetItemCode()
        {
            try
            {
                EWA_Item objEWA = new EWA_Item();
                BL_Item  objBL  = new BL_Item();

                float CategoryId = db.getDb_Value("SELECT CategoryId FROM  tblCategory where OrgId='" + orgId.ToString() + "' ");



                objEWA.CategoryId = CategoryId.ToString();
                DataSet dsData   = objBL.GetItemCode_BL(objEWA);
                string  ItemCode = string.Empty;
                if (dsData.Tables[0].Rows.Count > 0)
                {
                    ItemCode = dsData.Tables[0].Rows[0][0].ToString();
                }
                return(ItemCode);
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
                return("");
            }
        }
Exemple #3
0
        public void DownloadExcel(JQueryDataTableParamModel Param)
        {
            try
            {
                string tmpDirPath = System.Web.Hosting.HostingEnvironment.MapPath("~/App_Data/temp/");
                string DetagalioReportTemplate = "Master_Template_Excel";
                string getfile        = System.Web.Hosting.HostingEnvironment.MapPath("~/App_Data/getexcel/" + DetagalioReportTemplate + ".xlsx");
                string masterfilePath = tmpDirPath + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xlsx";
                var    existingFile   = new FileInfo(getfile);
                existingFile = existingFile.CopyTo(masterfilePath);
                var obj = BL_Item.LoadItems(Param);
                //var obj = BL_FilePortalDownloadFile.GetFilePortalDownloadDataForExcel(Param, Request);
                FormatExcelItemReports(obj.ToList(), masterfilePath);

                using (var package = new ExcelPackage(existingFile))
                {
                    //Get the work book in the file
                    var workBook = package.Workbook;

                    if (workBook != null)
                    {
                        var exportData = new MemoryStream();
                        workBook.Worksheets.Delete(1);
                        package.SaveAs(exportData);
                        string saveAsFileName = ("Item " + DateTime.Now.ToString("yyyy-MM-dd HH-mm") + ".xlsx").Replace(" / ", " - ");
                        Response.Clear();
                        Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                        Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", saveAsFileName));
                        Response.Cookies["ava_cv"].Value   = Request.QueryString["cv"];
                        Response.Cookies["ava_cv"].Expires = DateTime.UtcNow.AddMinutes(5);

                        Response.BinaryWrite(exportData.ToArray());
                        Response.Flush();
                        Response.End();
                    }
                }
                string[] files = System.IO.Directory.GetFiles(tmpDirPath, "*.xlsx");
                if (files.Any())
                {
                    foreach (string file in files)
                    {
                        System.IO.File.Delete(file);
                    }
                }
            }
            finally
            {
                Response.Cookies["ava_cv"].Value   = Request.QueryString["cv"];
                Response.Cookies["ava_cv"].Expires = DateTime.UtcNow.AddMinutes(5);
            }
        }
Exemple #4
0
        //Grid Index Changed
        #region GrdIndexChanged

        protected void GrdItem_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            try
            {
                BL_Item objBL = new BL_Item();
                GrdItem.PageIndex = e.NewPageIndex;

                GrdItem.DataSource = objBL.BindItemGrid_BL();
                GrdItem.DataBind();
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
        //Check Data
        #region [Check Data]

        private int CheckData()
        {
            int i = 0;

            try
            {
                EWA_Item objEWA = new EWA_Item();
                BL_Item  objBL  = new BL_Item();
                objEWA.ItemName = txtItemName.Text.Trim();
                i = objBL.CheckDuplicateItem_BL(objEWA);
                return(i);
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
                return(0);
            }
        }
        private void BindUnit()
        {
            try
            {
                EWA_Item objEWA = new EWA_Item();
                BL_Item  objBL  = new BL_Item();
                //objEWA.OrgId = orgId;
                objEWA.OrgId = Convert.ToInt32(Session["OrgId"]);
                DataSet dsUnit = objBL.BindUnit_BL(objEWA);
                ddlUnit.DataSource     = dsUnit;
                ddlUnit.DataValueField = "UnitId";
                ddlUnit.DataTextField  = "UnitName";
                ddlUnit.DataBind();
                ddlUnit.Items.Insert(0, "Select");


                //if (ddlCategory.Items.Count <= 1)
                //{
                //    using (SqlCommand cmd = new SqlCommand("     SELECT        UnitName, UnitId FROM            tblUnit   where OrgId='" + orgId.ToString() + "' "))
                //    {
                //        cmd.CommandType = CommandType.Text;
                //        cmd.Connection = cn;
                //        cn.Open();
                //        ddlCategory.DataSource = cmd.ExecuteReader();
                //        ddlCategory.DataValueField = "UnitId";
                //        ddlCategory.DataTextField = "UnitName";
                //        ddlCategory.DataBind();
                //        cn.Close();
                //    }

                //    ddlCategory.Items.Insert(0, new ListItem("--Select Unit--"));
                //}
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
Exemple #7
0
 public string GetOilGradeData()
 {
     return(BL_Common.Serialize(BL_Item.GetOilGradeData()));
 }
Exemple #8
0
        public string GetActingAccounts()
        {
            var List = BL_Item.GetActingAccounts();

            return(BL_Common.Serialize(List));
        }
Exemple #9
0
        public JsonResult GetServiceNameList()
        {
            var List = BL_Item.GetServiceNameList();

            return(Json(List, JsonRequestBehavior.AllowGet));
        }
Exemple #10
0
        public string GetItemQuantityforSale(int itemId)
        {
            string qty = BL_Item.GetItemQuantityforSale(itemId).ToString();

            return(BL_Common.Serialize(qty));
        }
Exemple #11
0
        public string DeleteItem(int itemId)
        {
            var pl = BL_Item.DeleteItem(itemId, UserAprosysAccounting.id);

            return(BL_Common.Serialize(pl));
        }
Exemple #12
0
        public ActionResult LoadItemTable(JQueryDataTableParamModel Param)
        {
            MYJSONTblCustom MYJSON = BL_Item.LoadItemTable(Param, Request);

            return(Json(MYJSON, JsonRequestBehavior.AllowGet));
        }
Exemple #13
0
        public string SaveItem(string paramitem)
        {
            var _item = BL_Common.Deserialize <BO_Item>(paramitem);

            return(BL_Common.Serialize(BL_Item.SaveItem(_item, UserAprosysAccounting.id)));
        }