public int UpdateLeaveTypeOfficewise(LeaveTypeOfficewise _LeaveTypeOfficewise)
{
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("LeaveTypeOfficewiseID", SqlDbType.Int, _LeaveTypeOfficewise.LeaveTypeOfficewiseID));
SqlCmd.Parameters.Add(GetParameter("@LeaveTypeID", SqlDbType.Int, _LeaveTypeOfficewise.LeaveTypeID));
SqlCmd.Parameters.Add(GetParameter("@OfficeID", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.CompanyID));
SqlCmd.Parameters.Add(GetParameter("@IsActive", SqlDbType.Bit, (_LeaveTypeOfficewise.IsActive == true ? 1 : 0)));
SqlCmd.Parameters.Add(GetParameter("@DateModified", SqlDbType.DateTime, DateTime.Now));
SqlCmd.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
SqlCmd.CommandText = "pHRM_LeaveTypesOfficewise_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));
}
}
public static List <LeaveTypeOfficewise> GetLeaveTypeOfficewiseByOfficeID(int OfficeID = -1)
{
try
{
DataTable LeaveTypeOfficewiseRows = LeaveTypeOfficewiseDataAccess.GetInstance.GetLeaveTypeOfficewiseByOfficeID();
List <LeaveTypeOfficewise> _LeaveTypeOfficewiseList = new List <LeaveTypeOfficewise>();
foreach (DataRow dr in LeaveTypeOfficewiseRows.Rows)
{
LeaveTypeOfficewise _LeaveTypeOfficewise = new LeaveTypeOfficewise();
_LeaveTypeOfficewise.LeaveTypeOfficewiseID = int.Parse(dr["LeaveTypeOfficewiseID"].ToString());
_LeaveTypeOfficewise.LeaveTypeID = int.Parse(dr["LeaveTypeID"].ToString());
_LeaveTypeOfficewise.LeaveTypeDescription = dr["LeaveTypeDescription"].ToString();
_LeaveTypeOfficewise.LeaveTypeAlias = dr["LeaveTypeAlias"].ToString();
_LeaveTypeOfficewise.Office.OfficeID = int.Parse(dr["OfficeID"].ToString());
_LeaveTypeOfficewise.IsActive = Boolean.Parse(dr["IsActive"].ToString());
_LeaveTypeOfficewise.IsDeleted = Boolean.Parse(dr["IsDeleted"].ToString());
_LeaveTypeOfficewiseList.Add(_LeaveTypeOfficewise);
}
return(_LeaveTypeOfficewiseList);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public int UpdateLeaveTypeOfficewise(LeaveTypeOfficewise _LeaveTypeOfficewise)
{
try
{
return(LeaveTypeOfficewiseIntegration.UpdateLeaveTypeOfficewise(_LeaveTypeOfficewise));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static int InsertLeaveTypeOfficewise(LeaveTypeOfficewise _LeaveTypeOfficewise)
{
try
{
return(LeaveTypeOfficewiseDataAccess.GetInstance.InsertLeaveTypeOfficewise(_LeaveTypeOfficewise));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
