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());
}
}
