示例#1
0
    protected void lnkDownOrder_Click(object sender, EventArgs e)
    {
        var lnkDownOrder        = (LinkButton)sender;
        var strCareerCategoryID = lnkDownOrder.Attributes["rel"];
        var oCareerCategory     = new CareerCategory();

        oCareerCategory.CareerCategoryDownOrder(strCareerCategoryID);
        RadGrid1.Rebind();
    }
示例#2
0
        //public string PutSessionReportDTL(SessionReportModel obj)
        //{
        //    try
        //    {
        //        using (SqlConnection con = new SqlConnection(connectionString))
        //        {
        //            SqlCommand cmd = new SqlCommand("SP_Insert_Udate_Delete_SessionReport", con);
        //            cmd.CommandType = CommandType.StoredProcedure;
        //            cmd.Parameters.AddWithValue("@Type", "UPDATE");
        //            cmd.Parameters.AddWithValue("@CDF_ID", obj.CDF_ID);
        //            cmd.Parameters.AddWithValue("@Session_ID", obj.Session_ID);
        //            cmd.Parameters.AddWithValue("@ReportVersion", obj.ReportVersion);
        //            cmd.Parameters.AddWithValue("@ReportStatus", obj.ReportStatus);
        //            cmd.Parameters.AddWithValue("@ReportPreparedBy", obj.ReportPreparedBy);
        //            cmd.Parameters.AddWithValue("@Stud_Strengths", obj.Stud_Strengths);
        //            cmd.Parameters.AddWithValue("@Stud_Personality_Traits", obj.Stud_Personality_Traits);
        //            cmd.Parameters.AddWithValue("@AreaAdvantage", obj.AreaAdvantage);
        //            cmd.Parameters.AddWithValue("@Motivators", obj.Motivators);
        //            cmd.Parameters.AddWithValue("@GeneralAbilities", obj.GeneralAbilities);
        //            cmd.Parameters.AddWithValue("@LeadershipType", obj.LeadershipType);
        //            cmd.Parameters.AddWithValue("@WaySetGoals", obj.WaySetGoals);
        //            cmd.Parameters.AddWithValue("@WayStudy", obj.WayStudy);
        //            cmd.Parameters.AddWithValue("@WayCommunicate", obj.WayCommunicate);
        //            cmd.Parameters.AddWithValue("@MentalAbilities", obj.MentalAbilities);
        //            cmd.Parameters.AddWithValue("@Creativities", obj.Creativities);
        //            cmd.Parameters.AddWithValue("@PhysicalAbilities", obj.PhysicalAbilities);
        //            cmd.Parameters.AddWithValue("@Skills", obj.Skills);
        //            cmd.Parameters.AddWithValue("@CareerCategory", obj.CareerCategory);
        //            cmd.Parameters.AddWithValue("@OccupationalCategory", obj.OccupationalCategory);
        //            cmd.Parameters.AddWithValue("@Career", obj.Career);
        //            cmd.Parameters.AddWithValue("@Recommendations", obj.Recommendations);
        //            con.Open();
        //            int i = cmd.ExecuteNonQuery();
        //            if (i > 0)
        //            {
        //                return "Success";
        //            }
        //            else
        //            {
        //                return "Fail";
        //            }

        //        }

        //    }
        //    catch (Exception ex)
        //    {
        //        Log.Error(ex);
        //        return "Fail";
        //    }
        //}

        public List <CareerCategory> CareerCategory(int ca_id)
        {
            try
            {
                using (SqlConnection con = new SqlConnection(conString))
                {
                    List <CareerCategory> li  = new List <CareerCategory>();
                    SqlCommand            cmd = new SqlCommand("SP_DDLCareers", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@Type", "CareerCategories");
                    cmd.Parameters.AddWithValue("@ca_Id", ca_id);
                    con.Open();
                    SqlDataReader da = cmd.ExecuteReader();
                    if (da.HasRows)
                    {
                        while (da.Read())
                        {
                            CareerCategory obj = new CareerCategory();
                            obj.Category = da["Career_category"].ToString();
                            li.Add(obj);
                        }
                        con.Close();
                        return(li);
                    }
                    else
                    {
                        con.Close();
                        return(null);
                    }
                }
            }
            catch (Exception ex)
            {
                Log.Error(ex);
                return(null);
            }
        }
示例#3
0
    protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
    {
        if (e.CommandName == "QuickUpdate")
        {
            string CareerCategoryID, IsShowOnMenu, IsShowOnHomePage, IsAvailable;
            var    oCareerCategory = new CareerCategory();

            foreach (GridDataItem item in RadGrid1.Items)
            {
                CareerCategoryID = item.GetDataKeyValue("CareerCategoryID").ToString();
                IsShowOnMenu     = ((CheckBox)item.FindControl("chkIsShowOnMenu")).Checked.ToString();
                IsShowOnHomePage = ((CheckBox)item.FindControl("chkIsShowOnHomePage")).Checked.ToString();
                IsAvailable      = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();

                oCareerCategory.CareerCategoryQuickUpdate(
                    CareerCategoryID,
                    IsShowOnMenu,
                    IsShowOnHomePage,
                    IsAvailable
                    );
            }
        }
        else if (e.CommandName == "DeleteSelected")
        {
            var oCareerCategory = new CareerCategory();
            var errorList       = "";

            foreach (GridDataItem item in RadGrid1.SelectedItems)
            {
                var isChildCategoryExist = oCareerCategory.CareerCategoryIsChildrenExist(item.GetDataKeyValue("CareerCategoryID").ToString());
                var CareerCategoryName   = ((Label)item.FindControl("lblCareerCategoryName")).Text;
                var CareerCategoryNameEn = ((Label)item.FindControl("lblCareerCategoryNameEn")).Text;
                if (isChildCategoryExist)
                {
                    errorList += ", " + CareerCategoryName;
                }
                else
                {
                    string strImageName = ((HiddenField)item.FindControl("hdnImageName")).Value;

                    if (!string.IsNullOrEmpty(strImageName))
                    {
                        string strSavePath = Server.MapPath("~/res/careercategory/" + strImageName);
                        if (File.Exists(strSavePath))
                        {
                            File.Delete(strSavePath);
                        }
                    }
                }
            }
            if (!string.IsNullOrEmpty(errorList))
            {
                e.Canceled = true;
                string strAlertMessage = "Danh mục <b>\"" + errorList.Remove(0, 1).Trim() + "\"</b> đang có danh mục con hoặc sản phẩm.<br /> Xin xóa danh mục con hoặc sản phẩm trong danh mục này hoặc thiết lập hiển thị = \"không\".";
                lblError.Text = strAlertMessage;
            }
        }
        else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
        {
            var command       = e.CommandName;
            var row           = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
            var FileImageName = (RadUpload)row.FindControl("FileImageName");

            string strCareerCategoryName          = ((RadTextBox)row.FindControl("txtCareerCategoryName")).Text.Trim();
            string strCareerCategoryNameEn        = ((RadTextBox)row.FindControl("txtCareerCategoryNameEn")).Text.Trim();
            string strConvertedCareerCategoryName = Common.ConvertTitle(strCareerCategoryName);
            string strDescription       = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtDescription")).Content.Trim()));
            string strDescriptionEn     = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtDescriptionEn")).Content.Trim()));
            string strContent           = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContent")).Content.Trim()));
            string strContentEn         = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContentEn")).Content.Trim()));
            string strMetaTitle         = ((RadTextBox)row.FindControl("txtMetaTitle")).Text.Trim();
            string strMetaTitleEn       = ((RadTextBox)row.FindControl("txtMetaTitleEn")).Text.Trim();
            string strMetaDescription   = ((RadTextBox)row.FindControl("txtMetaDescription")).Text.Trim();
            string strMetaDescriptionEn = ((RadTextBox)row.FindControl("txtMetaDescriptionEn")).Text.Trim();
            string strImageName         = FileImageName.UploadedFiles.Count > 0 ? FileImageName.UploadedFiles[0].GetName() : "";
            string strParentID          = ((RadComboBox)row.FindControl("ddlParent")).SelectedValue;
            string strIsAvailable       = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
            string strIsShowOnMenu      = ((CheckBox)row.FindControl("chkIsShowOnMenu")).Checked.ToString();
            string strIsShowOnHomePage  = ((CheckBox)row.FindControl("chkIsShowOnHomePage")).Checked.ToString();


            var oCareerCategory = new CareerCategory();

            if (e.CommandName == "PerformInsert")
            {
                strImageName = oCareerCategory.CareerCategoryInsert(
                    strCareerCategoryName,
                    strCareerCategoryNameEn,
                    strConvertedCareerCategoryName,
                    strDescription,
                    strDescriptionEn,
                    strContent,
                    strContentEn,
                    strMetaTitle,
                    strMetaTitleEn,
                    strMetaDescription,
                    strMetaDescriptionEn,
                    strImageName,
                    strParentID,
                    strIsShowOnMenu,
                    strIsShowOnHomePage,
                    strIsAvailable
                    );

                string strFullPath = "~/res/careercategory/" + strImageName;

                if (!string.IsNullOrEmpty(strImageName))
                {
                    FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
                    ResizeCropImage.ResizeByCondition(strFullPath, 40, 40);
                }
                RadGrid1.Rebind();
            }
            else
            {
                var dsUpdateParam       = ObjectDataSource1.UpdateParameters;
                var strCareerCategoryID = row.GetDataKeyValue("CareerCategoryID").ToString();
                var strOldImageName     = ((HiddenField)row.FindControl("hdnImageName")).Value;
                var strOldImagePath     = Server.MapPath("~/res/careercategory/" + strOldImageName);

                dsUpdateParam["CareerCategoryName"].DefaultValue          = strCareerCategoryName;
                dsUpdateParam["CareerCategoryNameEn"].DefaultValue        = strCareerCategoryNameEn;
                dsUpdateParam["ConvertedCareerCategoryName"].DefaultValue = strConvertedCareerCategoryName;
                dsUpdateParam["Description"].DefaultValue      = strDescription;
                dsUpdateParam["DescriptionEn"].DefaultValue    = strDescriptionEn;
                dsUpdateParam["Content"].DefaultValue          = strContent;
                dsUpdateParam["ContentEn"].DefaultValue        = strContentEn;
                dsUpdateParam["ImageName"].DefaultValue        = strImageName;
                dsUpdateParam["ParentID"].DefaultValue         = strParentID;
                dsUpdateParam["IsShowOnMenu"].DefaultValue     = strIsShowOnMenu;
                dsUpdateParam["IsShowOnHomePage"].DefaultValue = strIsShowOnHomePage;
                dsUpdateParam["IsAvailable"].DefaultValue      = strIsAvailable;

                if (!string.IsNullOrEmpty(strImageName))
                {
                    var strFullPath = "~/res/careercategory/" + strConvertedCareerCategoryName + "-" + strCareerCategoryID + strImageName.Substring(strImageName.LastIndexOf('.'));

                    if (File.Exists(strOldImagePath))
                    {
                        File.Delete(strOldImagePath);
                    }

                    FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
                    ResizeCropImage.ResizeByCondition(strFullPath, 40, 40);
                }
            }
        }
        if (e.CommandName == "DeleteImage")
        {
            var oCareerCategory = new CareerCategory();
            var lnkDeleteImage  = (LinkButton)e.CommandSource;
            var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
            var strCareerCategoryID = s[0];
            var strImageName        = s[1];

            oCareerCategory.CareerCategoryImageDelete(strCareerCategoryID);
            DeleteImage(strImageName);
            RadGrid1.Rebind();
        }
    }