Example #1
0
 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);
     }
 }
Example #2
0
        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);
        }
Example #3
0
 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];
 }
Example #4
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   = "";
        }
Example #5
0
 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;
     }
 }
Example #6
0
        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);
            }
        }
Example #7
0
        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]);
        }
Example #8
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());
     }
 }
Example #9
0
 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);
     }
 }
Example #10
0
        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
            }
        }
Example #11
0
        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();
            }
        }
Example #12
0
        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;
        }
Example #13
0
        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;
            }
        }
Example #14
0
        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());
            }
        }
Example #15
0
        public void FillGrdProductFamily()
        {
            ViewModel.Search ProductFamilySearch = new ViewModel.Search();
            DataSet          dsProductFamily     = BisProductFamily.GetProductFamilyData(ProductFamilySearch);

            grdProductFamily.DataSource = dsProductFamily;
            grdProductFamily.DataBind();
        }
Example #16
0
        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");
        }
Example #17
0
        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();
        }
Example #18
0
        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();
        }
Example #19
0
        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;
            }
        }
Example #20
0
        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;
        }
Example #21
0
        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;
        }
Example #22
0
        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());
            }
        }
Example #23
0
        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;
            }
        }
Example #24
0
        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;
        }
Example #25
0
        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;
        }
Example #26
0
        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;
        }
Example #27
0
        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;
        }
Example #28
0
        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);
        }
Example #29
0
        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();
        }
Example #30
0
        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;
        }