public int UpdateSingleEmployeeComponent(EmpPayrollcomponent TheComponent)
{
try
{
int ReturnValue = 0;
SqlCommand SqlCmd = new SqlCommand();
SqlCmd.CommandType = CommandType.StoredProcedure;
//SqlCmd.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
SqlCmd.Parameters.Add(GetParameter("@RecordNumber", SqlDbType.Int, TheComponent.RecordNo));
SqlCmd.Parameters.Add(GetParameter("@EmployeeID", SqlDbType.Int, TheComponent.EmployeeID));
SqlCmd.Parameters.Add(GetParameter("@PayComponentID", SqlDbType.Int, TheComponent.PayComponentID));
SqlCmd.Parameters.Add(GetParameter("@PayComponentValue", SqlDbType.VarChar, TheComponent.PayComponentAmount));
SqlCmd.Parameters.Add(GetParameter("@SessionID", SqlDbType.Int, TheComponent.SessionID));
//SqlCmd.Parameters.Add(GetParameter("@ReportingToDesignationID", SqlDbType.Int, dt.Columns[2].ColumnName));
SqlCmd.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, TheComponent.AddedBy));
SqlCmd.CommandText = "pHRMS_MST_EmployeePayComponents_Update";
ExecuteStoredProcedure(SqlCmd);
ReturnValue = int.Parse(SqlCmd.Parameters[0].Value.ToString());;
return(ReturnValue);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
protected void GridBindEmpPayComponents_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string ComponentType = string.Empty;
string ComponentID = string.Empty;
int RecordID = int.Parse(((Label)(GridBindEmpPayComponents.Rows[e.RowIndex].Cells[1].FindControl("lbleid"))).Text);
string PayComponentVal = ((DropDownList)(GridBindEmpPayComponents.Rows[e.RowIndex].Cells[1].FindControl("ddlPayComponent"))).SelectedValue;
string ComponentValue = ((TextBox)(GridBindEmpPayComponents.Rows[e.RowIndex].Cells[1].FindControl("txtPCValue"))).Text;
if (PayComponentVal.Contains("||"))
{
string[] values = PayComponentVal.Split(new string[] { "||" }, StringSplitOptions.RemoveEmptyEntries);
if (values.Length > 0)
{
ComponentType = values[0];
ComponentID = values[1];
}
}
EmpPayrollcomponent TheComponent = new EmpPayrollcomponent();
TheComponent.RecordNo = RecordID;
TheComponent.EmployeeID = int.Parse(lblemployeeBind.Text);
TheComponent.PayComponentID = int.Parse(ComponentID);
TheComponent.PayComponentAmount = ComponentValue;
TheComponent.SessionID = 1;
TheComponent.ModifiedBy = 1;
PayrollComponentManagement.GetInstance.UpdateSingleEmployeeComponent(TheComponent);
GridBindEmpPayComponents.EditIndex = -1;
BindEmployeePayComponents(int.Parse(lblemployeeBind.Text));
}
protected void GridBindEmpPayComponents_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals(MicroConstants.COMMAND_INSERT))
{
string ComponentType = string.Empty;
string ComponentID = string.Empty;
TextBox txtPCaddValue = (TextBox)GridBindEmpPayComponents.FooterRow.FindControl("txtPCaddValue");
DropDownList ddladdPayComponent = (DropDownList)GridBindEmpPayComponents.FooterRow.FindControl("ddladdPayComponent");
DropDownList ddladdPayComponentType = (DropDownList)GridBindEmpPayComponents.FooterRow.FindControl("ddladdPayComponentType");
if (ddladdPayComponent.SelectedValue.Contains("||"))
{
string[] values = ddladdPayComponent.SelectedValue.Split(new string[] { "||" }, StringSplitOptions.RemoveEmptyEntries);
if (values.Length > 0)
{
ComponentType = values[0];
ComponentID = values[1];
ddladdPayComponentType.SelectedValue = ComponentType;
}
}
EmpPayrollcomponent TheComponent = new EmpPayrollcomponent();
TheComponent.EmployeeID = int.Parse(lblemployeeBind.Text);
TheComponent.PayComponentID = int.Parse(ComponentID);
TheComponent.PayComponentAmount = txtPCaddValue.Text;
TheComponent.SessionID = 1;
TheComponent.AddedBy = 1;
PayrollComponentManagement.GetInstance.InsertSingleEmployeeComponent(TheComponent);
BindEmployeePayComponents(int.Parse(lblemployeeBind.Text));
}
}
protected void GridBindEmpPayComponents_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int RecordID = Convert.ToInt32(GridBindEmpPayComponents.DataKeys[e.RowIndex].Value);
EmpPayrollcomponent TheComponent = new EmpPayrollcomponent();
TheComponent.RecordNo = RecordID;
PayrollComponentManagement.GetInstance.DeleteSingleEmployeeComponent(TheComponent);
BindEmployeePayComponents(int.Parse(lblemployeeBind.Text));
}
private int InsertEmployeeComponents(DataTable dt)
{
EmpPayrollcomponent TheComponent = new EmpPayrollcomponent();
TheComponent.EmployeeID = int.Parse(lblemployeeBind.Text);
TheComponent.SessionID = 1;
int ReturnValue = PayrollComponentManagement.GetInstance.InsertEmpPayRollComponent(dt, TheComponent);
return(ReturnValue);
}
public int InsertEmployeeComponent(DataTable dt, EmpPayrollcomponent TheComponent)
{
try
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ICAS_DEV"].ConnectionString);
using (SqlBulkCopy sbc = new SqlBulkCopy(con))
{
sbc.DestinationTableName = "HRMS_MST_EmployeesPayComponents";
// Number of records to be processed in one go
sbc.BatchSize = 5;
// Map the Source Column from DataTabel to the Destination Columns in SQL Server 2005 Person Table
sbc.ColumnMappings.Add("EmployeeID", "EmployeeID");
sbc.ColumnMappings.Add("PayComponentID", "PayComponentID");
sbc.ColumnMappings.Add("ComponentValue", "PayAmount");
sbc.ColumnMappings.Add("SessionID", "SessionID");
sbc.ColumnMappings.Add("AddedBy", "AddedBy");
// Number of records after which client has to be notified about its status
sbc.NotifyAfter = dt.Rows.Count;
// Event that gets fired when NotifyAfter number of records are processed.
sbc.SqlRowsCopied += new SqlRowsCopiedEventHandler(sbc_SqlRowsCopied);
// Finally write to server
con.Close();
con.Open();
sbc.WriteToServer(dt);
sbc.Close();
con.Close();
}
int ReturnValue = 0;
//SqlCommand SqlCmd = new SqlCommand();
//SqlCmd.CommandType = CommandType.StoredProcedure;
////SqlCmd.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
//SqlCmd.Parameters.Add(GetParameter("@EmployeeID", SqlDbType.VarChar, dt.Columns[0].ColumnName));
//SqlCmd.Parameters.Add(GetParameter("@PayComponentID",SqlDbType.VarChar, dt.Columns[1].ColumnName));
//SqlCmd.Parameters.Add(GetParameter("@PayAmount", SqlDbType.VarChar, dt.Columns[3].ColumnName));
//SqlCmd.Parameters.Add(GetParameter("@SessionID", SqlDbType.VarChar, dt.Columns[5].ColumnName));
////SqlCmd.Parameters.Add(GetParameter("@ReportingToDesignationID", SqlDbType.Int, dt.Columns[2].ColumnName));
//SqlCmd.Parameters.Add(GetParameter("@AddedBy",SqlDbType.VarChar,dt.Columns[6].ColumnName));
//SqlCmd.CommandText = "pHRMS_MST_EmployeePayComponents_Insert";
//SqlDataAdapter adpt = new SqlDataAdapter();
//adpt.InsertCommand = SqlCmd;
//// Specify the number of records to be Inserted/Updated in one go. Default is 1.
//adpt.UpdateBatchSize = 5;
//ReturnValue = adpt.Update(dt);
////ExecuteStoredProcedure(SqlCmd);
ReturnValue = 1;
return(ReturnValue);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static int DeleteSingleEmployeeComponent(EmpPayrollcomponent theComponent)
{
try
{
return(PayrollComponentDataAccess.GetInstance.DeleteSingleEmployeeComponent(theComponent));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static List <EmpPayrollcomponent> GetEmployeePayrollComponentList(int EmployeeID)
{
List <EmpPayrollcomponent> EmployeeComponentList = new List <EmpPayrollcomponent>();
DataTable EmployeeComponentTable = PayrollComponentDataAccess.GetInstance.GetEmployeePayrollComponentList(EmployeeID);
foreach (DataRow dr in EmployeeComponentTable.Rows)
{
EmpPayrollcomponent TheComponent = EmpPayComponentRowToObject(dr);
EmployeeComponentList.Add(TheComponent);
}
return(EmployeeComponentList);
}
public static EmpPayrollcomponent EmpPayComponentRowToObject(DataRow dr)
{
EmpPayrollcomponent ThePayComponent = new EmpPayrollcomponent();
ThePayComponent.RecordNo = int.Parse(dr["RecordNumber"].ToString());
ThePayComponent.PayComponentID = int.Parse(dr["PayComponentID"].ToString());
ThePayComponent.PayComponentName = dr["PayComponentName"].ToString();
ThePayComponent.PayComponentType = dr["PayComponentType"].ToString();
ThePayComponent.PayComponentCategory = dr["PayComponentCategory"].ToString();
ThePayComponent.PayComponentDesc = dr["PayComponentType"].ToString() + "||" + dr["PayComponentID"].ToString();
ThePayComponent.PayComponentAmount = dr["PayAmount"].ToString();
ThePayComponent.SessionID = int.Parse(dr["SessionID"].ToString());
ThePayComponent.AddedByName = dr["AddedByName"].ToString();
ThePayComponent.AddedByCode = dr["AddedByCode"].ToString();
return(ThePayComponent);
}
public int DeleteSingleEmployeeComponent(EmpPayrollcomponent TheComponent)
{
try
{
int ReturnValue = 0;
SqlCommand SqlCmd = new SqlCommand();
SqlCmd.CommandType = CommandType.StoredProcedure;
//SqlCmd.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
SqlCmd.Parameters.Add(GetParameter("@RecordNumber", SqlDbType.Int, TheComponent.RecordNo));
SqlCmd.CommandText = "pHRMS_MST_EmployeePayComponents_Delete";
ExecuteStoredProcedure(SqlCmd);
ReturnValue = int.Parse(SqlCmd.Parameters[0].Value.ToString());
return(ReturnValue);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public int DeleteSingleEmployeeComponent(EmpPayrollcomponent theComponent)
{
return(PayrollComponentIntegration.DeleteSingleEmployeeComponent(theComponent));
}
public int InsertEmpPayRollComponent(DataTable dt, EmpPayrollcomponent theComponent)
{
return(PayrollComponentIntegration.InsertEmpPayRollComponent(dt, theComponent));
}
