public static HR_EmployeeOverTimePackage GetHR_OverTimePackageByOverTimePackageID(int OverTimePackageID)
{
HR_EmployeeOverTimePackage hR_EmployeeOverTimePackage = new HR_EmployeeOverTimePackage();
SqlHR_EmployeeOverTimePackageProvider sqlHR_EmployeeOverTimePackageProvider = new SqlHR_EmployeeOverTimePackageProvider();
hR_EmployeeOverTimePackage = sqlHR_EmployeeOverTimePackageProvider.GetHR_EmployeeOverTimePackageByOverTimePackageID(OverTimePackageID);
return hR_EmployeeOverTimePackage;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
HR_EmployeeOverTimePackage hR_OverTime = new HR_EmployeeOverTimePackage();
hR_OverTime.OverTimeID = int.Parse(Request.QueryString["ID"].ToString());
hR_OverTime.EmployeeID = Profile.card_id;
hR_OverTime.OverTimePackageID = int.Parse(ddlOverTimePackID.SelectedValue);
hR_OverTime.OverTimeTakaPerHour = decimal.Parse(txtOverTimeTakaPerHour.Text);
hR_OverTime.OverTimeFlag = bool.Parse(radOverTimeFlag.SelectedValue);
hR_OverTime.DayMonth = txtMonthlyTotalHour.Text;
hR_OverTime.OverTimeDate = DateTime.Today;
hR_OverTime.AddedBy = Profile.card_id;
hR_OverTime.AddedDate = DateTime.Now;
hR_OverTime.ModifiedBy = Profile.card_id;
hR_OverTime.ModifiedDate = DateTime.Now;
bool resutl = HR_EmployeeOverTimePackageManager.UpdateHR_EmployeeOverTimePackage(hR_OverTime);
Response.Redirect("AdminDisplayHR_OverTime.aspx");
}
public bool UpdateHR_EmployeeOverTimePackage(HR_EmployeeOverTimePackage hR_EmployeeOverTimePackage)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_EmployeeOverTimePackage", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@OverTimeID", SqlDbType.Int).Value = hR_EmployeeOverTimePackage.OverTimeID;
cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_EmployeeOverTimePackage.EmployeeID;
cmd.Parameters.Add("@OverTimePackageID", SqlDbType.Int).Value = hR_EmployeeOverTimePackage.OverTimePackageID;
cmd.Parameters.Add("@OverTimeTakaPerHour", SqlDbType.Decimal).Value = hR_EmployeeOverTimePackage.OverTimeTakaPerHour;
cmd.Parameters.Add("@OverTimeFlag", SqlDbType.Bit).Value = hR_EmployeeOverTimePackage.OverTimeFlag;
cmd.Parameters.Add("@DayMonth", SqlDbType.NVarChar).Value = hR_EmployeeOverTimePackage.DayMonth;
cmd.Parameters.Add("@OverTimeDate", SqlDbType.DateTime).Value = hR_EmployeeOverTimePackage.OverTimeDate;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_EmployeeOverTimePackage.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_EmployeeOverTimePackage.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public HR_EmployeeOverTimePackage GetHR_EmployeeOverTimePackageFromReader(IDataReader reader)
{
try
{
HR_EmployeeOverTimePackage hR_EmployeeOverTimePackage = new HR_EmployeeOverTimePackage
(
DataAccessObject.IsNULL<int>(reader["OverTimeID"]),
DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()),
DataAccessObject.IsNULL<int>(reader["OverTimePackageID"]),
DataAccessObject.IsNULL<decimal>(reader["OverTimeTakaPerHour"]),
DataAccessObject.IsNULL<bool>(reader["OverTimeFlag"]),
DataAccessObject.IsNULL<string>(reader["DayMonth"]),
DataAccessObject.IsNULL<DateTime>(reader["OverTimeDate"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
);
return hR_EmployeeOverTimePackage;
}
catch(Exception ex)
{
return null;
}
}
protected void btnAddOvertimePackageRule_Click(object sender, EventArgs e)
{
if (hfEmployeeID.Value != null)
{
if (!HR_EmployeeOverTimePackageManager.IsEmployeeExist(hfEmployeeID.Value.ToString()))
{
HR_EmployeeOverTimePackage hR_OverTime = new HR_EmployeeOverTimePackage();
// hR_OverTime.OverTimeID= int.Parse(ddlOverTimeID.SelectedValue);
hR_OverTime.EmployeeID = hfEmployeeID.Value.ToString();
hR_OverTime.OverTimePackageID = int.Parse(ddlOverTimePackID.SelectedValue);
hR_OverTime.OverTimeTakaPerHour = decimal.Parse(txtOverTimeTakaPerHour.Text);
hR_OverTime.OverTimeFlag = bool.Parse(radOverTimeFlag.SelectedValue);
hR_OverTime.DayMonth = txtMonthlyTotalHour.Text;
hR_OverTime.OverTimeDate = DateTime.Today;
string userID = Profile.card_id;
hR_OverTime.AddedBy = userID;
hR_OverTime.AddedDate = DateTime.Now;
hR_OverTime.ModifiedBy = userID;
hR_OverTime.ModifiedDate = DateTime.Now;
int resutl = HR_EmployeeOverTimePackageManager.InsertHR_EmployeeOverTimePackage(hR_OverTime);
lblOvertimePackageRuleMsg.Text = "Overtime package rules Information is saved";
lblOvertimePackageRuleMsg.ForeColor = System.Drawing.Color.Green;
}
else
{
lblOvertimePackageRuleMsg.Text = "Employee informtion is exist.";
lblOvertimePackageRuleMsg.ForeColor = System.Drawing.Color.Red;
}
}
else
{
lblOvertimePackageRuleMsg.Text = "Employee is not specified.";
lblOvertimePackageRuleMsg.ForeColor = System.Drawing.Color.Red;
}
UpdatePanel1.Update();
}
public static int InsertHR_EmployeeOverTimePackage(HR_EmployeeOverTimePackage hR_EmployeeOverTimePackage)
{
SqlHR_EmployeeOverTimePackageProvider sqlHR_EmployeeOverTimePackageProvider = new SqlHR_EmployeeOverTimePackageProvider();
return sqlHR_EmployeeOverTimePackageProvider.InsertHR_EmployeeOverTimePackage(hR_EmployeeOverTimePackage);
}
public static bool UpdateHR_EmployeeOverTimePackage(HR_EmployeeOverTimePackage hR_EmployeeOverTimePackage)
{
SqlHR_EmployeeOverTimePackageProvider sqlHR_EmployeeOverTimePackageProvider = new SqlHR_EmployeeOverTimePackageProvider();
return sqlHR_EmployeeOverTimePackageProvider.UpdateHR_EmployeeOverTimePackage(hR_EmployeeOverTimePackage);
}
