public DataSet GetEmployeeNameRpt(AbsenteeismReportModel objAbsenteeismReportModel)
{
try
{
return(objAbsenteeismReportDAL.GetEmployeeNameRpt(objAbsenteeismReportModel));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "AbsenteeismReportBOL", "GetEmployeeNameRpt", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet AbsenteeismReport(AbsenteeismReportModel objAbsenteeismReportModel, bool IsAdmin, bool AllTeammembers)
{
try
{
return(objAbsenteeismReportDAL.AbsenteeismReport(objAbsenteeismReportModel, IsAdmin, AllTeammembers));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "AbsentismReportBOL", "AbsentismReport", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet GetEmployeeNameRpt(AbsenteeismReportModel objAbsenteeismReportModelModel)
{
DataSet dsGetEmployeeNameRpt;
SqlParameter[] objSqlParam = new SqlParameter[1];
objSqlParam[0] = new SqlParameter("@UserID", SqlDbType.Int);
objSqlParam[0].Value = objAbsenteeismReportModelModel.UserId;
try
{
dsGetEmployeeNameRpt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "GetEmployeeNameRpt", objSqlParam);
return(dsGetEmployeeNameRpt);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "AbsentismReportDAL.cs", "GetEmployeeNameRpt", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet AbsenteeismReport(AbsenteeismReportModel objAbsenteeismReportModel, bool IsAdmin, bool AllTeammembers)
{
DataSet dsAbsenteeismReport = new DataSet();
//SqlParameter[] objSqlParam = new SqlParameter[8];
//objSqlParam[0] = new SqlParameter("@UserId", SqlDbType.Int);
//objSqlParam[0].Value = objAbsenteeismReportModel.UserId;
//objSqlParam[1] = new SqlParameter("@period", SqlDbType.NVarChar);
//objSqlParam[1].Value = objAbsenteeismReportModel.Period;
//if (objAbsenteeismReportModel.FromDate.ToString() != "1/1/0001 12:00:00 AM")
//{
// objSqlParam[2] = new SqlParameter("@FromDate", SqlDbType.DateTime);
// objSqlParam[2].Value = objAbsenteeismReportModel.FromDate;
//}
//else
//{
// objSqlParam[2] = new SqlParameter("@FromDate", SqlDbType.DateTime);
// objSqlParam[2].Value = null;
//}
//if (objAbsenteeismReportModel.ToDate.ToString() != "1/1/0001 12:00:00 AM")
//{
// objSqlParam[3] = new SqlParameter("@Todate", SqlDbType.DateTime);
// objSqlParam[3].Value = objAbsenteeismReportModel.ToDate;
//}
//else
//{
// objSqlParam[3] = new SqlParameter("@Todate", SqlDbType.DateTime);
// objSqlParam[3].Value = null;
//}
//objSqlParam[4] = new SqlParameter("@Month", SqlDbType.NVarChar);
//objSqlParam[4].Value = objAbsenteeismReportModel.Month;
//objSqlParam[5] = new SqlParameter("@Year", SqlDbType.NVarChar);
//objSqlParam[5].Value = objAbsenteeismReportModel.Year;
//objSqlParam[6] = new SqlParameter("@IsAdmin", SqlDbType.Bit);
//objSqlParam[6].Value = IsAdmin;
//objSqlParam[7] = new SqlParameter("@AllTeammembers", SqlDbType.Bit);
//objSqlParam[7].Value = AllTeammembers;
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AbsenteeismReport";
cmd.CommandTimeout = 6000;
//cmd.Parameters.Add(sqlParams);
cmd.Parameters.Add("@UserId", SqlDbType.Int);
cmd.Parameters["@UserId"].Value = objAbsenteeismReportModel.UserId;
cmd.Parameters.Add("@ShiftID", SqlDbType.Int);
cmd.Parameters["@ShiftID"].Value = objAbsenteeismReportModel.ShiftID;
cmd.Parameters.Add("@Period", SqlDbType.NVarChar);
cmd.Parameters["@Period"].Value = objAbsenteeismReportModel.Period;
if (objAbsenteeismReportModel.FromDate.ToString() != "1/1/0001 12:00:00 AM")
{
cmd.Parameters.Add("@FromDate", SqlDbType.DateTime);
cmd.Parameters["@FromDate"].Value = objAbsenteeismReportModel.FromDate;
}
else
{
cmd.Parameters.Add("@FromDate", SqlDbType.DateTime);
cmd.Parameters["@FromDate"].Value = null;
}
if (objAbsenteeismReportModel.ToDate.ToString() != "1/1/0001 12:00:00 AM")
{
cmd.Parameters.Add("@Todate", SqlDbType.DateTime);
cmd.Parameters["@Todate"].Value = objAbsenteeismReportModel.ToDate;
}
else
{
cmd.Parameters.Add("@Todate", SqlDbType.DateTime);
cmd.Parameters["@Todate"].Value = null;
}
//objSqlParam[7] = new SqlParameter("@AllTeammembers", SqlDbType.Bit);
//objSqlParam[7].Value = AllTeammembers;
cmd.Parameters.Add("@month", SqlDbType.NVarChar);
cmd.Parameters["@month"].Value = objAbsenteeismReportModel.Month;
cmd.Parameters.Add("@year", SqlDbType.NVarChar);
cmd.Parameters["@year"].Value = objAbsenteeismReportModel.Year;
cmd.Parameters.Add("@IsAdmin", SqlDbType.Bit);
cmd.Parameters["@IsAdmin"].Value = IsAdmin;
cmd.Parameters.Add("@AllTeammembers", SqlDbType.Bit);
cmd.Parameters["@AllTeammembers"].Value = AllTeammembers;
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
da.Fill(dsAbsenteeismReport);
return(dsAbsenteeismReport);
//dsAbsenteeismReport = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "AbsenteeismReport", objSqlParam);
//return dsAbsenteeismReport;
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "AbsenteeismReportDAL.cs", "AbsenteeismReport", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
