public CareerOpportunityInfo getCareerOpportunity(int ID)
{
CareerOpportunityInfo careerinfo = new CareerOpportunityInfo();
dbAccess.open();
try
{
string sql = "select * from [CareerOpportunity] where ID = " + ID.ToString();
System.Data.DataTable dt = dbAccess.select(sql);
careerinfo.Type = Convert.ToInt32(dt.Rows[0]["Type"].ToString());
careerinfo.VersionNo = Convert.ToSingle(dt.Rows[0]["VersionNo"]);
careerinfo.SerialNo = dt.Rows[0]["SerialNo"].ToString();
careerinfo.Division = Convert.ToInt32(dt.Rows[0]["Division"]);
careerinfo.Department = Convert.ToInt32(dt.Rows[0]["Department"]);
careerinfo.CareerLevel = dt.Rows[0]["CareerLevel"].ToString();
careerinfo.CreateBy = Convert.ToInt32(dt.Rows[0]["CreateBy"]);
careerinfo.Details = dt.Rows[0]["Details"].ToString();
careerinfo.Email = dt.Rows[0]["Email"].ToString();
careerinfo.EmploymentType = Convert.ToInt32(dt.Rows[0]["EmploymentType"]);
careerinfo.Experience = Convert.ToSingle(dt.Rows[0]["Experience"]);
careerinfo.JobFunction = Convert.ToInt32(dt.Rows[0]["JobFunction"]);
careerinfo.Location = dt.Rows[0]["Location"].ToString();
careerinfo.Qualification = Convert.ToInt32(dt.Rows[0]["Qualification"]);
careerinfo.Disclaimer = dt.Rows[0]["Disclaimer "].ToString();
//careerinfo.Salary = Convert.ToInt32(dt.Rows[0]["Salary"]);
careerinfo.Status = dt.Rows[0]["Status"].ToString();
//new icon
sql = string.Format("select ExpiryDate from [NewIconControl] where ParentID = {0} and Category = '{1}' ",
ID, GlobalSetting.ArticleCategory.Career);
dt = dbAccess.select(sql);
if (dt.Rows.Count == 1)
{
careerinfo.NewIconInfo = new NewIconInfo();
careerinfo.NewIconInfo.ExpiryDate = Convert.ToDateTime(dt.Rows[0]["ExpiryDate"]);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbAccess.close();
}
return(careerinfo);
}
protected void Page_Load(object sender, EventArgs e)
{
int ID = Convert.ToInt32(Request.QueryString["ID"]);
trainingID.Value = ID.ToString();
CareerOpportunity careerOpportunityHandler = new CareerOpportunity();
CareerOpportunityInfo careerOpportunityInfo = careerOpportunityHandler.getCareerOpportunity(ID);
txtCareerLevel.InnerText = careerOpportunityInfo.CareerLevel;
txtQualification.InnerText = SystemPara.getDescription(careerOpportunityInfo.Qualification);
txtDetails.InnerHtml = careerOpportunityInfo.Details;
txtEmail.HRef = "mailto:" + careerOpportunityInfo.Email;
txtEmail.InnerText = careerOpportunityInfo.Email;
txtExp.InnerText = careerOpportunityInfo.Experience.ToString();
txtJobFunction.InnerText = SystemPara.getDescription(careerOpportunityInfo.JobFunction);
txtDivision.InnerText = SystemPara.getDescription(careerOpportunityInfo.Division);
txtDepartment.InnerText = SystemPara.getDescription(careerOpportunityInfo.Department);
txtLocation.InnerText = careerOpportunityInfo.Location;
//txtQualification.InnerText = SystemPara.getDescription(careerOpportunityInfo.Qualification);
// txtSalary.InnerText = careerOpportunityInfo.Salary.ToString();
txtType.InnerText = SystemPara.getDescription(careerOpportunityInfo.EmploymentType);
txtDisclaimer.InnerText = careerOpportunityInfo.Disclaimer;
}
protected void initCareer(int ID)
{
hdfID.Value = ID.ToString();
CareerOpportunity careerOpportunity = new CareerOpportunity();
CareerOpportunityInfo careerOpportunityInfo = careerOpportunity.getCareerOpportunity(ID);
txtVersionNo.InnerText = careerOpportunityInfo.VersionNo.ToString("N");
string[] serialNoArray = careerOpportunityInfo.SerialNo.Split('-');
txtSerialNo0.InnerText = serialNoArray[0] + "-" + serialNoArray[1];
txtSerialNo1.Value = serialNoArray[2];
txtSerialNo2.Value = serialNoArray[3];
//comType.Value = careerOpportunityInfo.Type;
//new icon
if (careerOpportunityInfo.NewIconInfo != null)
{
txtIconExpiryDay.Value = careerOpportunityInfo.NewIconInfo.ExpiryDate.ToString(GlobalSetting.DateTimeFormat);
}
bool isAbandoned = true;
foreach (ListItem item in comType.Items)
{
if (item.Value == careerOpportunityInfo.Type.ToString())
{
item.Selected = true;
isAbandoned = false;
break;
}
else
{
item.Selected = false;
}
}
if (isAbandoned)
{
string description = SystemPara.getDescription(careerOpportunityInfo.Type);
comType.Items.Add(new ListItem(description, careerOpportunityInfo.Type.ToString()));
comType.Value = careerOpportunityInfo.Type.ToString();
}
txtCareerLevel.Value = careerOpportunityInfo.CareerLevel;
txtExp.Value = (careerOpportunityInfo.Experience + 100.001).ToString().Substring(1, 5);
//comQualification.Value = careerOpportunityInfo.Qualification.ToString();
isAbandoned = true;
foreach (ListItem item in comQualification.Items)
{
if (item.Value == careerOpportunityInfo.Qualification.ToString())
{
item.Selected = true;
isAbandoned = false;
break;
}
else
{
item.Selected = false;
}
}
if (isAbandoned)
{
string description = SystemPara.getDescription(careerOpportunityInfo.Qualification);
comQualification.Items.Add(new ListItem(description, careerOpportunityInfo.Qualification.ToString()));
comQualification.Value = careerOpportunityInfo.Qualification.ToString();
}
/////---------------1
isAbandoned = true;
foreach (ListItem item in txtJobFunction.Items)
{
if (item.Value == careerOpportunityInfo.JobFunction.ToString())
{
item.Selected = true;
isAbandoned = false;
break;
}
else
{
item.Selected = false;
}
}
if (isAbandoned)
{
string description = SystemPara.getDescription(careerOpportunityInfo.JobFunction);
txtJobFunction.Items.Add(new ListItem(description, careerOpportunityInfo.JobFunction.ToString()));
txtJobFunction.Value = careerOpportunityInfo.JobFunction.ToString();
}
/////---------------
/////---------------2
isAbandoned = true;
foreach (ListItem item in txtDivision.Items)
{
if (item.Value == careerOpportunityInfo.Division.ToString())
{
item.Selected = true;
isAbandoned = false;
break;
}
else
{
item.Selected = false;
}
}
if (isAbandoned)
{
string description = SystemPara.getDescription(careerOpportunityInfo.Division);
txtDivision.Items.Add(new ListItem(description, careerOpportunityInfo.Division.ToString()));
txtDivision.Value = careerOpportunityInfo.Division.ToString();
}
/////---------------
/////---------------3
isAbandoned = true;
foreach (ListItem item in txtDepartment.Items)
{
if (item.Value == careerOpportunityInfo.Department.ToString())
{
item.Selected = true;
isAbandoned = false;
break;
}
else
{
item.Selected = false;
}
}
if (isAbandoned)
{
string description = SystemPara.getDescription(careerOpportunityInfo.Department);
txtDepartment.Items.Add(new ListItem(description, careerOpportunityInfo.Department.ToString()));
txtDepartment.Value = careerOpportunityInfo.Department.ToString();
}
/////---------------
/////---------------4
isAbandoned = true;
foreach (ListItem item in txtType.Items)
{
if (item.Value == careerOpportunityInfo.EmploymentType.ToString())
{
item.Selected = true;
isAbandoned = false;
break;
}
else
{
item.Selected = false;
}
}
if (isAbandoned)
{
string description = SystemPara.getDescription(careerOpportunityInfo.EmploymentType);
txtType.Items.Add(new ListItem(description, careerOpportunityInfo.EmploymentType.ToString()));
txtType.Value = careerOpportunityInfo.EmploymentType.ToString();
}
/////---------------
//txtJobFunction.Value = careerOpportunityInfo.JobFunction;
//txtDivision.Value = careerOpportunityInfo.Division;
//txtDepartment.Value = careerOpportunityInfo.Department;
txtLocation.Value = careerOpportunityInfo.Location;
//txtType.Value = careerOpportunityInfo.EmploymentType;
txtEmail.Value = careerOpportunityInfo.Email;
txtDetails.Value = careerOpportunityInfo.Details;
txtDisclaimer.Value = careerOpportunityInfo.Disclaimer;
}
public void update(CareerOpportunityInfo careeroppty)
{
string sql = " UPDATE [CareerOpportunity]"
+ " SET [Type] = @Type"
+ " ,[VersionNo] = @VersionNo"
+ " ,[SerialNo] = @SerialNo"
+ " ,[JobFunction] = @JobFunction"
+ " ,[Experience] = @Experience"
+ " ,[CareerLevel] = @CareerLevel"
+ " ,[Qualification] = @Qualification"
+ " ,[Division] = @Division"
+ " ,[Department] = @Department"
+ " ,[Location] = @Location"
+ " ,[EmploymentType] = @EmploymentType"
+ " ,[Email] = @Email"
+ " ,[Details] = @Details "
+ " ,[Disclaimer] = @Disclaimer "
+ " ,[UpdateDate] = getDate() "
+ " ,[UpdateBy] = @UpdateBy "
+ " WHERE ID=@ID";
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("@Type", careeroppty.Type);
dict.Add("@VersionNo", careeroppty.VersionNo);
dict.Add("@SerialNo", careeroppty.SerialNo);
dict.Add("@JobFunction", careeroppty.JobFunction);
dict.Add("@Experience", careeroppty.Experience);
dict.Add("@CareerLevel", careeroppty.CareerLevel);
dict.Add("@Qualification", careeroppty.Qualification);
dict.Add("@Division", careeroppty.Division);
dict.Add("@Department", careeroppty.Department);
dict.Add("@Location", careeroppty.Location);
dict.Add("@EmploymentType", careeroppty.EmploymentType);
dict.Add("@Email", careeroppty.Email);
dict.Add("@Details", careeroppty.Details);
dict.Add("@Disclaimer", careeroppty.Disclaimer);
dict.Add("@UpdateBy", careeroppty.UpdateBy);
dict.Add("@ID", careeroppty.ID);
this.dbAccess.open();
try
{
this.dbAccess.BeginTransaction();
this.dbAccess.update(sql, dict);
#region New Icon
//delete the information of "New" icon before insert
string sql_icon_delete = "delete from [NewIconControl] where Category=@Category and ParentID = @ParentID";
dict = new Dictionary <string, object>();
dict.Add("@Category", GlobalSetting.ArticleCategory.Career);
dict.Add("@ParentID", careeroppty.ID);
this.dbAccess.update(sql_icon_delete, dict);
//insert the information of "New" icon
string sql_icon = "INSERT INTO [NewIconControl] "
+ "([Category], [ParentID], [ExpiryDate]) VALUES "
+ "(@Category, @ParentID, @ExpiryDate)";
if (careeroppty.NewIconInfo != null)
{
dict = new Dictionary <string, object>();
dict.Add("@Category", careeroppty.NewIconInfo.Category);
dict.Add("@ParentID", careeroppty.ID);
dict.Add("@ExpiryDate", careeroppty.NewIconInfo.ExpiryDate);
this.dbAccess.update(sql_icon, dict);
}
#endregion
this.dbAccess.Commit();
}
catch (Exception ex)
{
this.dbAccess.rollback();
throw ex;
}
finally
{
this.dbAccess.close();
}
}
public List <CareerOpportunityInfo> getLatestCareerOpportunities(int total)
{
List <CareerOpportunityInfo> list = new List <CareerOpportunityInfo>();
CareerOpportunityInfo careerOpportunityInfo;
dbAccess.open();
try
{
string sql;
if (total != 0)
{
sql = string.Format("select top {0} * from [CareerOpportunity] "
+ " join SystemPara para1 on para1.ID = JobFunction"
+ " join SystemPara para2 on para2.ID = Division"
+ " where status = '{1}' order by para2.[Description], para1.[Description]",
total,
GlobalSetting.ArticleStatus.Published);
}
else
{
sql = string.Format("select * from [CareerOpportunity] "
+ " join SystemPara para1 on para1.ID = JobFunction"
+ " join SystemPara para2 on para2.ID = Division"
+ " where status = '{0}' order by para2.[Description], para1.[Description]",
GlobalSetting.ArticleStatus.Published);
}
System.Data.DataTable dt = dbAccess.select(sql);
System.Data.DataTable dt2;
foreach (System.Data.DataRow row in dt.Rows)
{
careerOpportunityInfo = new CareerOpportunityInfo();
careerOpportunityInfo.CareerLevel = row["CareerLevel"].ToString();
careerOpportunityInfo.CreateBy = Convert.ToInt32(row["CreateBy"]);
careerOpportunityInfo.CreateDate = Convert.ToDateTime(row["CreateDate"]);
careerOpportunityInfo.Division = Convert.ToInt32(row["Division"]);
careerOpportunityInfo.Details = row["Details"].ToString();
careerOpportunityInfo.Email = row["Email"].ToString();
careerOpportunityInfo.EmploymentType = Convert.ToInt32(row["EmploymentType"]);
careerOpportunityInfo.Experience = Convert.ToSingle(row["Experience"]);
careerOpportunityInfo.ID = Convert.ToInt32(row["ID"]);
careerOpportunityInfo.JobFunction = Convert.ToInt32(row["JobFunction"]);
careerOpportunityInfo.Location = row["Location"].ToString();
careerOpportunityInfo.Qualification = Convert.ToInt32(row["Qualification"]);
//careerOpportunityInfo.Salary = Convert.ToInt32(row["Salary"]);
careerOpportunityInfo.Status = row["Status"].ToString();
//new icon
sql = string.Format("select ExpiryDate from [NewIconControl] where ParentID = {0} and Category = '{1}' ",
careerOpportunityInfo.ID, GlobalSetting.ArticleCategory.Career);
dt2 = dbAccess.select(sql);
if (dt2.Rows.Count == 1)
{
careerOpportunityInfo.NewIconInfo = new NewIconInfo();
careerOpportunityInfo.NewIconInfo.ExpiryDate = Convert.ToDateTime(dt2.Rows[0]["ExpiryDate"]);
}
list.Add(careerOpportunityInfo);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbAccess.close();
}
return(list);
}
public void save(CareerOpportunityInfo careeroppty)
{
string sql = " INSERT INTO [CareerOpportunity] "
+ " ([Type] ,[SerialNo] ,[JobFunction] ,[Experience] ,[CareerLevel] ,[Qualification] ,[Division],[Department],[Location] , "
+ " [EmploymentType] ,[Email] ,[Details], [Disclaimer] ,[Status] ,[CreateDate] ,[CreateBy]) "
+ " VALUES "
+ " (@Type ,@SerialNo, @JobFunction ,@Experience ,@CareerLevel ,@Qualification ,@Division ,@Department ,@Location , "
+ " @EmploymentType ,@Email ,@Details, @Disclaimer ,@Status ,getDate() ,@CreateBy);select SCOPE_IDENTITY(); ";
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("@Type", careeroppty.Type);
dict.Add("@SerialNo", careeroppty.SerialNo);
dict.Add("@JobFunction", careeroppty.JobFunction);
dict.Add("@Experience", careeroppty.Experience);
dict.Add("@CareerLevel", careeroppty.CareerLevel);
dict.Add("@Qualification", careeroppty.Qualification);
//dict.Add("@Salary", careeroppty.Salary);
dict.Add("@Division", careeroppty.Division);
dict.Add("@Department", careeroppty.Department);
dict.Add("@Location", careeroppty.Location);
dict.Add("@EmploymentType", careeroppty.EmploymentType);
dict.Add("@Email", careeroppty.Email);
dict.Add("@Details", careeroppty.Details);
dict.Add("@Disclaimer", careeroppty.Disclaimer);
dict.Add("@Status", careeroppty.Status);
dict.Add("@CreateBy", careeroppty.CreateBy);
this.dbAccess.open();
try
{
this.dbAccess.BeginTransaction();
System.Data.DataTable dt = this.dbAccess.select(sql, dict);
string lastID = dt.Rows[0][0].ToString();
#region new icon
//insert the information of "New" icon
string sql_icon = "INSERT INTO [NewIconControl] "
+ "([Category], [ParentID], [ExpiryDate]) VALUES "
+ "(@Category, @ParentID, @ExpiryDate)";
if (careeroppty.NewIconInfo != null)
{
dict = new Dictionary <string, object>();
dict.Add("@Category", careeroppty.NewIconInfo.Category);
dict.Add("@ParentID", lastID);
dict.Add("@ExpiryDate", careeroppty.NewIconInfo.ExpiryDate);
this.dbAccess.update(sql_icon, dict);
}
#endregion
this.dbAccess.Commit();
}
catch (Exception ex)
{
this.dbAccess.rollback();
throw ex;
}
finally
{
this.dbAccess.close();
}
}
