/// <summary>
/// MEthod to set the attendance for a registration
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateAttendanceInfo(AttendanceReportModel model)
{
bool save = true;
try
{
using (LBCData context = new LBCData(ConnectionHelper.getConnectionString()))
{
var _attend = (from rg in context.LBC_REGISTRATION
where rg.STARS_ID == model.STARS_ID && rg.EVENT_ID == model.EVENT_ID
select rg).FirstOrDefault();
_attend.ATTENDED = model.ATTENDED;
_attend.UPDATE_DATE = DateTime.Now;
_attend.UPDATED_BY = System.Web.HttpContext.Current.Session["w_user"].ToString();
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
// save = false;
}
return(save);
}
public DataSet GetAttendanceReport(AttendanceReportModel objAttendanceReportModel, Boolean IsAdmin, Boolean AllTeammembers)
{
DataSet dsGetAttendanceReport = new DataSet();
// SqlParameter[] sqlParams = new SqlParameter[5];
//sqlParams[0] = new SqlParameter("@EmployeeId", SqlDbType.Int);
//sqlParams[0].Value = objAttendanceReportModel.UserId;
//sqlParams[1] = new SqlParameter("@month", SqlDbType.VarChar, 15);
//sqlParams[1].Value = objAttendanceReportModel.Month;
//sqlParams[2] = new SqlParameter("@year", SqlDbType.VarChar, 10);
//sqlParams[2].Value = objAttendanceReportModel.Year;
//sqlParams[3] = new SqlParameter("@IsAdmin", SqlDbType.Bit);
//sqlParams[3].Value = IsAdmin;
//sqlParams[4] = new SqlParameter("@AllTeammembers", SqlDbType.Bit);
//sqlParams[4].Value = AllTeammembers ;
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AttendanceReport";
cmd.CommandTimeout = 6000;
//cmd.Parameters.Add(sqlParams);
cmd.Parameters.Add("@EmployeeId", SqlDbType.Int);
cmd.Parameters["@EmployeeId"].Value = objAttendanceReportModel.UserId;
cmd.Parameters.Add("@ShiftId", SqlDbType.Int);
cmd.Parameters["@ShiftId"].Value = objAttendanceReportModel.ShiftID;
cmd.Parameters.Add("@month", SqlDbType.VarChar);
cmd.Parameters["@month"].Value = objAttendanceReportModel.Month;
cmd.Parameters.Add("@year", SqlDbType.VarChar);
cmd.Parameters["@year"].Value = objAttendanceReportModel.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);
da.Fill(dsGetAttendanceReport);
return(dsGetAttendanceReport);
// dsGetAttendanceReport = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "AttendanceReport", sqlParams);
//return dsGetAttendanceReport;
}
public DataSet BindEmployee(AttendanceReportModel objAttendanceReportModel)
{
DataSet dsEmployeeName;
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@UserID", SqlDbType.Int);
sqlParams[0].Value = objAttendanceReportModel.UserId;
dsEmployeeName = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "GetEmployeeNameRpt", sqlParams);
return(dsEmployeeName);
}
/// <summary>
/// Method to Bind the Model
/// </summary>
/// <param name="StarsId"></param>
/// <returns></returns>
public AttendanceReportModel GetAttendanceInfoByStarsId(string StarsId)
{
AttendanceReportModel model = new AttendanceReportModel();
using (LBCData context = new LBCData(ConnectionHelper.getConnectionString()))
{
var lst = from rg in context.LBC_REGISTRATION
join _ev in context.LBC_EVENT on rg.EVENT_ID equals _ev.EVENT_ID
join pr in context.LBC_PROFILE on rg.STARS_ID equals pr.STARS_ID
where pr.STARS_ID == StarsId && rg.REGD_STATUS == "A"
select new AttendanceReportModel
{
STARS_ID = pr.STARS_ID,
PA_CODE = pr.PA_CODE,
WSLX_ID = pr.WSLX_ID,
TITLE = pr.TITLE,
EMAIL_ID = pr.EMAIL_ID,
CONTACT = pr.DLR_PHONE,
DLR_NAME = pr.DLR_NAME,
DLR_ADDRESS = pr.DLR_ADDRESS,
DLR_CITY = pr.DLR_CITY,
DLR_STATE = pr.DLR_STATE,
ATTENDED = rg.ATTENDED,
EVENT = _ev.EVENT_SESSION,
EVENT_ID = _ev.EVENT_ID,
MARKET = pr.DLR_REGION,
PARTICIPANT_COMPANY = "Ma",
PARTICIPANT_ROLE = "GUEST",
REGISTERED_PARTICIPANT = pr.FIRST_NAME + " " + pr.LAST_NAME,
FIRST_NAME = pr.FIRST_NAME,
LAST_NAME = pr.LAST_NAME
};
model = lst.SingleOrDefault();
}
return(model);
}
/// <summary>
/// 确认报表信息
/// </summary>
/// <param name="AttendanceReportM">报表信息</param>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool ConfirmAttendanceChangeInfo(AttendanceReportModel AttendanceReportM)
{
return(AttendanceReportDBHelper.ConfirmAttendanceChangeInfo(AttendanceReportM));
}
/// <summary>
/// 修改考勤报表信息
/// </summary>
/// <param name="AttendanceReportM">报表信息</param>
/// <param name="reportdatas">报表详细</param>
/// <returns>更新是否成功 false:失败，true:成功</returns>
public static bool UpdateAttendanceReportInfo(AttendanceReportModel AttendanceReportM, string reportdatas)
{
return(AttendanceReportDBHelper.UpdateAttendanceReportInfo(AttendanceReportM, reportdatas));
}
public DataSet GetAttendanceReport(AttendanceReportModel objAttendanceReportModel, Boolean IsAdmin, Boolean AllTeammembers)
{
return(objAttendanceReportDAL.GetAttendanceReport(objAttendanceReportModel, IsAdmin, AllTeammembers));
}
public System.Data.DataSet BindEmployee(AttendanceReportModel objAttendanceReportModel)
{
return(objAttendanceReportDAL.BindEmployee(objAttendanceReportModel));
}
public AttendanceReportController()
{
_model = new AttendanceReportModel();
}
public bool UpdateAttendanceInfo(AttendanceReportModel model)
{
AttendanceInfoRepository _attend = new AttendanceInfoRepository();
return(_attend.UpdateAttendanceInfo(model));
}