public List <MyRequestDetailsDO> GetAllRequestDA(int userId)
{
List <MyRequestDetailsDO> myRequestListDO = new List <MyRequestDetailsDO>();
SqlParameter ParamUserId = new SqlParameter("@UserId", SqlDbType.Int);
try
{
if (userId != 0)
{
ParamUserId.Value = userId;
}
else
{
ParamUserId.Value = 0;
}
using (var context = new AWFContext())
{
myRequestListDO = context.Database.SqlQuery <MyRequestDetailsDO>("[usp_Get_MyRequest] @UserId", ParamUserId).ToList();
}
}
catch (Exception ex)
{
throw;
}
return(myRequestListDO);
}
public List <MyApprovalDetailsDO> GetApprovalDA(int userId, int requestId, string type)
{
List <MyApprovalDetailsDO> myApprovalListDO = new List <MyApprovalDetailsDO>();
SqlParameter ParamUserId = new SqlParameter("@UserId", SqlDbType.Int);
try
{
if (userId != 0)
{
ParamUserId.Value = userId;
}
else
{
ParamUserId.Value = 0;
}
SqlParameter ParamRequestId = new SqlParameter("@RequestId", SqlDbType.Int);
ParamRequestId.Value = requestId;
SqlParameter ParamType = new SqlParameter("@Type", SqlDbType.VarChar);
ParamType.Value = type;
using (var context = new AWFContext())
{
myApprovalListDO = context.Database.SqlQuery <MyApprovalDetailsDO>("[usp_Get_MyApproval] @UserId, @RequestId, @Type", ParamUserId, ParamRequestId, ParamType).ToList();
}
}
catch (Exception ex)
{
throw;
}
return(myApprovalListDO);
}
public string UpdateRequestDA(UpdateRequestDetailsDO updateRequestDetailsDO)
{
string status;
try
{
using (var context = new AWFContext())
{
SqlParameter ParamComment = new SqlParameter("@Comment", SqlDbType.VarChar, 100);
ParamComment.Value = updateRequestDetailsDO.Comment;
SqlParameter ParamOption = new SqlParameter("@Option", SqlDbType.VarChar, 30);
ParamOption.Value = updateRequestDetailsDO.Option;
SqlParameter ParamUserName = new SqlParameter("@UserName", SqlDbType.VarChar, 20);
ParamUserName.Value = updateRequestDetailsDO.UserName; //"BLEPLAE";//
SqlParameter ParamRequestNo = new SqlParameter("@RequestNo", SqlDbType.Int);
ParamRequestNo.Value = Convert.ToInt32(updateRequestDetailsDO.RequestNo);
SqlParameter ParamTaskId = new SqlParameter("@TaskId", SqlDbType.VarChar, 20);
ParamTaskId.Value = updateRequestDetailsDO.TaskId;
SqlParameter StatusOUT = new SqlParameter("@Status", SqlDbType.VarChar, 15);
StatusOUT.Direction = ParameterDirection.Output;
context.Database.ExecuteSqlCommand("[usp_UpdateRequest] @Comment, @Option, @UserName, @RequestNo, @TaskId, @Status OUTPUT",
ParamComment,
ParamOption,
ParamUserName,
ParamRequestNo,
ParamTaskId,
StatusOUT
);
status = StatusOUT.Value.ToString();
}
}
catch (Exception ex)
{
throw;
}
return(status);
}
public List <RequestStatusDO> GetStatus(string id)
{
List <RequestStatusDO> myRequesStatustListDO = new List <RequestStatusDO>();
try
{
SqlParameter ParamRequestId = new SqlParameter("@RequestId", SqlDbType.Int);
ParamRequestId.Value = Convert.ToInt32(id);
using (var context = new AWFContext())
{
myRequesStatustListDO = context.Database.SqlQuery <RequestStatusDO>("[usp_Get_RequestStatus] @RequestId", ParamRequestId).ToList();
}
}
catch (Exception ex)
{
throw;
}
return(myRequesStatustListDO);
}
public List <AuditDO> GetAuditDA(string itemsPerPage, string pageno)
{
List <AuditDO> auditDOList = new List <AuditDO>();
try
{
SqlParameter ParamItemsPerPage = new SqlParameter("@ItemsPerPage", SqlDbType.Int);
ParamItemsPerPage.Value = Convert.ToInt16(itemsPerPage);
SqlParameter ParamPageno = new SqlParameter("@Pageno", SqlDbType.Int);
ParamPageno.Value = Convert.ToInt16(pageno);
using (var context = new AWFContext())
{
auditDOList = context.Database.SqlQuery <AuditDO>("[usp_GetAudits] @ItemsPerPage, @Pageno", ParamItemsPerPage, ParamPageno).ToList();
}
}
catch (Exception ex)
{
throw;
}
return(auditDOList);
}
public int SubmitRequestDA(RequestUserDetailsDO requestUserDetailsDO)
{
int RequestId = 0;
try
{
using (var context = new AWFContext())
{
SqlParameter ParamRequesterUserId = new SqlParameter("@RequesterUserId", SqlDbType.Int);
ParamRequesterUserId.Value = Convert.ToInt32(requestUserDetailsDO.RequesterDO.User.UserId);
SqlParameter ParamRequesterFirstName = new SqlParameter("@RequesterFirstName", SqlDbType.VarChar, 20);
ParamRequesterFirstName.Value = requestUserDetailsDO.RequesterDO.User.FirstName;
SqlParameter ParamRequesterLastName = new SqlParameter("@RequesterLastName", SqlDbType.VarChar, 20);
ParamRequesterLastName.Value = requestUserDetailsDO.RequesterDO.User.LastName;
SqlParameter ParamRequesterEmailId = new SqlParameter("@RequesterEmailId", SqlDbType.VarChar, 50);
ParamRequesterEmailId.Value = requestUserDetailsDO.RequesterDO.User.EmailId;
SqlParameter ParamRequesterNTId = new SqlParameter("@RequesterNTId", SqlDbType.VarChar, 15);
ParamRequesterNTId.Value = requestUserDetailsDO.RequesterDO.User.NTId;
SqlParameter ParamManagerUserId = new SqlParameter("@ManagerUserId", SqlDbType.Int);
ParamManagerUserId.Value = Convert.ToInt32(requestUserDetailsDO.ManagerDO.User.UserId);
SqlParameter ParamManagerFirstName = new SqlParameter("@ManagerFirstName", SqlDbType.VarChar, 20);
ParamManagerFirstName.Value = requestUserDetailsDO.ManagerDO.User.FirstName;
SqlParameter ParamManagerLastName = new SqlParameter("@ManagerLastName", SqlDbType.VarChar, 20);
ParamManagerLastName.Value = requestUserDetailsDO.ManagerDO.User.LastName;
SqlParameter ParamManagerEmailId = new SqlParameter("@ManagerEmailId", SqlDbType.VarChar, 50);
ParamManagerEmailId.Value = requestUserDetailsDO.ManagerDO.User.EmailId;
SqlParameter ParamManagerNTId = new SqlParameter("@ManagerNTId", SqlDbType.VarChar, 15);
ParamManagerNTId.Value = requestUserDetailsDO.ManagerDO.User.NTId;
SqlParameter ParamApplicationId = new SqlParameter("@ApplicationId", SqlDbType.Int);
ParamApplicationId.Value = Convert.ToInt32(requestUserDetailsDO.ApplicationId);
SqlParameter ParamRequestStateId = new SqlParameter("@RequestStateId", SqlDbType.Int);
ParamRequestStateId.Value = Convert.ToInt32(requestUserDetailsDO.RequestStateId);
// SqlParameter ParamRequestCreatedDt = new SqlParameter("@RequestCreatedDt", SqlDbType.DateTime);
// ParamRequestCreatedDt.Value = Convert.ToDateTime(requestUserDetailsDO.RequestCreatedDt);
SqlParameter ParamRequestParams = new SqlParameter("@RequestParams", SqlDbType.NVarChar);
ParamRequestParams.Value = requestUserDetailsDO.RequestParams;
SqlParameter RequestIdOUT = new SqlParameter("@RequestId", SqlDbType.Int);
RequestIdOUT.Direction = ParameterDirection.Output;
// DbContext.Database.ExecuteSqlCommand
context.Database.ExecuteSqlCommand("[usp_SubmitRequest] @RequesterUserId, @RequesterFirstName, @RequesterLastName, @RequesterEmailId, @RequesterNTId, @ManagerUserId, @ManagerFirstName, @ManagerLastName, @ManagerEmailId, @ManagerNTId, @ApplicationId, @RequestStateId, @RequestParams, @RequestId OUTPUT",
ParamRequesterUserId,
ParamRequesterFirstName,
ParamRequesterLastName,
ParamRequesterEmailId,
ParamRequesterNTId,
ParamManagerUserId,
ParamManagerFirstName,
ParamManagerLastName,
ParamManagerEmailId,
ParamManagerNTId,
ParamApplicationId,
ParamRequestStateId,
ParamRequestParams,
RequestIdOUT
);
RequestId = (int)RequestIdOUT.Value;
}
// censusInfo = DbContext.Database.SqlQuery<CensusInfoDO>(DataAccess.str_SpGET_CENSUSDATA, ParamQuoteID, ParamUserId).FirstOrDefault();
}
catch (Exception ex)
{
throw;
}
return(RequestId);
}
