public int UpdateTourApplication(TourApplication _TourApplication)
{
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("@TourApplicationID", SqlDbType.Int, _TourApplication.TourApplicationID));
SqlCmd.Parameters.Add(GetParameter("@DateFrom", SqlDbType.DateTime, _TourApplication.DateFrom));
SqlCmd.Parameters.Add(GetParameter("@DateTo", SqlDbType.DateTime, _TourApplication.DateTo));
SqlCmd.Parameters.Add(GetParameter("@TourPurpose", SqlDbType.VarChar, _TourApplication.TourPurpose));
SqlCmd.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
SqlCmd.CommandText = "pHRM_TourApplications_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 int DeletetTourApplication(TourApplication _TourApplication)
{
try
{
return(TourApplicationDataAccess.GetInstance.DeleteTourApplication(_TourApplication));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static int ApproveOrRejectTourApplication(TourApplication _TourApplication)
{
try
{
return(TourApplicationIntegration.ApproveOrRejectTourApplication(_TourApplication));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static List <TourApplication> SetTourApplicationList(DataTable TourApplicationTable)
{
try
{
List <TourApplication> TourApplicationList = new List <TourApplication>();
foreach (DataRow DtRow in TourApplicationTable.Rows)
{
TourApplication _TourApplication = new TourApplication();
_TourApplication.TourApplicationID = int.Parse(DtRow["TourApplicationID"].ToString());
_TourApplication.EmployeeID = int.Parse(DtRow["EmployeeID"].ToString());
_TourApplication.EmployeeCode = DtRow["EmployeeCode"].ToString();
_TourApplication.EmployeeName = DtRow["EmployeeName"].ToString();
_TourApplication.DepartmentDescription = DtRow["DepartmentDescription"].ToString();
_TourApplication.DesignationDescription = DtRow["DesignationDescription"].ToString();
_TourApplication.DateFrom = DateTime.Parse(DtRow["DateFrom"].ToString());
_TourApplication.DateTo = DateTime.Parse(DtRow["DateTo"].ToString());
_TourApplication.TourPurpose = DtRow["TourPurpose"].ToString();
_TourApplication.Status = DtRow["Status"].ToString();
if (DtRow["Status"].ToString() != "Pending")
{
_TourApplication.ApprovedBy.EmployeeID = int.Parse(DtRow["ApprovedBy"].ToString());
_TourApplication.ApprovedByEmployeeID = int.Parse(DtRow["ApprovedBy"].ToString());
//_TourApplication.ApproveDate = DateTime.Parse(DtRow["ApprovedOn"].ToString());
_TourApplication.ApprovalOrRejectionReason = DtRow["ApprovalOrRejectionReason"].ToString();
}
else
{
_TourApplication.ApprovalOrRejectionReason = "-";
}
_TourApplication.IsActive = Boolean.Parse(DtRow["IsActive"].ToString());
_TourApplication.IsDeleted = Boolean.Parse(DtRow["IsDeleted"].ToString());
TourApplicationList.Add(_TourApplication);
}
return(TourApplicationList);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static TourApplication GetTourApplicationByTourApplicationID(int TourApplicationID)
{
try
{
DataRow DtRow = TourApplicationDataAccess.GetInstance.GetTourApplicationByTourApplicationID(TourApplicationID);
TourApplication _TourApplication = new TourApplication();
_TourApplication.TourApplicationID = int.Parse(DtRow["TourApplicationID"].ToString());
_TourApplication.EmployeeID = int.Parse(DtRow["EmployeeID"].ToString());
_TourApplication.EmployeeCode = DtRow["EmployeeCode"].ToString();
_TourApplication.EmployeeName = DtRow["EmployeeName"].ToString();
_TourApplication.DepartmentDescription = DtRow["DepartmentDescription"].ToString();
_TourApplication.DesignationDescription = DtRow["DesignationDescription"].ToString();
_TourApplication.DateFrom = DateTime.Parse(DtRow["DateFrom"].ToString());
_TourApplication.DateTo = DateTime.Parse(DtRow["DateTo"].ToString());
_TourApplication.TourPurpose = DtRow["TourPurpose"].ToString();
_TourApplication.Status = DtRow["Status"].ToString();
if (DtRow["Status"].ToString() != "Pending")
{
_TourApplication.ApprovedBy.EmployeeID = int.Parse(DtRow["ApprovedBy"].ToString());
_TourApplication.ApprovedByEmployeeID = int.Parse(DtRow["ApprovedBy"].ToString());
_TourApplication.ApproveDate = DateTime.Parse(DtRow["ApprovedOn"].ToString());
_TourApplication.ApprovalOrRejectionReason = DtRow["ApprovalOrRejectionReason"].ToString();
}
else
{
_TourApplication.ApprovalOrRejectionReason = "-";
}
_TourApplication.IsActive = Boolean.Parse(DtRow["IsActive"].ToString());
_TourApplication.IsDeleted = Boolean.Parse(DtRow["IsDeleted"].ToString());
return(_TourApplication);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public int DeleteTourApplication(TourApplication _TourApplication)
{
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("@TourApplicationID", SqlDbType.Int, _TourApplication.TourApplicationID));
SqlCmd.CommandText = "pHRM_TourApplications_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));
}
}
