public static HR_OverTimePackage GetHR_OverTimePackageByOverTimePackageID(int OverTimePackageID)
{
HR_OverTimePackage hR_OverTimePackage = new HR_OverTimePackage();
SqlHR_OverTimePackageProvider sqlHR_OverTimePackageProvider = new SqlHR_OverTimePackageProvider();
hR_OverTimePackage = sqlHR_OverTimePackageProvider.GetHR_OverTimePackageByOverTimePackageID(OverTimePackageID);
return hR_OverTimePackage;
}
private void showHR_OverTimePackageData()
{
HR_OverTimePackage hR_OverTimePackage = new HR_OverTimePackage();
hR_OverTimePackage = HR_OverTimePackageManager.GetHR_OverTimePackageByOverTimePackageID(Int32.Parse(Request.QueryString["ID"]));
txtOverTimePackageName.Text = hR_OverTimePackage.OverTimePackageName.ToString();
txtOverTimeFormula.Text = hR_OverTimePackage.OverTimeFormula.ToString();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
HR_OverTimePackage hR_OverTimePackage = new HR_OverTimePackage();
hR_OverTimePackage.OverTimePackageID = int.Parse(Request.QueryString["ID"].ToString());
hR_OverTimePackage.OverTimePackageName = txtOverTimePackageName.Text;
hR_OverTimePackage.OverTimeFormula = txtOverTimeFormula.Text;
string userID = Profile.card_id;
hR_OverTimePackage.AddedBy = userID;
hR_OverTimePackage.AddedDate = DateTime.Now;
hR_OverTimePackage.ModifiedBy = userID;
hR_OverTimePackage.ModifiedDate = DateTime.Now;
bool resutl = HR_OverTimePackageManager.UpdateHR_OverTimePackage(hR_OverTimePackage);
Response.Redirect("AdminDisplayHR_OverTimePackage.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
HR_OverTimePackage hR_OverTimePackage = new HR_OverTimePackage();
// hR_OverTimePackage.OverTimePackageID= int.Parse(ddlOverTimePackageID.SelectedValue);
hR_OverTimePackage.OverTimePackageName = txtOverTimePackageName.Text;
hR_OverTimePackage.OverTimeFormula = txtOverTimeFormula.Text;
string userID = Profile.card_id;
hR_OverTimePackage.AddedBy = userID;
hR_OverTimePackage.AddedDate = DateTime.Now;
hR_OverTimePackage.ModifiedBy = userID;
hR_OverTimePackage.ModifiedDate = DateTime.Now;
int resutl = HR_OverTimePackageManager.InsertHR_OverTimePackage(hR_OverTimePackage);
Response.Redirect("AdminDisplayHR_OverTimePackage.aspx");
}
public HR_OverTimePackage GetHR_OverTimePackageFromReader(IDataReader reader)
{
try
{
HR_OverTimePackage hR_OverTimePackage = new HR_OverTimePackage
(
DataAccessObject.IsNULL<int>(reader["OverTimePackageID"]),
DataAccessObject.IsNULL<string>(reader["OverTimePackageName"]),
DataAccessObject.IsNULL<string>(reader["OverTimeFormula"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
);
return hR_OverTimePackage;
}
catch(Exception ex)
{
return null;
}
}
public bool UpdateHR_OverTimePackage(HR_OverTimePackage hR_OverTimePackage)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_OverTimePackage", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@OverTimePackageID", SqlDbType.Int).Value = hR_OverTimePackage.OverTimePackageID;
cmd.Parameters.Add("@OverTimePackageName", SqlDbType.NVarChar).Value = hR_OverTimePackage.OverTimePackageName;
cmd.Parameters.Add("@OverTimeFormula", SqlDbType.NVarChar).Value = hR_OverTimePackage.OverTimeFormula;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_OverTimePackage.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_OverTimePackage.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertHR_OverTimePackage(HR_OverTimePackage hR_OverTimePackage)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("InsertHR_OverTimePackage", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@OverTimePackageID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@OverTimePackageName", SqlDbType.NVarChar).Value = hR_OverTimePackage.OverTimePackageName;
cmd.Parameters.Add("@OverTimeFormula", SqlDbType.NVarChar).Value = hR_OverTimePackage.OverTimeFormula;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = hR_OverTimePackage.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = hR_OverTimePackage.AddedDate;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_OverTimePackage.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_OverTimePackage.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@OverTimePackageID"].Value;
}
}
public static bool UpdateHR_OverTimePackage(HR_OverTimePackage hR_OverTimePackage)
{
SqlHR_OverTimePackageProvider sqlHR_OverTimePackageProvider = new SqlHR_OverTimePackageProvider();
return sqlHR_OverTimePackageProvider.UpdateHR_OverTimePackage(hR_OverTimePackage);
}
public static int InsertHR_OverTimePackage(HR_OverTimePackage hR_OverTimePackage)
{
SqlHR_OverTimePackageProvider sqlHR_OverTimePackageProvider = new SqlHR_OverTimePackageProvider();
return sqlHR_OverTimePackageProvider.InsertHR_OverTimePackage(hR_OverTimePackage);
}
