public static List <KeyValueVM> Rpt_BindYears()
{
List <KeyValueVM> YearsList = new List <KeyValueVM>();
try
{
using (DBSqlCommand cmd = new DBSqlCommand(CommandType.StoredProcedure))
{
IDataReader ireader = cmd.ExecuteDataReader(SqlProcedures.Rpt_BindYears);
while (ireader.Read())
{
var Year = new KeyValueVM
{
value = ireader.GetString(CommonColumns.Year),
key = Convert.ToInt32(ireader.GetString(CommonColumns.Year))
};
YearsList.Add(Year);
}
}
}
catch (Exception ex)
{
throw new ArgumentException("Exception in Rpt_BindYears. Exception :" + ex.Message);
}
return(YearsList);
}
public static IList <KeyValueVM> GetCompanyName(int BusinessId, int UserId)
{
List <KeyValueVM> GetCompany = new List <KeyValueVM>();
try
{
using (DBSqlCommand cmd = new DBSqlCommand(CommandType.StoredProcedure))
{
cmd.AddParameters(BusinessId, CommonConstants.BusinessID, SqlDbType.Int);
cmd.AddParameters(UserId, CommonConstants.UserId, SqlDbType.Int);
IDataReader ireader = cmd.ExecuteDataReader(SqlProcedures.Get_CompanyName);
while (ireader.Read())
{
var Employees = new KeyValueVM
{
value = ireader.GetString(CommonColumns.BusinessName),
key = ireader.GetInt32(CommonColumns.BusinessID),
};
GetCompany.Add(Employees);
}
}
}
catch (Exception ex)
{
return(null);
}
return(GetCompany);
}
public static IList <KeyValueVM> Get_Years(int UserId)
{
List <KeyValueVM> GetYears = new List <KeyValueVM>();
try
{
using (DBSqlCommand cmd = new DBSqlCommand(CommandType.StoredProcedure))
{
//cmd.AddParameters(UserId, CommonConstants.UserId, SqlDbType.Int);
IDataReader ireader = cmd.ExecuteDataReader(SqlProcedures.Get_EmpLeaves);
while (ireader.Read())
{
var Years = new KeyValueVM
{
value = ireader.GetString(CommonColumns.Year),
key = ireader.GetInt32(CommonColumns.Year),
};
GetYears.Add(Years);
}
}
}
catch (Exception ex)
{
throw new ArgumentException("Exception in Get_Genders. Exception :" + ex.Message);
}
return(GetYears);
}
public static IList <KeyValueVM> Get_Locations()
{
List <KeyValueVM> GetEmployees = new List <KeyValueVM>();
try
{
using (DBSqlCommand cmd = new DBSqlCommand(CommandType.StoredProcedure))
{
IDataReader ireader = cmd.ExecuteDataReader(SqlProcedures.Get_Locations);
while (ireader.Read())
{
var Employees = new KeyValueVM
{
value = ireader.GetString(CommonColumns.LocationName),
key = ireader.GetInt32(CommonColumns.LocationId),
};
GetEmployees.Add(Employees);
}
}
}
catch (Exception ex)
{
throw new ArgumentException("Exception in Get_Genders. Exception :" + ex.Message);
}
return(GetEmployees);
}
public static IList <KeyValueVM> Get_LogmeOut()
{
try
{
using (DBSqlCommand cmd = new DBSqlCommand())
{
var reader = cmd.ExecuteDataReader(SqlProcedures.Get_LogMeOut);
var keyValues = new List <KeyValueVM>();
while (reader.Read())
{
var keyValue = new KeyValueVM();
keyValue.value = reader.GetString("Description");
keyValue.key = reader.GetInt32("LogMeOutId");
keyValues.Add(keyValue);
}
return(keyValues);
}
}
catch (Exception ex)
{
throw new ArgumentException("Exception in Get_LogmeOut. Exception:" + ex.Message);
}
}
