protected void delPicPropertyEdit_Click(object sender, EventArgs e) { try { imagePropertyEdit.Visible = false; ScriptManager.RegisterStartupScript(this, GetType(), "aa", "$('.EditPro').css(\"display\", \"none\");clearFulPropertyEdit();", true); ViewModel.Search searchProperty = new ViewModel.Search(); searchProperty.Filter = " and tblProperty.IDProperty = '" + hfIdProperty.Value + "'"; DataSet dsProperty = BisProperty.GetPropertyData(searchProperty); string PicUrl = dsProperty.ReturnDataSetField("PicUrl"); if (dsProperty.ReturnDataSetField("PicUrl") != "") { ViewModel.tblProperty updatePicUrl = new ViewModel.tblProperty(); updatePicUrl.PicUrl = ""; updatePicUrl.IDProperty = hfIdProperty.Value.StringToGuid(); bool ret = BisProperty.UpdatePicUrlProperty(updatePicUrl); if (ret) { File.Delete(Server.MapPath("../" + PicUrl)); } else { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorMessage", "alert('اشکال در حذف عکس!');", true); } } } catch { ScriptManager.RegisterStartupScript(this, GetType(), "OkMessage", "alert('اشکال در برقراری ارتباط با دیتابیس!');", true); } }
public void NewFiledsAttachSite() { txtTitle.Text = ""; txtDescription.Text = ""; hfFilelName.Value = ""; hfModeAttachSite.Value = "New"; if (hfIDRet.Value != "") { ViewModel.Search get = new ViewModel.Search(); get.Filter = " and tblAttachCrmInterface.IDRet = '" + hfIDRet.Value + "'"; DataSet ds = bisAttachCrmInterfaceMethod.GetAttachCrmInterface_GetData_MaxOrderByIDRet(get); txtOrder.Text = (ds.ReturnDataSetField("MaxOrder").StringToInt() + 1).ToString(); } //foreach (GridViewRow gr in grdAttachSiteFiles.Rows) //{ // CheckBox chk = (CheckBox)gr.FindControl("chkSelect"); // if (chk.Checked) // { // chk.Checked = false; // } //} //Enable FileUpload ra true mikonad ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "UploadFiles", hfControlIDAttachSite.Value + "SetEnableTrue()", true); }
protected void LoadComment() { ViewModel.Search SearchContent = new ViewModel.Search(); SearchContent.Filter = " and tblComment.Show='false'"; SearchContent.Order = "order by CreateDate"; dtComment = BisComment.GetCommentData(SearchContent).Tables[0]; }
protected void tvProperty_SelectedNodeChanged(object sender, EventArgs e) { ViewModel.Search SearchProperty = new ViewModel.Search(); SearchProperty.Filter = " And tblProperty.IDProperty = '" + tvProperty.SelectedNode.Value + "'"; DataSet dsSelectedProperty = BisProperty.GetPropertyData(SearchProperty); lblModalPropertyName.Text = dsSelectedProperty.ReturnDataSetField("Name_En"); txtPropertyEditTitle_Fa.Text = dsSelectedProperty.ReturnDataSetField("Name_Fa"); txtPropertyEditTitle_En.Text = dsSelectedProperty.ReturnDataSetField("Name_En"); txtPropertyEditSort.Text = dsSelectedProperty.ReturnDataSetField("Sort"); txtPropertyEditDescription_En.Text = dsSelectedProperty.ReturnDataSetField("Description_En"); if (dsSelectedProperty.ReturnDataSetField("PicUrl") != "") { imagePropertyEdit.ImageUrl = "../" + dsSelectedProperty.ReturnDataSetField("PicUrl"); imagePropertyEdit.Visible = true; } else { imagePropertyEdit.Visible = false; } hfIdProperty.Value = tvProperty.SelectedNode.Value; hfIdParentProperty.Value = dsSelectedProperty.ReturnDataSetField("IDParent"); filltvEditProperty(); tvEditProperty.ExpandAll(); SelectTreeViewNode(tvEditProperty.Nodes, dsSelectedProperty.ReturnDataSetField("IDParent")); ScriptManager.RegisterStartupScript(this, GetType(), "modal", "$('#ModalPropertyEvents').modal('show');$('.EditPro').css(\"display\", \"none\");$('.AddPro').css(\"display\", \"none\");clearFulProperty();clearFulPropertyEdit()", true); tvProperty.SelectedNode.Selected = false; txtPropertyTitle_Fa.Text = ""; txtPropertyTitle_En.Text = ""; txtPropertyDescription_En.Text = ""; }
protected void drpUser_SelectedIndexChanged(object sender, EventArgs e) { if (drpUser.SelectedValue != Guid.Empty.ToString()) { tvAccesslevel.Visible = true; ViewModel.Search getUserRole = new ViewModel.Search(); getUserRole.Filter = " and tblUserRole.IDUser='******'"; DataSet dsUserRole = BisUserRole.GetUserRoleData(getUserRole); if (dsUserRole.Null_Ds()) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorMessage", "alert('برای این پرسنل نقشی تعریف نشده است!');", true); tvAccesslevel.Visible = false; return; } else { for (int i = 0; i < dsUserRole.Tables[0].Rows.Count; i++) { InitialAccessLevel(dsUserRole.Tables[0].Rows[i]["IDRole"].ToString()); } filltvAccessLevel(drpUser.SelectedValue); } } else { tvAccesslevel.Visible = false; } }
protected void tvEvent_SelectedNodeChanged(object sender, EventArgs e) { try { Guid IDEvent = tvEvent.SelectedValue.StringToGuid(); ViewModel.Search getEventUser = new ViewModel.Search(); getEventUser.Filter = " tblEventUser.IDEvent = '" + IDEvent + "' and tblEventUser.IDUser= '******'"; DataSet dsEventUser = BisEventUser.GetEventUserData(getEventUser); if (dsEventUser.Null_Ds()) { ViewModel.tblEventUser AddEventUser = new ViewModel.tblEventUser(); AddEventUser.IDEvent = IDEvent; AddEventUser.IDUser = drpUser.SelectedValue.StringToGuid(); bool ret3 = BisEventUser.AddEventUser(AddEventUser); } else { ViewModel.tblEventUser DeleteEventUser = new ViewModel.tblEventUser(); DeleteEventUser.IDEvent = IDEvent; DeleteEventUser.IDUser = drpUser.SelectedValue.StringToGuid(); bool ret3 = BisEventUser.DeleteEventUser(DeleteEventUser); } filltvEvent(hfIDMenuForEvent.Value); } catch (Exception) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorMessage", "alert('اشکال در برقراری ارتباط بادیتابیس!');", true); } }
protected DataTable FillMenu(Guid IDUser) { ViewModel.Search AccessSearch = new ViewModel.Search(); AccessSearch.Filter = " And IDUser = '******' and tblAccessLevel.Access='True' "; AccessSearch.Order = " order by tblMenu.[Order] Asc"; DataSet dsAccessLevel = BisAccessLevel.GetAccessLevelDataForTree(AccessSearch); string PageName = HttpContext.Current.Request.Url.AbsolutePath.Substring(7); // esme safhe ra az pusheye admin jodamikonad : /admin if (dsAccessLevel.Tables[0].Select("MenuUrl='" + "Admin/" + PageName + "'").Count() == 0 && PageName != "default.aspx") { Response.Redirect("default.aspx"); } else { Session["Permission"] = dsAccessLevel.Tables[0].Select("MenuUrl='" + PageName + "'"); // safhei ke vared shodim kolie etleate access level ra be ma midahad rajebe an safhe } DataRow[] drAccess = dsAccessLevel.Tables[0].Select("ShowInMenuList = 0 "); foreach (DataRow row in drAccess) { dsAccessLevel.Tables[0].Rows.Remove(row); } return(dsAccessLevel.Tables[0]); }
public IHttpActionResult FillOtherImagesOfDefineDetailProductByIDX(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); FileTypes ft = new FileTypes(); Bis.AttachCrmInterfaceMethod bisAttachCrmInterfaceMethod = new Bis.AttachCrmInterfaceMethod(); ViewModel.Search AttachCrmInterfaceSearch = new ViewModel.Search(); AttachCrmInterfaceSearch.Filter = " and tblDefineDetailProduct.IDX = " + JsonObject["IDXDefineDetailProduct"].ToString().StringToInt(); foreach (object img in ft.imgType()) { int index = ft.imgType().IndexOf(img); if (index == 0) { AttachCrmInterfaceSearch.Filter += " and (tblAttachSite.FileType = '" + img.ToString() + "' or "; } else if (index == ft.imgType().Count - 1) { AttachCrmInterfaceSearch.Filter += " tblAttachSite.FileType = '" + img.ToString() + "')"; } else { AttachCrmInterfaceSearch.Filter += " tblAttachSite.FileType = '" + img.ToString() + "' or "; } } AttachCrmInterfaceSearch.Order = "Order By tblAttachCrmInterface.[Order]"; AttachCrmInterfaceSearch.JsonResult = " FOR JSON PATH"; JArray JsonAttachCrmInterface = bisAttachCrmInterfaceMethod.GetAttachCrmInterfaceJsonData_DefineDetailProductSite(AttachCrmInterfaceSearch); return(Ok(JsonAttachCrmInterface)); } catch { return(NotFound()); } }
protected void btnEditAccessoryCategory_Click(object sender, EventArgs e) { try { hfModeAccessoryCategory.Value = "Edit"; ViewModel.Search searchAccessoryCategory = new ViewModel.Search(); searchAccessoryCategory.Filter = " And tblAccessoryCategory.IDAccessoryCategory='" + hfIDAccessoryCategory.Value + "'"; DataSet ds = BisAccessoryCategory.GetAccessoryCategoryData(searchAccessoryCategory); if (!ds.Null_Ds()) { txtAccessoryName_En.Text = ds.ReturnDataSetField("Name_En"); txtAccessoryName_Fa.Text = ds.ReturnDataSetField("Name_Fa"); txtSort.Text = ds.ReturnDataSetField("Sort"); TreeDropDownEdit.SelectNode(ds.ReturnDataSetField("IDParent")); ScriptManager.RegisterClientScriptBlock(this, GetType(), "CloseModal", "$('#ModalNavigationOnAccessory').modal('hide');", true); } else { ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "Succsess", " bootbox.alert({message: \"<p dir='rtl' style='color:#004179;font-size:17px;'> اشکال در برقراری ارتباط با دیتابیس!</p>\",title: \"<p style='text-align:right;direction:rtl'>خطا</p>\"});", true); } } catch { ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "Succsess", " bootbox.alert({message: \"<p dir='rtl' style='color:#004179;font-size:17px;'> اشکال در برقراری ارتباط با دیتابیس!</p>\",title: \"<p style='text-align:right;direction:rtl'>خطا</p>\"});", true); } }
public bool checkTechnicalProperty(Guid IDTechnicalProperty, Guid IDDetailTechnicalProperty) { ViewModel.Search DetailTechnicalPropertySearch = new ViewModel.Search(); switch (hfModeDetailTechnicalProperty.Value) { case "New": DetailTechnicalPropertySearch.Filter = " and tblDetailTechnicalProperty.IDRet ='" + hfIDRet.Value + "' and tblDetailTechnicalProperty.IDTechnicalProperty ='" + hfTechnicalPropertyAutoComplete.Value + "' "; break; case "Edit": DetailTechnicalPropertySearch.Filter = " and tblDetailTechnicalProperty.IDDetailTechnicalProperty <> '" + IDDetailTechnicalProperty + "' and tblDetailTechnicalProperty.IDRet ='" + hfIDRet.Value + "' and tblDetailTechnicalProperty.IDTechnicalProperty ='" + hfTechnicalPropertyAutoComplete.Value + "'"; break; } DataSet ds = BisDetailTechnicalProperty.GetDetailTechnicalPropertyData(DetailTechnicalPropertySearch); if (ds.Null_Ds()) { return(true); } else { return(false); //tekrari ast } }
public void SetDropDownsFromEdit(string IDCity) { if (IDCity != Guid.Empty.ToString()) { drpCity.Enabled = true; drpState.Enabled = true; //city ViewModel.Search searchCity = new ViewModel.Search(); searchCity.Filter = " and tblCity.IDCity= '" + IDCity + "'"; DataSet dsCity = bisCity.GetCityData(searchCity); fillCity(dsCity.ReturnDataSetField("IDState")); drpCity.SelectedValue = dsCity.ReturnDataSetField("IDCity"); //state ViewModel.Search searchState = new ViewModel.Search(); searchState.Filter = " and tblState.IDState= '" + dsCity.ReturnDataSetField("IDState") + "'"; DataSet dsState = bisState.GetStateData(searchState); fillState(dsState.ReturnDataSetField("IDCountry")); drpState.SelectedValue = dsState.ReturnDataSetField("IDState"); //country drpCountry.SelectedValue = dsState.ReturnDataSetField("IDCountry"); } else { CleanDropDowns(); } }
public void newFieldsMembers() { ViewModel.Search searchCompanyFormember = new ViewModel.Search(); searchCompanyFormember.Filter = " and tblLegalUser.IDUser = '******'"; DataSet ds = BisLegalUser.GetSupplierData(searchCompanyFormember); CasscadDropDownCountryPersonelSupplier.CleanDropDowns(); txtFName.Text = ""; txtLName.Text = ""; txtDescriptionRealUser.Text = ""; txtDescription_EnRealUser.Text = ""; txtMemberMeliCode.Text = ""; txtMemberIdentifyNumber.Text = ""; txtMemberWebsite.Text = ""; lblOrganizationPost.Text = ""; if (tvOrganizationPost.SelectedNode != null) { tvOrganizationPost.SelectedNode.Selected = false; } chkMemberActive.Checked = true; rbSex.SelectedValue = "0";//مرد divMembers.Visible = true; divTableMembers.Visible = false; }
public void fillGrdAttachCrmInterface(string IDRet, string PartName) { switch (PartName) { case "Product": ViewModel.Search getAttachProduct = new ViewModel.Search(); getAttachProduct.Filter = " and tblAttachCrmInterface.IDRet='" + IDRet + "'"; getAttachProduct.Order = " order by tblAttachCrmInterface.[Order] "; DataSet dsAttachProduct = bisAttachCrmInterfaceMethod.GetAttachCrmInterfaceData_ProductSite(getAttachProduct); grdAttachCrmInterface.DataSource = dsAttachProduct; grdAttachCrmInterface.DataBind(); Session["dsAttachSite"] = dsAttachProduct; Session["dsAttachSiteIndex"] = dsAttachProduct; break; case "DefineDetailProduct": ViewModel.Search getAttachDefineDetailProduct = new ViewModel.Search(); getAttachDefineDetailProduct.Filter = " and tblAttachCrmInterface.IDRet='" + IDRet + "'"; getAttachDefineDetailProduct.Order = " order by tblAttachCrmInterface.[Order] "; DataSet dsAttachDefineDetailProduct = bisAttachCrmInterfaceMethod.GetAttachCrmInterfaceData_DefineDetailProductSite(getAttachDefineDetailProduct); grdAttachCrmInterface.DataSource = dsAttachDefineDetailProduct; grdAttachCrmInterface.DataBind(); Session["dsAttachSite"] = dsAttachDefineDetailProduct; Session["dsAttachSiteIndex"] = dsAttachDefineDetailProduct; break; } }
public IHttpActionResult AddPersonelInCompany(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); ViewModel.tblPersonelInCompany NewPersonelInCompany = JsonObject.ToObject <ViewModel.tblPersonelInCompany>(); ViewModel.Search PersonelInCompanySearch = new ViewModel.Search(); PersonelInCompanySearch.Filter = " AND tblPersonelInCompany.NationalCode = '" + NewPersonelInCompany.NationalCode + "'"; PersonelInCompanySearch.JsonResult = " FOR JSON PATH "; JArray JsonPersonelInCompany = BisPersonelInCompany.GetPersonelInCompanyJsonData(PersonelInCompanySearch); if (JsonPersonelInCompany.HasValues) { return(NotFound()); } byte[] imageBytes = Convert.FromBase64String(JsonObject["PicFile"].ToString().Split(',')[1]); MemoryStream ms = new MemoryStream(imageBytes, 0, imageBytes.Length); ms.Write(imageBytes, 0, imageBytes.Length); Image imagePersonelInCompany = Image.FromStream(ms); FileTypes ft = new FileTypes(); string FileType = ft.FindImageTypeInString(JsonObject["PicFile"].ToString().Split(',')[0]); if (imageBytes.Length < 1024 * 1024 && ft.IsImage(FileType)) { string FileUrl = @"Picture\PersonelInCompany\" + NewPersonelInCompany.IDPersonelInCompany + FileType; NewPersonelInCompany.PicUrl = FileUrl; bool retAdd = BisPersonelInCompany.AddPersonelInCompany(NewPersonelInCompany); if (retAdd) { try { imagePersonelInCompany.Save(AppDomain.CurrentDomain.BaseDirectory + FileUrl); return(Ok(retAdd)); } catch (Exception) { ViewModel.tblPersonelInCompany delete = new ViewModel.tblPersonelInCompany(); delete.IDPersonelInCompany = NewPersonelInCompany.IDPersonelInCompany; bool retDelete = BisPersonelInCompany.DeletePersonelInCompany(delete); return(NotFound()); } } else { return(NotFound()); } } else { return(NotFound()); } } catch { return(NotFound()); } }
public void FillGrdProductFamily() { ViewModel.Search ProductFamilySearch = new ViewModel.Search(); DataSet dsProductFamily = BisProductFamily.GetProductFamilyData(ProductFamilySearch); grdProductFamily.DataSource = dsProductFamily; grdProductFamily.DataBind(); }
protected void GetSupplierName(Guid IDSupplier) { ViewModel.Search getSupplier = new ViewModel.Search(); getSupplier.Filter = " and tblLegalUser.IDUser = '******'"; DataSet dsSupplier = BisLegalUser.GetSupplierData(getSupplier); lblSupplierNameList.Text = lblSupplierNameNew.Text = dsSupplier.ReturnDataSetField("Name_Fa"); }
public void InitialDataSource() { ViewModel.Search SearchContentCategory = new ViewModel.Search(); SearchContentCategory.Filter = " AND tblContentCategory.IDParent = '" + Guid.Empty + "'"; DataSet dsContentCategory = BisContentCategory.GetContentCategoryData(SearchContentCategory); rptContentCategory.DataSource = dsContentCategory; rptContentCategory.DataBind(); }
public void fillGrdBanner() { ViewModel.Search BannerSearch = new ViewModel.Search(); BannerSearch.Filter = "ORDER BY tblBanner.Sort"; DataSet dsBanner = BisBanner.GetBannerData(BannerSearch); grdBanner.DataSource = dsBanner; grdBanner.DataBind(); }
protected void grdMember_RowCommand(object sender, GridViewCommandEventArgs e) { Guid IDRealUser = e.CommandArgument.ToString().StringToGuid(); switch (e.CommandName) { case "Edit": try { divMembers.Visible = true; divTableMembers.Visible = false; hfIDRealUser.Value = IDRealUser.ToString(); ViewModel.Search RealUserSearch = new ViewModel.Search(); RealUserSearch.Filter = " and tblRealUser.IDUser ='******'"; DataSet ds = BisRealUser.GetRealUserSupplierData(RealUserSearch); if (!ds.Null_Ds()) { CasscadDropDownCountryPersonelSupplier.SetDropDownsFromEdit(ds.ReturnDataSetField("IDCity")); txtFName.Text = ds.ReturnDataSetField("FName"); txtLName.Text = ds.ReturnDataSetField("LName"); chkMemberActive.Checked = ds.ReturnDataSetField("Active").StringToBool(); txtDescriptionRealUser.Text = ds.ReturnDataSetField("Description_Fa"); txtDescription_EnRealUser.Text = ds.ReturnDataSetField("Description_En"); txtMemberWebsite.Text = ds.ReturnDataSetField("WebSite"); txtMemberIdentifyNumber.Text = ds.ReturnDataSetField("IdentifyNumber"); txtMemberMeliCode.Text = ds.ReturnDataSetField("NationalCode"); lblOrganizationPost.Text = GenerateOrganizationalPosition(ds.ReturnDataSetField("IDOrganizationPosition")); tvOrganizationPost.SelectedNodeExtension(ds.ReturnDataSetField("IDOrganizationPosition")); if (ds.ReturnDataSetField("Sex") == "True") { rbSex.SelectedValue = "1"; //زن } else { rbSex.SelectedValue = "0"; //مرد } hfModeRealUser.Value = "Edit"; divMembers.Visible = true; divTableMembers.Visible = false; } else { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorMessage", "alert('اشکال در واکشی اطلاعات!');", true); } } catch { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorMessage", "alert('اشکال در برقراری ارتباط با دیتابیس!');", true); } break; } }
public void fillgrdTechnicalProperty() { ViewModel.Search PropertySearch = new ViewModel.Search(); DataSet dsProperty = BisTechnicalProperty.GetTechnicalPropertyData(PropertySearch); grdTechnicalProperty.DataSource = dsProperty; grdTechnicalProperty.DataBind(); Session["dsProperty"] = dsProperty; Session["dsPropertyIndex"] = dsProperty; }
public void fillGrdLegalUser() { ViewModel.Search LegalUserSearch = new ViewModel.Search(); DataSet dsLegalUser = BisLegalUser.GetSupplierData(LegalUserSearch); grdLegalUser.DataSource = dsLegalUser; grdLegalUser.DataBind(); Session["dsLegalUser"] = dsLegalUser; Session["dsLegalUserIndex"] = dsLegalUser; }
public IHttpActionResult UpdatePersonelInCompany(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); ViewModel.tblPersonelInCompany UpdatePersonelInCompany = JsonObject.ToObject <ViewModel.tblPersonelInCompany>(); string FileUrl = ""; ViewModel.Search PersonelInCompanySearch = new ViewModel.Search(); PersonelInCompanySearch.Filter = " AND tblPersonelInCompany.IDPersonelInCompany ='" + UpdatePersonelInCompany.IDPersonelInCompany + "'"; PersonelInCompanySearch.JsonResult = " FOR JSON PATH "; JArray JsonPersonelInCompany = BisPersonelInCompany.GetPersonelInCompanyJsonData(PersonelInCompanySearch); if (UpdatePersonelInCompany.PicUrl == "" && File.Exists(AppDomain.CurrentDomain.BaseDirectory + JsonPersonelInCompany[0]["PicUrl"].ToString())) { File.Delete(AppDomain.CurrentDomain.BaseDirectory + JsonPersonelInCompany[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 imagePersonelInCompany = 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\PersonelInCompany\" + Guid.NewGuid() + FileType; UpdatePersonelInCompany.PicUrl = FileUrl; imagePersonelInCompany.Save(AppDomain.CurrentDomain.BaseDirectory + FileUrl); } } } bool retUpdate = BisPersonelInCompany.UpdatePersonelInCompany(UpdatePersonelInCompany); if (retUpdate) { return(Ok(retUpdate)); } else { File.Delete(AppDomain.CurrentDomain.BaseDirectory + FileUrl); return(NotFound()); } } catch (Exception ex) { return(NotFound()); } }
protected void grdSupplierCatalog_RowCommand(object sender, GridViewCommandEventArgs e) { Guid IDCatalog = e.CommandArgument.ToString().StringToGuid(); switch (e.CommandName) { case "Delete": try { bool retDel = true; ViewModel.Search SearchCatalog = new ViewModel.Search(); SearchCatalog.Filter = " AND tblCatalog.IDCatalog = '" + IDCatalog + "'"; DataSet dsCatalog = BisCatalog.GetCatalogData(SearchCatalog); try { File.Delete(Server.MapPath("/" + dsCatalog.ReturnDataSetField("PDFUrl"))); } catch { retDel = false; } try { File.Delete(Server.MapPath("/" + dsCatalog.ReturnDataSetField("PicUrl"))); } catch { retDel = false; } if (retDel) { ViewModel.tblCatalog Delete = new ViewModel.tblCatalog(); Delete.IDCatalog = IDCatalog; retDel = BisCatalog.DeleteCatalog(Delete); if (retDel) { FillGrdSupplierCatalog(hfIDLegalUser.Value.StringToGuid()); ScriptManager.RegisterStartupScript(this, GetType(), "ErrorMessage", "alert('حذف اطلاعات با موفقیت انجام شد!');", true); } } else { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorMessage", "alert('اشکال در حذف اطلاعات!');", true); } } catch { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorMessage", "alert('اشکال در برقراری ارتباط با دیتابیس!');", true); } break; } }
public void fillGrdUser() { ViewModel.Search SearchUser = new ViewModel.Search(); SearchUser.Order = "Order by LName "; DataSet dsUser = BisPersonel.GetPersonelData(SearchUser); grdUser.DataSource = dsUser; grdUser.DataBind(); Session["dsUser"] = dsUser; Session["dsUserIndex"] = dsUser; }
public void fillGrdDictionary() { ViewModel.Search SearchDictionary = new ViewModel.Search(); SearchDictionary.Order = "Order by KeyWord "; DataSet dsDictionary = BisDictionary.GetDictionaryData(SearchDictionary); grdDictionary.DataSource = dsDictionary; grdDictionary.DataBind(); Session["dsDictionary"] = dsDictionary; Session["dsDictionaryIndex"] = dsDictionary; }
public void fillGrdRole() { ViewModel.Search SearchRole = new ViewModel.Search(); SearchRole.Order = "Order by Title "; DataSet dsRole = BisRole.GetRoleData(SearchRole); grdRole.DataSource = dsRole; grdRole.DataBind(); Session["dsRole"] = dsRole; Session["dsRoleIndex"] = dsRole; }
public void fillMemberInCompany(Guid IDUser) { ViewModel.Search searchRealUser = new ViewModel.Search(); searchRealUser.Filter = " and tblRealUser.IDLegalUser='******'"; DataSet ds = BisRealUser.GetRealUserSupplierData(searchRealUser); grdMember.DataSource = ds; grdMember.DataBind(); Session["dsRealUser"] = ds; Session["dsRealUserIndex"] = ds; }
public string GenerateOrganizationalPosition(string ParentID) { ViewModel.Search searchOrganizationPosition = new ViewModel.Search(); DataSet ds = bisOrganizationPosition.GetOrganizationalPositionData(searchOrganizationPosition); if (ds.Tables[0].Select("IDOrganizationPosition='" + ParentID + "'").Count() > 0) { strParentGroup += " <i class=\"fa fa-arrow-left\"> </i> " + ds.Tables[0].Select("IDOrganizationPosition='" + ParentID + "'")[0]["Name_Fa"].ToString(); GenerateOrganizationalPosition(ds.Tables[0].Select("IDOrganizationPosition='" + ParentID.ToString() + "'")[0]["ParentID"].ToString()); } return(strParentGroup); }
protected void fillObejctsForEdit(string IDMenu) { ViewModel.Search getMenu = new ViewModel.Search(); getMenu.Filter = " and tblMenu.IDMenu = '" + IDMenu + "'"; DataSet ds = BisMenu.GetMenuData(getMenu); txtEditName_Fa.Text = ds.ReturnDataSetField("Name_Fa"); txtEditName_En.Text = ds.ReturnDataSetField("Name_En"); txtEditOrder.Text = ds.ReturnDataSetField("Order"); txtEditMenuUrl.Text = ds.ReturnDataSetField("MenuUrl"); chkEditActive.Checked = ds.ReturnDataSetField("Active").StringToBool(); }
public void fillGrdProductComment() { ViewModel.Search SearchComment = new ViewModel.Search(); SearchComment.Filter = " and tblComment.IDContent in (select IDProduct from tblProduct)"; SearchComment.Order = " order by CreateDate desc"; DataSet dsProductComment = BisComment.GetCommentData(SearchComment); grdProductComment.DataSource = dsProductComment; grdProductComment.DataBind(); Session["dsProductCommentSearch"] = dsProductComment; Session["dsProductCommentSearchIndex"] = dsProductComment; }