private OfficialEmployeeReward ConvertRowToOfficialEmployeeReward(DataRow row)
{
OfficialEmployeeReward officialEmployeeReward = new OfficialEmployeeReward();
officialEmployeeReward.NationalCode = (row["NationalCode"] != DBNull.Value) ? Convert.ToInt64(row["NationalCode"]) : 0;
officialEmployeeReward.YearTypeID = (row["YearTypeID"] != DBNull.Value) ? Convert.ToInt32(row["YearTypeID"]) : 0;
officialEmployeeReward.MonthTypeID = (row["MonthTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MonthTypeID"]) : 0;
officialEmployeeReward.EmployeeFullName = row["EmployeeFullName"].ToString();
officialEmployeeReward.DepartmentIDTitle = row["DepartmentIDTitle"].ToString();
officialEmployeeReward.YearTypeIDTitle = row["YearTypeIDTitle"].ToString();
officialEmployeeReward.MonthTypeIDTitle = row["MonthTypeIDTitle"].ToString();
officialEmployeeReward.RoleTypeIDTitle = row["RoleTypeIDTitle"].ToString();
officialEmployeeReward.TotalReward = (row["TotalReward"] != DBNull.Value) ? Convert.ToInt64(row["TotalReward"]) : 0;
officialEmployeeReward.Reward_ = (row["Reward_"] != DBNull.Value) ? Convert.ToInt64(row["Reward_"]) : 0;
officialEmployeeReward.RoleTypeIDFactor = (row["RoleTypeIDFactor"] != DBNull.Value) ? Convert.ToDecimal(row["RoleTypeIDFactor"]) : 0;
officialEmployeeReward.BossFactor = (row["BossFactor"] != DBNull.Value) ? Convert.ToDecimal(row["BossFactor"]) : 0;
officialEmployeeReward.Reward = (row["Reward"] != DBNull.Value) ? Convert.ToInt64(row["Reward"]) : 0;
officialEmployeeReward.BossFinalValue = (row["BossFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["BossFinalValue"]) : 0;
officialEmployeeReward.AssistantFinalValue = (row["AssistantFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["AssistantFinalValue"]) : 0;
officialEmployeeReward.ManagerFinalValue = (row["ManagerFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["ManagerFinalValue"]) : 0;
officialEmployeeReward.ExtraReward1 = (row["ExtraReward1"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward1"]) : 0;
officialEmployeeReward.ExtraReward2 = (row["ExtraReward2"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward2"]) : 0;
officialEmployeeReward.ExtraReward3 = (row["ExtraReward3"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward3"]) : 0;
officialEmployeeReward.RoleTypeID = (row["RoleTypeID"] != DBNull.Value) ? Convert.ToInt32(row["RoleTypeID"]) : 0;
officialEmployeeReward.Parameter1 = (row["Parameter1"] != DBNull.Value) ? Convert.ToInt32(row["Parameter1"]) : 0;
officialEmployeeReward.Parameter2 = (row["Parameter2"] != DBNull.Value) ? Convert.ToInt32(row["Parameter2"]) : 0;
officialEmployeeReward.Parameter3 = (row["Parameter3"] != DBNull.Value) ? Convert.ToInt32(row["Parameter3"]) : 0;
return(officialEmployeeReward);
}
public List <OfficialEmployeeReward> GetListOfficialEmployeeReward(int mainOfficeTypeID)
{
List <OfficialEmployeeReward> listOfficialEmployeeReward = new List <OfficialEmployeeReward>()
{
};
SqlParameter[] parametersMainOfficeType = new SqlParameter[]
{
new SqlParameter("@MainOfficeTypeID", mainOfficeTypeID)
};
//Lets get the list of OfficialEmployeeReward records from database
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("MainOfficeType_GetList_OfficialEmployeeReward", CommandType.StoredProcedure, parametersMainOfficeType))
{
//check if any record exists or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of OfficialEmployeeReward
listOfficialEmployeeReward = new List <OfficialEmployeeReward>();
//Now lets populate the OfficialEmployeeReward details into the list of OfficialEmployeeRewards
foreach (DataRow row in table.Rows)
{
OfficialEmployeeReward officialEmployeeReward = officialEmployeeRewardDBAccess.GetDetails(Convert.ToInt64(row["NationalCode"]), Convert.ToInt32(row["YearTypeID"]), Convert.ToInt32(row["MonthTypeID"]));
listOfficialEmployeeReward.Add(officialEmployeeReward);
}
}
}
return(listOfficialEmployeeReward);
}
public List <OfficialEmployeeReward> GetListOfficialEmployeeReward(int yearTypeID)
{
List <OfficialEmployeeReward> listOfficialEmployeeReward = new List <OfficialEmployeeReward>()
{
};
SqlParameter[] parametersYearType = new SqlParameter[]
{
new SqlParameter("@YearTypeID", yearTypeID)
};
//Lets get the list of OfficialEmployeeReward records from database
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("OfficialEmployeeReward_GetList_UseInYearType", CommandType.StoredProcedure, parametersYearType))
{
//check if any record exists or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of officialEmployeeReward
listOfficialEmployeeReward = new List <OfficialEmployeeReward>();
//Now lets populate the OfficialEmployeeReward details into the list of officialEmployeeRewards
foreach (DataRow row in table.Rows)
{
OfficialEmployeeReward officialEmployeeReward = ConvertRowToOfficialEmployeeReward(row);
listOfficialEmployeeReward.Add(officialEmployeeReward);
}
}
}
return(listOfficialEmployeeReward);
}
protected void btnYES_Click(object sender, EventArgs e)
{
OfficialEmployeeReward officialEmployeeReward = new OfficialEmployeeReward();
officialEmployeeReward.NationalCode = Convert.ToInt64(ddlNationalCode.SelectedValue);
officialEmployeeReward.YearTypeID = Convert.ToInt32(ddlYearTypeID.SelectedValue);
officialEmployeeReward.MonthTypeID = Convert.ToInt32(ddlMonthTypeID.SelectedValue);
officialEmployeeReward.Reward = Convert.ToInt64(txtReward.Text);
officialEmployeeReward.BossFinalValue = Convert.ToInt64(txtBossFinalValue.Text);
officialEmployeeReward.AssistantFinalValue = Convert.ToInt64(txtAssistantFinalValue.Text);
officialEmployeeReward.ManagerFinalValue = Convert.ToInt64(txtManagerFinalValue.Text);
officialEmployeeReward.ExtraReward1 = Convert.ToInt64(txtExtraReward1.Text);
officialEmployeeReward.ExtraReward2 = Convert.ToInt64(txtExtraReward2.Text);
officialEmployeeReward.ExtraReward3 = Convert.ToInt64(txtExtraReward3.Text);
officialEmployeeReward.RoleTypeID = Convert.ToInt32(txtRoleTypeID.Text);
officialEmployeeReward.Parameter1 = Convert.ToInt32(txtParameter1.Text);
officialEmployeeReward.Parameter2 = Convert.ToInt32(txtParameter2.Text);
officialEmployeeReward.Parameter3 = Convert.ToInt32(txtParameter3.Text);
OfficialEmployeeRewardHandler officialEmployeeRewardHandler = new OfficialEmployeeRewardHandler();
if (officialEmployeeRewardHandler.Insert(officialEmployeeReward) > 0)
{
Response.Redirect("Z_OfficialEmployeeRewardDefault.aspx");
}
}
public bool Exists(OfficialEmployeeReward officialEmployeeReward)
{
SqlParameter[] parametersOfficialEmployeeReward = new SqlParameter[]
{
new SqlParameter("@NationalCode", officialEmployeeReward.NationalCode),
new SqlParameter("@YearTypeID", officialEmployeeReward.YearTypeID),
new SqlParameter("@MonthTypeID", officialEmployeeReward.MonthTypeID)
};
return(SqlDBHelper.ExecuteScalar("OfficialEmployeeReward_Exists", CommandType.StoredProcedure, parametersOfficialEmployeeReward) > 0);
}
protected void Page_Load(object sender, EventArgs e)
{
string nationalCode = Request.QueryString["nationalCode"] as string;
string yearTypeID = Request.QueryString["yearTypeID"] as string;
string monthTypeID = Request.QueryString["monthTypeID"] as string;
if (nationalCode == null || yearTypeID == null || monthTypeID == null)
{
Response.Redirect("Z_OfficialEmployeeRewardDefault.aspx");
}
try
{
officialEmployeeRewardNationalCode = Convert.ToInt64(nationalCode.Trim());
officialEmployeeRewardYearTypeID = Convert.ToInt32(yearTypeID.Trim());
officialEmployeeRewardMonthTypeID = Convert.ToInt32(monthTypeID.Trim());
officialEmployeeRewardHandler = new OfficialEmployeeRewardHandler();
OfficialEmployeeReward officialEmployeeReward = officialEmployeeRewardHandler.GetDetails(officialEmployeeRewardNationalCode, officialEmployeeRewardYearTypeID, officialEmployeeRewardMonthTypeID);
lblNationalCode.Text = officialEmployeeReward.NationalCode.ToString();
lblYearTypeID.Text = officialEmployeeReward.YearTypeID.ToString();
lblMonthTypeID.Text = officialEmployeeReward.MonthTypeID.ToString();
lblEmployeeFullName.Text = officialEmployeeReward.EmployeeFullName.ToString();
lblDepartmentIDTitle.Text = officialEmployeeReward.DepartmentIDTitle.ToString();
lblYearTypeIDTitle.Text = officialEmployeeReward.YearTypeIDTitle.ToString();
lblMonthTypeIDTitle.Text = officialEmployeeReward.MonthTypeIDTitle.ToString();
lblRoleTypeIDTitle.Text = officialEmployeeReward.RoleTypeIDTitle.ToString();
lblTotalReward.Text = officialEmployeeReward.TotalReward.ToString();
lblReward_.Text = officialEmployeeReward.Reward_.ToString();
lblRoleTypeIDFactor.Text = officialEmployeeReward.RoleTypeIDFactor.ToString();
lblBossFactor.Text = officialEmployeeReward.BossFactor.ToString();
lblReward.Text = officialEmployeeReward.Reward.ToString();
lblBossFinalValue.Text = officialEmployeeReward.BossFinalValue.ToString();
lblAssistantFinalValue.Text = officialEmployeeReward.AssistantFinalValue.ToString();
lblManagerFinalValue.Text = officialEmployeeReward.ManagerFinalValue.ToString();
lblExtraReward1.Text = officialEmployeeReward.ExtraReward1.ToString();
lblExtraReward2.Text = officialEmployeeReward.ExtraReward2.ToString();
lblExtraReward3.Text = officialEmployeeReward.ExtraReward3.ToString();
lblRoleTypeID.Text = officialEmployeeReward.RoleTypeID.ToString();
lblParameter1.Text = officialEmployeeReward.Parameter1.ToString();
lblParameter2.Text = officialEmployeeReward.Parameter2.ToString();
lblParameter3.Text = officialEmployeeReward.Parameter3.ToString();
}
catch (Exception)
{
Response.Redirect("Z_OfficialEmployeeRewardDefault.aspx");
}
}
public OfficialEmployeeReward GetDetails(Int64 nationalCode, int yearTypeID, int monthTypeID)
{
OfficialEmployeeReward officialEmployeeReward = new OfficialEmployeeReward();
SqlParameter[] parametersOfficialEmployeeReward = new SqlParameter[]
{
new SqlParameter("@NationalCode", nationalCode),
new SqlParameter("@YearTypeID", yearTypeID),
new SqlParameter("@MonthTypeID", monthTypeID)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("OfficialEmployeeReward_GetDetails", CommandType.StoredProcedure, parametersOfficialEmployeeReward))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
officialEmployeeReward.NationalCode = (row["NationalCode"] != DBNull.Value) ? Convert.ToInt64(row["NationalCode"]) : 0;
officialEmployeeReward.YearTypeID = (row["YearTypeID"] != DBNull.Value) ? Convert.ToInt32(row["YearTypeID"]) : 0;
officialEmployeeReward.MonthTypeID = (row["MonthTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MonthTypeID"]) : 0;
officialEmployeeReward.EmployeeFullName = row["EmployeeFullName"].ToString();
officialEmployeeReward.DepartmentIDTitle = row["DepartmentIDTitle"].ToString();
officialEmployeeReward.YearTypeIDTitle = row["YearTypeIDTitle"].ToString();
officialEmployeeReward.MonthTypeIDTitle = row["MonthTypeIDTitle"].ToString();
officialEmployeeReward.RoleTypeIDTitle = row["RoleTypeIDTitle"].ToString();
officialEmployeeReward.TotalReward = (row["TotalReward"] != DBNull.Value) ? Convert.ToInt64(row["TotalReward"]) : 0;
officialEmployeeReward.Reward_ = (row["Reward_"] != DBNull.Value) ? Convert.ToInt64(row["Reward_"]) : 0;
officialEmployeeReward.RoleTypeIDFactor = (row["RoleTypeIDFactor"] != DBNull.Value) ? Convert.ToDecimal(row["RoleTypeIDFactor"]) : 0;
officialEmployeeReward.BossFactor = (row["BossFactor"] != DBNull.Value) ? Convert.ToDecimal(row["BossFactor"]) : 0;
officialEmployeeReward.Reward = (row["Reward"] != DBNull.Value) ? Convert.ToInt64(row["Reward"]) : 0;
officialEmployeeReward.BossFinalValue = (row["BossFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["BossFinalValue"]) : 0;
officialEmployeeReward.AssistantFinalValue = (row["AssistantFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["AssistantFinalValue"]) : 0;
officialEmployeeReward.ManagerFinalValue = (row["ManagerFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["ManagerFinalValue"]) : 0;
officialEmployeeReward.ExtraReward1 = (row["ExtraReward1"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward1"]) : 0;
officialEmployeeReward.ExtraReward2 = (row["ExtraReward2"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward2"]) : 0;
officialEmployeeReward.ExtraReward3 = (row["ExtraReward3"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward3"]) : 0;
officialEmployeeReward.RoleTypeID = (row["RoleTypeID"] != DBNull.Value) ? Convert.ToInt32(row["RoleTypeID"]) : 0;
officialEmployeeReward.Parameter1 = (row["Parameter1"] != DBNull.Value) ? Convert.ToInt32(row["Parameter1"]) : 0;
officialEmployeeReward.Parameter2 = (row["Parameter2"] != DBNull.Value) ? Convert.ToInt32(row["Parameter2"]) : 0;
officialEmployeeReward.Parameter3 = (row["Parameter3"] != DBNull.Value) ? Convert.ToInt32(row["Parameter3"]) : 0;
}
}
return(officialEmployeeReward);
}
public List <OfficialEmployeeReward> GetListAll()
{
List <OfficialEmployeeReward> listOfficialEmployeeReward = null;
using (DataTable table = SqlDBHelper.ExecuteSelectCommand("OfficialEmployeeReward_GetListAll", CommandType.StoredProcedure))
{
if (table.Rows.Count > 0)
{
listOfficialEmployeeReward = new List <OfficialEmployeeReward>();
foreach (DataRow row in table.Rows)
{
OfficialEmployeeReward officialEmployeeReward = new OfficialEmployeeReward();
officialEmployeeReward.NationalCode = (row["NationalCode"] != DBNull.Value) ? Convert.ToInt64(row["NationalCode"]) : 0;
officialEmployeeReward.YearTypeID = (row["YearTypeID"] != DBNull.Value) ? Convert.ToInt32(row["YearTypeID"]) : 0;
officialEmployeeReward.MonthTypeID = (row["MonthTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MonthTypeID"]) : 0;
officialEmployeeReward.EmployeeFullName = row["EmployeeFullName"].ToString();
officialEmployeeReward.DepartmentIDTitle = row["DepartmentIDTitle"].ToString();
officialEmployeeReward.YearTypeIDTitle = row["YearTypeIDTitle"].ToString();
officialEmployeeReward.MonthTypeIDTitle = row["MonthTypeIDTitle"].ToString();
officialEmployeeReward.RoleTypeIDTitle = row["RoleTypeIDTitle"].ToString();
officialEmployeeReward.TotalReward = (row["TotalReward"] != DBNull.Value) ? Convert.ToInt64(row["TotalReward"]) : 0;
officialEmployeeReward.Reward_ = (row["Reward_"] != DBNull.Value) ? Convert.ToInt64(row["Reward_"]) : 0;
officialEmployeeReward.RoleTypeIDFactor = (row["RoleTypeIDFactor"] != DBNull.Value) ? Convert.ToDecimal(row["RoleTypeIDFactor"]) : 0;
officialEmployeeReward.BossFactor = (row["BossFactor"] != DBNull.Value) ? Convert.ToDecimal(row["BossFactor"]) : 0;
officialEmployeeReward.Reward = (row["Reward"] != DBNull.Value) ? Convert.ToInt64(row["Reward"]) : 0;
officialEmployeeReward.BossFinalValue = (row["BossFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["BossFinalValue"]) : 0;
officialEmployeeReward.AssistantFinalValue = (row["AssistantFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["AssistantFinalValue"]) : 0;
officialEmployeeReward.ManagerFinalValue = (row["ManagerFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["ManagerFinalValue"]) : 0;
officialEmployeeReward.ExtraReward1 = (row["ExtraReward1"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward1"]) : 0;
officialEmployeeReward.ExtraReward2 = (row["ExtraReward2"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward2"]) : 0;
officialEmployeeReward.ExtraReward3 = (row["ExtraReward3"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward3"]) : 0;
officialEmployeeReward.RoleTypeID = (row["RoleTypeID"] != DBNull.Value) ? Convert.ToInt32(row["RoleTypeID"]) : 0;
officialEmployeeReward.Parameter1 = (row["Parameter1"] != DBNull.Value) ? Convert.ToInt32(row["Parameter1"]) : 0;
officialEmployeeReward.Parameter2 = (row["Parameter2"] != DBNull.Value) ? Convert.ToInt32(row["Parameter2"]) : 0;
officialEmployeeReward.Parameter3 = (row["Parameter3"] != DBNull.Value) ? Convert.ToInt32(row["Parameter3"]) : 0;
listOfficialEmployeeReward.Add(officialEmployeeReward);
}
}
}
return(listOfficialEmployeeReward);
}
public bool Update(OfficialEmployeeReward officialEmployeeReward)
{
SqlParameter[] parametersOfficialEmployeeReward = new SqlParameter[]
{
new SqlParameter("@NationalCode", officialEmployeeReward.NationalCode),
new SqlParameter("@YearTypeID", officialEmployeeReward.YearTypeID),
new SqlParameter("@MonthTypeID", officialEmployeeReward.MonthTypeID),
new SqlParameter("@BossFactor", officialEmployeeReward.BossFactor),
new SqlParameter("@Reward", officialEmployeeReward.Reward),
new SqlParameter("@BossFinalValue", officialEmployeeReward.BossFinalValue),
new SqlParameter("@AssistantFinalValue", officialEmployeeReward.AssistantFinalValue),
new SqlParameter("@ManagerFinalValue", officialEmployeeReward.ManagerFinalValue),
new SqlParameter("@ExtraReward1", officialEmployeeReward.ExtraReward1),
new SqlParameter("@ExtraReward2", officialEmployeeReward.ExtraReward2),
new SqlParameter("@ExtraReward3", officialEmployeeReward.ExtraReward3),
new SqlParameter("@RoleTypeID", (officialEmployeeReward.RoleTypeID != null) ? officialEmployeeReward.RoleTypeID : (object)DBNull.Value),
new SqlParameter("@Parameter1", officialEmployeeReward.Parameter1),
new SqlParameter("@Parameter2", officialEmployeeReward.Parameter2),
new SqlParameter("@Parameter3", officialEmployeeReward.Parameter3)
};
return(SqlDBHelper.ExecuteNonQuery("OfficialEmployeeReward_Update", CommandType.StoredProcedure, parametersOfficialEmployeeReward));
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lblNationalCode = GridView1.Rows[e.RowIndex].FindControl("lblNationalCode") as Label;
Label lblYearTypeID = GridView1.Rows[e.RowIndex].FindControl("lblYearTypeID") as Label;
Label lblMonthTypeID = GridView1.Rows[e.RowIndex].FindControl("lblMonthTypeID") as Label;
Label lblEmployeeFullName = GridView1.Rows[e.RowIndex].FindControl("lblEmployeeFullName") as Label;
Label lblDepartmentIDTitle = GridView1.Rows[e.RowIndex].FindControl("lblDepartmentIDTitle") as Label;
Label lblYearTypeIDTitle = GridView1.Rows[e.RowIndex].FindControl("lblYearTypeIDTitle") as Label;
Label lblMonthTypeIDTitle = GridView1.Rows[e.RowIndex].FindControl("lblMonthTypeIDTitle") as Label;
Label lblRoleTypeIDTitle = GridView1.Rows[e.RowIndex].FindControl("lblRoleTypeIDTitle") as Label;
Label lblTotalReward = GridView1.Rows[e.RowIndex].FindControl("lblTotalReward") as Label;
Label lblReward_ = GridView1.Rows[e.RowIndex].FindControl("lblReward_") as Label;
Label lblRoleTypeIDFactor = GridView1.Rows[e.RowIndex].FindControl("lblRoleTypeIDFactor") as Label;
TextBox txtBossFactor = GridView1.Rows[e.RowIndex].FindControl("txtBossFactor") as TextBox;
TextBox txtReward = GridView1.Rows[e.RowIndex].FindControl("txtReward") as TextBox;
TextBox txtBossFinalValue = GridView1.Rows[e.RowIndex].FindControl("txtBossFinalValue") as TextBox;
TextBox txtAssistantFinalValue = GridView1.Rows[e.RowIndex].FindControl("txtAssistantFinalValue") as TextBox;
TextBox txtManagerFinalValue = GridView1.Rows[e.RowIndex].FindControl("txtManagerFinalValue") as TextBox;
TextBox txtExtraReward1 = GridView1.Rows[e.RowIndex].FindControl("txtExtraReward1") as TextBox;
TextBox txtExtraReward2 = GridView1.Rows[e.RowIndex].FindControl("txtExtraReward2") as TextBox;
TextBox txtExtraReward3 = GridView1.Rows[e.RowIndex].FindControl("txtExtraReward3") as TextBox;
TextBox txtRoleTypeID = GridView1.Rows[e.RowIndex].FindControl("txtRoleTypeID") as TextBox;
TextBox txtParameter1 = GridView1.Rows[e.RowIndex].FindControl("txtParameter1") as TextBox;
TextBox txtParameter2 = GridView1.Rows[e.RowIndex].FindControl("txtParameter2") as TextBox;
TextBox txtParameter3 = GridView1.Rows[e.RowIndex].FindControl("txtParameter3") as TextBox;
if (lblNationalCode != null && lblYearTypeID != null && lblMonthTypeID != null && lblEmployeeFullName != null && lblDepartmentIDTitle != null && lblYearTypeIDTitle != null && lblMonthTypeIDTitle != null && lblRoleTypeIDTitle != null && lblTotalReward != null && lblReward_ != null && lblRoleTypeIDFactor != null && txtBossFactor != null && txtReward != null && txtBossFinalValue != null && txtAssistantFinalValue != null && txtManagerFinalValue != null && txtExtraReward1 != null && txtExtraReward2 != null && txtExtraReward3 != null && txtRoleTypeID != null && txtParameter1 != null && txtParameter2 != null && txtParameter3 != null)
{
OfficialEmployeeReward officialEmployeeReward = new OfficialEmployeeReward();
officialEmployeeReward.NationalCode = Convert.ToInt64(lblNationalCode.Text.Trim());
officialEmployeeReward.YearTypeID = Convert.ToInt32(lblYearTypeID.Text.Trim());
officialEmployeeReward.MonthTypeID = Convert.ToInt32(lblMonthTypeID.Text.Trim());
officialEmployeeReward.EmployeeFullName = lblEmployeeFullName.Text;
officialEmployeeReward.DepartmentIDTitle = lblDepartmentIDTitle.Text;
officialEmployeeReward.YearTypeIDTitle = lblYearTypeIDTitle.Text;
officialEmployeeReward.MonthTypeIDTitle = lblMonthTypeIDTitle.Text;
officialEmployeeReward.RoleTypeIDTitle = lblRoleTypeIDTitle.Text;
officialEmployeeReward.TotalReward = Convert.ToInt64(lblTotalReward.Text.Trim());
officialEmployeeReward.Reward_ = Convert.ToInt64(lblReward_.Text.Trim());
officialEmployeeReward.Reward = Convert.ToInt64(txtReward.Text.Trim());
officialEmployeeReward.BossFinalValue = Convert.ToInt64(txtBossFinalValue.Text.Trim());
officialEmployeeReward.AssistantFinalValue = Convert.ToInt64(txtAssistantFinalValue.Text.Trim());
officialEmployeeReward.ManagerFinalValue = Convert.ToInt64(txtManagerFinalValue.Text.Trim());
officialEmployeeReward.ExtraReward1 = Convert.ToInt64(txtExtraReward1.Text.Trim());
officialEmployeeReward.ExtraReward2 = Convert.ToInt64(txtExtraReward2.Text.Trim());
officialEmployeeReward.ExtraReward3 = Convert.ToInt64(txtExtraReward3.Text.Trim());
officialEmployeeReward.RoleTypeID = Convert.ToInt32(txtRoleTypeID.Text.Trim());
officialEmployeeReward.Parameter1 = Convert.ToInt32(txtParameter1.Text.Trim());
officialEmployeeReward.Parameter2 = Convert.ToInt32(txtParameter2.Text.Trim());
officialEmployeeReward.Parameter3 = Convert.ToInt32(txtParameter3.Text.Trim());
//Let us now update the database
if (officialEmployeeRewardHandler.Update(officialEmployeeReward) == true)
{
lblResult.Text = "Record Updated Successfully";
}
else
{
lblResult.Text = "Failed to Update record";
}
//end the editing and bind with updated records.
GridView1.EditIndex = -1;
BindData();
}
}
public List <OfficialEmployeeReward> SearchLike(OfficialEmployeeReward officialEmployeeReward)
{
List <OfficialEmployeeReward> listOfficialEmployeeReward = new List <OfficialEmployeeReward>();
SqlParameter[] parametersOfficialEmployeeReward = new SqlParameter[]
{
new SqlParameter("@NationalCode", officialEmployeeReward.NationalCode),
new SqlParameter("@YearTypeID", officialEmployeeReward.YearTypeID),
new SqlParameter("@MonthTypeID", officialEmployeeReward.MonthTypeID),
new SqlParameter("@EmployeeFullName", officialEmployeeReward.EmployeeFullName),
new SqlParameter("@DepartmentIDTitle", officialEmployeeReward.DepartmentIDTitle),
new SqlParameter("@YearTypeIDTitle", officialEmployeeReward.YearTypeIDTitle),
new SqlParameter("@MonthTypeIDTitle", officialEmployeeReward.MonthTypeIDTitle),
new SqlParameter("@RoleTypeIDTitle", officialEmployeeReward.RoleTypeIDTitle),
new SqlParameter("@TotalReward", officialEmployeeReward.TotalReward),
new SqlParameter("@Reward_", officialEmployeeReward.Reward_),
new SqlParameter("@RoleTypeIDFactor", officialEmployeeReward.RoleTypeIDFactor),
new SqlParameter("@BossFactor", officialEmployeeReward.BossFactor),
new SqlParameter("@Reward", officialEmployeeReward.Reward),
new SqlParameter("@BossFinalValue", officialEmployeeReward.BossFinalValue),
new SqlParameter("@AssistantFinalValue", officialEmployeeReward.AssistantFinalValue),
new SqlParameter("@ManagerFinalValue", officialEmployeeReward.ManagerFinalValue),
new SqlParameter("@ExtraReward1", officialEmployeeReward.ExtraReward1),
new SqlParameter("@ExtraReward2", officialEmployeeReward.ExtraReward2),
new SqlParameter("@ExtraReward3", officialEmployeeReward.ExtraReward3),
new SqlParameter("@RoleTypeID", officialEmployeeReward.RoleTypeID),
new SqlParameter("@Parameter1", officialEmployeeReward.Parameter1),
new SqlParameter("@Parameter2", officialEmployeeReward.Parameter2),
new SqlParameter("@Parameter3", officialEmployeeReward.Parameter3),
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("OfficialEmployeeReward_SearchLike", CommandType.StoredProcedure, parametersOfficialEmployeeReward))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
OfficialEmployeeReward tmpOfficialEmployeeReward = new OfficialEmployeeReward();
tmpOfficialEmployeeReward.NationalCode = (row["NationalCode"] != DBNull.Value) ? Convert.ToInt64(row["NationalCode"]) : 0;
tmpOfficialEmployeeReward.YearTypeID = (row["YearTypeID"] != DBNull.Value) ? Convert.ToInt32(row["YearTypeID"]) : 0;
tmpOfficialEmployeeReward.MonthTypeID = (row["MonthTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MonthTypeID"]) : 0;
tmpOfficialEmployeeReward.EmployeeFullName = row["EmployeeFullName"].ToString();
tmpOfficialEmployeeReward.DepartmentIDTitle = row["DepartmentIDTitle"].ToString();
tmpOfficialEmployeeReward.YearTypeIDTitle = row["YearTypeIDTitle"].ToString();
tmpOfficialEmployeeReward.MonthTypeIDTitle = row["MonthTypeIDTitle"].ToString();
tmpOfficialEmployeeReward.RoleTypeIDTitle = row["RoleTypeIDTitle"].ToString();
tmpOfficialEmployeeReward.TotalReward = (row["TotalReward"] != DBNull.Value) ? Convert.ToInt64(row["TotalReward"]) : 0;
tmpOfficialEmployeeReward.Reward_ = (row["Reward_"] != DBNull.Value) ? Convert.ToInt64(row["Reward_"]) : 0;
tmpOfficialEmployeeReward.RoleTypeIDFactor = (row["RoleTypeIDFactor"] != DBNull.Value) ? Convert.ToDecimal(row["RoleTypeIDFactor"]) : 0;
tmpOfficialEmployeeReward.BossFactor = (row["BossFactor"] != DBNull.Value) ? Convert.ToDecimal(row["BossFactor"]) : 0;
tmpOfficialEmployeeReward.Reward = (row["Reward"] != DBNull.Value) ? Convert.ToInt64(row["Reward"]) : 0;
tmpOfficialEmployeeReward.BossFinalValue = (row["BossFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["BossFinalValue"]) : 0;
tmpOfficialEmployeeReward.AssistantFinalValue = (row["AssistantFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["AssistantFinalValue"]) : 0;
tmpOfficialEmployeeReward.ManagerFinalValue = (row["ManagerFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["ManagerFinalValue"]) : 0;
tmpOfficialEmployeeReward.ExtraReward1 = (row["ExtraReward1"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward1"]) : 0;
tmpOfficialEmployeeReward.ExtraReward2 = (row["ExtraReward2"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward2"]) : 0;
tmpOfficialEmployeeReward.ExtraReward3 = (row["ExtraReward3"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward3"]) : 0;
tmpOfficialEmployeeReward.RoleTypeID = (row["RoleTypeID"] != DBNull.Value) ? Convert.ToInt32(row["RoleTypeID"]) : 0;
tmpOfficialEmployeeReward.Parameter1 = (row["Parameter1"] != DBNull.Value) ? Convert.ToInt32(row["Parameter1"]) : 0;
tmpOfficialEmployeeReward.Parameter2 = (row["Parameter2"] != DBNull.Value) ? Convert.ToInt32(row["Parameter2"]) : 0;
tmpOfficialEmployeeReward.Parameter3 = (row["Parameter3"] != DBNull.Value) ? Convert.ToInt32(row["Parameter3"]) : 0;
listOfficialEmployeeReward.Add(tmpOfficialEmployeeReward);
}
}
}
return(listOfficialEmployeeReward);
}
