public List <string> getProductName_En(string prefix) { Bis.ProductMethod bisProduct = new Bis.ProductMethod(); ViewModel.Search searchProduct = new ViewModel.Search(); searchProduct.Filter = "and tblProduct.Accessory='false' and tblProduct.Name_En like N'%" + prefix.FixFarsi() + "%' "; DataSet dsProduct = bisProduct.GetProductData(searchProduct); List <string> ProductNames = new List <string>(); if (!dsProduct.Null_Ds()) { for (int i = 0; i < dsProduct.Tables[0].Rows.Count; i++) { ProductNames.Add(string.Format("{0}~{1}", dsProduct.Tables[0].Rows[i]["Name_En"].ToString(), dsProduct.Tables[0].Rows[i]["IDProduct"].ToString())); //string item = AutoCompleteExtender.CreateAutoCompleteItem(dsProduct.Tables[0].Rows[i]["ProductCodeName"].ToString(), dsProduct.Tables[0].Rows[i]["IDProduct"].ToString()); //ProductNames.Add(item); } return(ProductNames); } else { ProductNames.Add(string.Format("{0},{1}", "اطلاعاتی یافت نشد", "اطلاعاتی یافت نشد")); return(ProductNames); } }
public IHttpActionResult SearchTrainingCourse(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); JArray JsonTrainingCourse = new JArray(); string SearchText = JsonObject["SearchText"].ToString(); if (SearchText.Length > 2) { try { ViewModel.Search searchTrainingCourse = new ViewModel.Search(); searchTrainingCourse.Filter = SearchText.FixFarsi(); JsonTrainingCourse = BisTrainingCourse.GetFullJsonDataForSearch(searchTrainingCourse); } catch { return(NotFound()); } } else { return(NotFound()); } return(Ok(JsonTrainingCourse)); } catch { return(NotFound()); } }
public IHttpActionResult FillSearchForSumico(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); JObject JsonTotalResult = new JObject(); JArray JsonRuleDefine = new JArray(); string SearchText = JsonObject["SearchText"].ToString(); if (SearchText.Length > 2) { try { ViewModel.Search searchProduct = new ViewModel.Search(); searchProduct.Filter = SearchText.FixFarsi(); JsonRuleDefine = BisRulePropertyProduct.GetFullJsonDataForSearchForSumico(searchProduct); } catch { } JsonTotalResult = JObject.Parse("{'ProductCategory': '','MasterProduct': '','RuleDefine': ''}"); JsonTotalResult["RuleDefine"] = JsonRuleDefine; } else { return(NotFound()); } return(Ok(JsonTotalResult)); } catch { return(NotFound()); } }
public IHttpActionResult DeleteContent(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); ViewModel.Search ContentSearch = new ViewModel.Search(); ContentSearch.Filter = " AND tblContent.IDContent ='" + JsonObject["IDContent"].ToString() + "'"; ContentSearch.JsonResult = " FOR JSON PATH "; JArray JsonContent = BisContent.GetContentJsonData(ContentSearch); ViewModel.tblContent DelContent = JsonObject.ToObject <ViewModel.tblContent>(); bool ret = BisContent.DeleteContent(DelContent); if (ret) { if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + JsonContent[0]["PicUrl"])) { File.Delete(AppDomain.CurrentDomain.BaseDirectory + JsonContent[0]["PicUrl"]); } if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + JsonContent[0]["PicUrl"].ToString().AddSmallUrl())) { File.Delete(AppDomain.CurrentDomain.BaseDirectory + JsonContent[0]["PicUrl"].ToString().AddSmallUrl()); } return(Ok(ret)); } else { return(NotFound()); } } catch { return(NotFound()); } }
protected void lbExpanMasterProduct_Click(object sender, EventArgs e) { LinkButton lbExpanMasterProduct = sender as LinkButton; RepeaterItem ri = (RepeaterItem)lbExpanMasterProduct.NamingContainer; string hfIDProduct = ((HiddenField)ri.FindControl("hfIDProduct")).Value; HiddenField hfExpandMasterProduct = (HiddenField)ri.FindControl("hfExpandMasterProduct"); bool Expand = hfExpandMasterProduct.Value.StringToBool(); hfExpandMasterProduct.Value = (!Expand).ToString(); Repeater rptDefineDetailProduct = (Repeater)ri.FindControl("rptDefineDetailProduct"); if (Expand) { lbExpanMasterProduct.Text = "<i class='fa fa-plus' style='font-size:15px'></i>"; if (rptDefineDetailProduct != null) { rptDefineDetailProduct.DataSource = null; rptDefineDetailProduct.DataBind(); } } else { lbExpanMasterProduct.Text = "<i class='fa fa-minus' style='font-size:15px'></i>"; if (rptProductCategory != null) { ViewModel.Search SearchDefineDetail = new ViewModel.Search(); SearchDefineDetail.Filter = " AND tblProductDefineDetailProduct.IDRet = '" + hfIDProduct + "'"; DataSet dsDefineDetail = BisProductDefineDetailProduct.GetProductDefineDetailProductData(SearchDefineDetail); rptDefineDetailProduct.DataSource = dsDefineDetail; rptDefineDetailProduct.DataBind(); } } }
public object getAllDictionary() { Bis.DictionaryMethod bisDictionary = new Bis.DictionaryMethod(); try { ViewModel.Search searchDictionary = new ViewModel.Search(); DataSet ds = bisDictionary.GetDictionaryData(searchDictionary); System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >(); Dictionary <string, object> row; foreach (DataRow dr in ds.Tables[0].Rows) { row = new Dictionary <string, object>(); foreach (DataColumn col in ds.Tables[0].Columns) { row.Add(col.ColumnName, dr[col]); } rows.Add(row); } return(serializer.Serialize(rows)); } catch (Exception) { throw; } }
public IHttpActionResult DeleteGallery(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); ViewModel.Search GallerySearch = new ViewModel.Search(); GallerySearch.Filter = " AND tblGallery.IDGallery ='" + JsonObject["IDGallery"].ToString() + "'"; GallerySearch.JsonResult = " FOR JSON PATH "; JArray JsonGallery = BisGallery.GetGalleryJsonData(GallerySearch); ViewModel.tblGallery DelGallery = JsonObject.ToObject <ViewModel.tblGallery>(); bool ret = BisGallery.DeleteGallery(DelGallery); if (ret) { File.Delete(AppDomain.CurrentDomain.BaseDirectory + JsonGallery[0]["Url"]); return(Ok(ret)); } else { return(NotFound()); } } catch { return(NotFound()); } }
public void InitialDataSource() { ViewModel.Search SearchProductCategory = new ViewModel.Search(); SearchProductCategory.Filter = " AND tblProductCategory.ParentID = '" + Guid.Empty + "'"; SearchProductCategory.Order = " ORDER BY tblProductCategory.[Order]"; DataSet dsProductCategory = BisProductCategory.GetProductCategoryDataShowInTree(SearchProductCategory); rptProductCategory.DataSource = dsProductCategory; rptProductCategory.DataBind(); }
public IHttpActionResult UpdateTrainingCourse(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); ViewModel.tblTrainingCourse UpdateTrainingCourse = JsonObject.ToObject <ViewModel.tblTrainingCourse>(); string FileUrl = ""; ViewModel.Search TrainingCourseSearch = new ViewModel.Search(); TrainingCourseSearch.Filter = " AND tblTrainingCourse.IDTrainingCourse ='" + UpdateTrainingCourse.IDTrainingCourse + "'"; TrainingCourseSearch.JsonResult = " FOR JSON PATH "; JArray JsonTrainingCourse = BisTrainingCourse.GetTrainingCourseJsonData(TrainingCourseSearch); if (UpdateTrainingCourse.PicUrl == "" && File.Exists(AppDomain.CurrentDomain.BaseDirectory + JsonTrainingCourse[0]["PicUrl"].ToString())) { File.Delete(AppDomain.CurrentDomain.BaseDirectory + JsonTrainingCourse[0]["PicUrl"].ToString()); } if (JsonObject["PicFile"].ToString() != "{}") { byte[] imageBytes = Convert.FromBase64String(JsonObject["PicFile"].ToString().Split(',')[1]); MemoryStream ms = new MemoryStream(imageBytes, 0, imageBytes.Length); ms.Write(imageBytes, 0, imageBytes.Length); Image imageTrainingCourse = Image.FromStream(ms); FileTypes ft = new FileTypes(); string FileType = ft.FindImageTypeInString(JsonObject["PicFile"].ToString().Split(',')[0]); if (imageBytes.Length < 1024 * 1024 && ft.IsImage(FileType)) { if (imageBytes.Length > 0) { FileUrl = @"Picture\TrainingCourse\" + Guid.NewGuid() + FileType; UpdateTrainingCourse.PicUrl = FileUrl; imageTrainingCourse.Save(AppDomain.CurrentDomain.BaseDirectory + FileUrl); } } } bool retUpdate = BisTrainingCourse.UpdateTrainingCourse(UpdateTrainingCourse); if (retUpdate) { return(Ok(retUpdate)); } else { File.Delete(AppDomain.CurrentDomain.BaseDirectory + FileUrl); return(NotFound()); } } catch (Exception ex) { return(NotFound()); } }
public IHttpActionResult GetCompany() { try { ViewModel.Search CompanySearch = new ViewModel.Search(); CompanySearch.JsonResult = " FOR JSON PATH "; JArray JsonCompany = BisCompany.GetCompanyJsonData(CompanySearch); return(Ok(JsonCompany)); } catch { return(NotFound()); } }
public IHttpActionResult GetTrainingCourseCategory() { try { ViewModel.Search TrainingCourseCategorySearch = new ViewModel.Search(); TrainingCourseCategorySearch.JsonResult = " FOR JSON PATH "; JArray JsonTrainingCourseCategory = BisTrainingCourseCategory.GetTrainingCourseCategoryJsonData(TrainingCourseCategorySearch); return(Ok(JsonTrainingCourseCategory)); } catch { return(NotFound()); } }
public IHttpActionResult GetWorkType() { try { ViewModel.Search WorkTypeSearch = new ViewModel.Search(); WorkTypeSearch.JsonResult = " FOR JSON PATH "; JArray JsonWorkType = BisWorkType.GetWorkTypeJsonData(WorkTypeSearch); return(Ok(JsonWorkType)); } catch (Exception ex) { return(NotFound()); } }
public IHttpActionResult GetAllDictionary() { try { ViewModel.Search DictionarySearch = new ViewModel.Search(); DictionarySearch.JsonResult = " FOR JSON PATH "; JArray JsonDictionary = BisDictionary.GetDictionaryJsonData(DictionarySearch); return(Ok(JsonDictionary)); } catch { return(NotFound()); } }
public IHttpActionResult GetDynamicFormRet() { try { ViewModel.Search DynamicFormRetSearch = new ViewModel.Search(); DynamicFormRetSearch.JsonResult = " FOR JSON PATH "; JArray JsonDynamicFormRet = BisDynamicFormRet.GetDynamicFormRetJsonData(DynamicFormRetSearch); return(Ok(JsonDynamicFormRet)); } catch (Exception ex) { return(NotFound()); } }
public IHttpActionResult GetTrainingCourseContent() { try { ViewModel.Search TrainingCourseContentSearch = new ViewModel.Search(); TrainingCourseContentSearch.JsonResult = " FOR JSON PATH "; JArray JsonTrainingCourseContent = BisTrainingCourseContent.GetTrainingCourseContentJsonData(TrainingCourseContentSearch); return(Ok(JsonTrainingCourseContent)); } catch (Exception ex) { return(NotFound()); } }
public IHttpActionResult GetTrainingCourse() { try { ViewModel.Search TrainingCourseSearch = new ViewModel.Search(); TrainingCourseSearch.Order = " ORDER BY tblTrainingCourse.EndDate Desc "; TrainingCourseSearch.JsonResult = " FOR JSON PATH "; JArray JsonTrainingCourse = BisTrainingCourse.GetTrainingCourseJsonData(TrainingCourseSearch); return(Ok(JsonTrainingCourse)); } catch (Exception ex) { return(NotFound()); } }
public IHttpActionResult FillContentCategoryType() { try { ViewModel.Search ContentCategoryTypeSearch = new ViewModel.Search(); ContentCategoryTypeSearch.Order = " order by tblContentCategoryType.[Sort]"; ContentCategoryTypeSearch.JsonResult = " FOR JSON Path "; JArray JsonContentCategoryType = BisContentCategoryType.GetContentCategoryTypeJsonData(ContentCategoryTypeSearch); return(Ok(JsonContentCategoryType)); } catch { return(NotFound()); } }
public IHttpActionResult GetDictionaryByIDX(ViewModel.tblDictionary obj) { try { ViewModel.Search DictionarySearch = new ViewModel.Search(); DictionarySearch.Filter = " AND tblDictionary.IDX = " + obj.IDX.ToString();; DictionarySearch.JsonResult = " FOR JSON PATH "; JArray JsonDictionary = BisDictionary.GetDictionaryJsonData(DictionarySearch); return(Ok(JsonDictionary)); } catch { return(NotFound()); } }
public IHttpActionResult GetListOfPartNumbers() { try { Bis.DefineDetailProductMethod BisDefineDetailProduct = new Bis.DefineDetailProductMethod(); ViewModel.Search SearchDefineDetailProduct = new ViewModel.Search(); SearchDefineDetailProduct.JsonResult = " FOR JSON PATH"; JArray JsonDefine = BisDefineDetailProduct.GetListOfPartNumbers(SearchDefineDetailProduct); return(Ok(JsonDefine)); } catch { return(NotFound()); } }
protected void FillRptMasterProduct(Repeater rptMasterProduct, string hfIDProductCategory) { try { ViewModel.Search searchProduct = new ViewModel.Search(); searchProduct.Filter = " And tblProduct.IDProductCategory = '" + hfIDProductCategory + "'"; searchProduct.Order = " Order By tblProductCategory.[Order]"; DataSet dsProduct = BisProduct.GetProductData(searchProduct); rptMasterProduct.DataSource = dsProduct; rptMasterProduct.DataBind(); } catch { } }
public IHttpActionResult FillGalleryByIDGalleryCategory(ViewModel.tblGallery obj) { try { ViewModel.Search GallerySearch = new ViewModel.Search(); GallerySearch.Filter = " AND tblGallery.IDGalleryCategory ='" + obj.IDGalleryCategory + "' AND tblGallery.IDRet = '" + obj.IDRet + "'"; GallerySearch.JsonResult = " FOR JSON PATH "; JArray JsonGallery = BisGallery.GetGalleryJsonData(GallerySearch); return(Ok(JsonGallery)); } catch { return(NotFound()); } }
public IHttpActionResult FillContentByIDX(ViewModel.tblContent obj) { try { ViewModel.Search ContentSearch = new ViewModel.Search(); ContentSearch.Filter = " AND tblContent.IDX ='" + obj.IDX.ToString() + "'"; ContentSearch.JsonResult = " FOR JSON PATH "; JArray JsonContent = BisContent.GetContentJsonData(ContentSearch); return(Ok(JsonContent)); } catch { return(NotFound()); } }
public IHttpActionResult GetTopArticleJsonData() { try { ViewModel.Search ContentSearch = new ViewModel.Search(); ContentSearch.Filter = " AND tblContentCategoryType.Name_En ='Articles' AND tblContent.InTopCategoryView = 1"; ContentSearch.JsonResult = " FOR JSON PATH "; JArray JsonContent = BisContent.GetContentJsonDataByCategoryType(ContentSearch); return(Ok(JsonContent)); } catch { return(NotFound()); } }
public IHttpActionResult FillSupplier() { try { ViewModel.Search SearchLegalUser = new ViewModel.Search(); SearchLegalUser.Order = " order by tblLegalUser.[Sort] Asc"; SearchLegalUser.JsonResult = " FOR JSON Path"; JArray JsonLegalUser = BisLegalUser.GetSupplierJsonData(SearchLegalUser); return(Ok(JsonLegalUser)); } catch { return(NotFound()); } }
protected bool CheckIDInSelectedList(string IDRet) { ViewModel.Search searchProductDefineDetailProduct = new ViewModel.Search(); searchProductDefineDetailProduct.Filter = " And tblProductDefineDetailProduct.IDRet = '" + IDRet + "' and tblProductDefineDetailProduct.IDDefineDetailProduct = '" + hfSelectedDefineDetail.Value + "'"; DataSet ds = BisProductDefineDetailProduct.GetProductDefineDetailProductData(searchProductDefineDetailProduct); if (!ds.Null_Ds()) { return(true); } else { return(false);; } }
public IHttpActionResult GetTrainingCourseCategoryByIDX(ViewModel.tblTrainingCourseCategory obj) { try { ViewModel.Search TrainingCourseCategorySearch = new ViewModel.Search(); TrainingCourseCategorySearch.Filter = " AND tblTrainingCourseCategory.IDX =" + obj.IDX; TrainingCourseCategorySearch.JsonResult = " FOR JSON PATH "; JArray JsonTrainingCourseCategory = BisTrainingCourseCategory.GetTrainingCourseCategoryJsonData(TrainingCourseCategorySearch); return(Ok(JsonTrainingCourseCategory)); } catch { return(NotFound()); } }
public IHttpActionResult FillContentByID(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); ViewModel.Search ContentSearch = new ViewModel.Search(); ContentSearch.Filter = " AND tblContent.IDContent ='" + JsonObject["IDContent"].ToString() + "'"; ContentSearch.JsonResult = " FOR JSON PATH "; JArray JsonContent = BisContent.GetContentJsonData(ContentSearch); return(Ok(JsonContent)); } catch { return(NotFound()); } }
public IHttpActionResult FillProductCategory(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); ViewModel.Search SearchProductCategory = new ViewModel.Search(); SearchProductCategory.Filter = " AND tblUser.IDX = " + JsonObject["IDXSupplier"].ToString().StringToInt().ToString() + " AND ISNULL(ParentCategory.IDX,0)=" + JsonObject["IDXParentCategory"].ToString(); SearchProductCategory.JsonResult = " FOR JSON PATH "; JArray JsonContentCategory = BisProductCategory.GetProductCategoryJsonDataSimple(SearchProductCategory); return(Ok(JsonContentCategory)); } catch { return(NotFound()); } }
public IHttpActionResult GetTrainingCourseUser_ByIDTrainingCourse(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); ViewModel.Search TrainingCourseUserSearch = new ViewModel.Search(); TrainingCourseUserSearch.Filter = " AND tblTrainingCourseUser.IDTrainingCourse = '" + JsonObject["IDTrainingCourse"].ToString() + "'"; TrainingCourseUserSearch.JsonResult = " FOR JSON PATH "; JArray JsonTrainingCourseUser = BisTrainingCourseUser.GetTrainingCourseUserJsonData(TrainingCourseUserSearch); return(Ok(JsonTrainingCourseUser)); } catch (Exception ex) { return(NotFound()); } }
public IHttpActionResult FillAllUnderConstractionDefineDetailProduct() { try { Bis.DefineDetailProductMethod BisDefineDetailProduct = new Bis.DefineDetailProductMethod(); ViewModel.Search SearchDefineDetailProduct = new ViewModel.Search(); SearchDefineDetailProduct.Filter = " AND tblDefineDetailProduct.UnderSpot = 'true'"; SearchDefineDetailProduct.JsonResult = " FOR JSON PATH"; JArray JsonDefine = BisDefineDetailProduct.GetJsonDefineDetailProductData(SearchDefineDetailProduct); return(Ok(JsonDefine)); } catch { return(NotFound()); } }