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