public static int EmployeeLoyaltyPoint_Save(Entity.HR.EmployeeLoyaltyPoint employeeLoyaltyPoint)
{
int rowsAffacted = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_HR_EmployeeLoyaltyPoint_Save";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@LoyaltyId", employeeLoyaltyPoint.LoyaltyId);
cmd.Parameters.AddWithValue("@EmployeeId", employeeLoyaltyPoint.EmployeeId);
cmd.Parameters.AddWithValue("@LoyaltyPointReasonId", employeeLoyaltyPoint.LoyaltyPointReasonId);
cmd.Parameters.AddWithValue("@Point", employeeLoyaltyPoint.Point);
cmd.Parameters.AddWithValue("@Month", employeeLoyaltyPoint.Month);
cmd.Parameters.AddWithValue("@Year", employeeLoyaltyPoint.Year);
cmd.Parameters.AddWithValue("@Note", employeeLoyaltyPoint.Note);
cmd.Parameters.AddWithValue("@CreatedBy", employeeLoyaltyPoint.CreatedBy);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
rowsAffacted = cmd.ExecuteNonQuery();
con.Close();
}
}
return(rowsAffacted);
}
public int EmployeeLoyaltyPoint_Save(Entity.HR.EmployeeLoyaltyPoint employeeLoyaltyPoint)
{
return(DataAccess.HR.EmployeeLoyaltyPoint.EmployeeLoyaltyPoint_Save(employeeLoyaltyPoint));
}
protected void gvEmployeePoint_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
Business.HR.EmployeeLoyaltyPoint objEmployeeLoyaltyPoint = new Business.HR.EmployeeLoyaltyPoint();
if (e.CommandName == "E")
{
Entity.HR.EmployeeLoyaltyPoint employeeLoyaltyPoint = new Entity.HR.EmployeeLoyaltyPoint();
GridViewRow gvEmployeePoint = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
DropDownList ddlLaoyalPointReason = (DropDownList)gvEmployeePoint.FindControl("ddlLaoyalPointReason");
TextBox txtPoint = (TextBox)gvEmployeePoint.FindControl("txtPoint");
TextBox txtNote = (TextBox)gvEmployeePoint.FindControl("txtNote");
employeeLoyaltyPoint.EmployeeId = int.Parse(e.CommandArgument.ToString());
employeeLoyaltyPoint.Month = ddlMonth.SelectedValue;
employeeLoyaltyPoint.Year = int.Parse(ddlYear.SelectedValue);
employeeLoyaltyPoint.LoyaltyPointReasonId = int.Parse(ddlLaoyalPointReason.SelectedValue);
employeeLoyaltyPoint.Point = (!string.IsNullOrEmpty(txtPoint.Text)) ? decimal.Parse(txtPoint.Text) : 0;
employeeLoyaltyPoint.Note = txtNote.Text;
employeeLoyaltyPoint.CreatedBy = Convert.ToInt32(HttpContext.Current.User.Identity.Name);
if (Validation(employeeLoyaltyPoint.LoyaltyPointReasonId))
{
int response = objEmployeeLoyaltyPoint.EmployeeLoyaltyPoint_Save(employeeLoyaltyPoint);
if (response > 0)
{
Message1.IsSuccess = true;
Message1.Text = "Employee Loyalty point is updated.";
}
else
{
Message1.IsSuccess = false;
Message1.Text = "Sorry! Employee Loyalty point is not updated.";
}
Message1.Show = true;
}
}
else if (e.CommandName == "D")
{
GridViewRow gvEmployeePointRow = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);
long loyaltyId = 0;
if (long.TryParse(gvEmployeePoint.DataKeys[gvEmployeePointRow.RowIndex].Values[0].ToString(), out loyaltyId))
{
int response = objEmployeeLoyaltyPoint.EmployeeLoyaltyPoint_Delete(loyaltyId);
if (response > 0)
{
EmployeeLoyaltyPoint_GetAll();
Message1.IsSuccess = true;
Message1.Text = "Employee Loyalty point is deleted.";
}
else
{
Message1.IsSuccess = false;
Message1.Text = "Sorry! Employee Loyalty point is not deleted.";
}
}
Message1.Show = true;
}
}
catch (Exception ex)
{
ex.WriteException();
Message1.IsSuccess = false;
Message1.Text = ex.Message;
Message1.Show = true;
}
}
