protected void btnUpdate_Click(object sender, EventArgs e)
{
HR_EmployerType hR_EmployerType = new HR_EmployerType();
hR_EmployerType.EmployerType = int.Parse(Request.QueryString["ID"].ToString());
hR_EmployerType.EmployerTypeName = txtEmployerTypeName.Text;
string userID = Profile.card_id;
hR_EmployerType.AddedBy = userID;
hR_EmployerType.AddedDate = DateTime.Now;
hR_EmployerType.UpdatedBy = userID;
hR_EmployerType.UpdateDate = DateTime.Now;
bool resutl = HR_EmployerTypeManager.UpdateHR_EmployerType(hR_EmployerType);
Response.Redirect("AdminDisplayHR_EmployerType.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
HR_EmployerType hR_EmployerType = new HR_EmployerType();
// hR_EmployerType.EmployerType= int.Parse(txtEmployerType.Text);
hR_EmployerType.EmployerTypeName = txtEmployerTypeName.Text;
string userID = Profile.card_id;
hR_EmployerType.AddedBy = userID;
hR_EmployerType.AddedDate = DateTime.Now;
hR_EmployerType.UpdatedBy = userID;
hR_EmployerType.UpdateDate = DateTime.Now;
int resutl = HR_EmployerTypeManager.InsertHR_EmployerType(hR_EmployerType);
Response.Redirect("AdminDisplayHR_EmployerType.aspx");
}
public HR_EmployerType GetHR_EmployerTypeFromReader(IDataReader reader)
{
try
{
HR_EmployerType hR_EmployerType = new HR_EmployerType
(
DataAccessObject.IsNULL<int>(reader["EmployerType"]),
DataAccessObject.IsNULL<string>(reader["EmployerTypeName"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"])
);
return hR_EmployerType;
}
catch(Exception ex)
{
return null;
}
}
public bool UpdateHR_EmployerType(HR_EmployerType hR_EmployerType)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_EmployerType", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EmployerType", SqlDbType.Int).Value = hR_EmployerType.EmployerType;
cmd.Parameters.Add("@EmployerTypeName", SqlDbType.NVarChar).Value = hR_EmployerType.EmployerTypeName;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = hR_EmployerType.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = hR_EmployerType.UpdateDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertHR_EmployerType(HR_EmployerType hR_EmployerType)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("InsertHR_EmployerType", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EmployerType", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@EmployerTypeName", SqlDbType.NVarChar).Value = hR_EmployerType.EmployerTypeName;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = hR_EmployerType.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = hR_EmployerType.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = hR_EmployerType.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = hR_EmployerType.UpdateDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@EmployerType"].Value;
}
}
private void showHR_EmployerTypeData()
{
HR_EmployerType hR_EmployerType = new HR_EmployerType();
hR_EmployerType = HR_EmployerTypeManager.GetHR_EmployerTypeByEmployerType(Int32.Parse(Request.QueryString["ID"]));
txtEmployerTypeName.Text = hR_EmployerType.EmployerTypeName.ToString();
}
