public void UpdateStatus(RequestStatusDTO rsDTO)
{
sqlConnection.Open();
string sqlQuery = "UPDATE RequestStatus SET Status='" + rsDTO.STATUS +
"' where RNo=" + rsDTO.RID;
sqlCommand = new SqlCommand(sqlQuery, sqlConnection);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
public string getEmail(RequestStatusDTO rsDTO)
{
sqlConnection.Open();
string sqlQuery = "select Email from RequestStatus where RNo=" + rsDTO.RID;
sqlCommand = new SqlCommand(sqlQuery, sqlConnection);
sqlCommand.ExecuteNonQuery();
string tempName = sqlCommand.ExecuteScalar().ToString();
sqlConnection.Close();
return(tempName);
}
private static RequestStatusDTO fillRequestStatusDTObyRequestStatusID(int?requestStatusID)
{
RequestStatusDTO _RequestStatusDTO = default(RequestStatusDTO);
RequestStatus _RequestStatus = _RequestStatusList.FirstOrDefault(i => i.Id == requestStatusID.Value);
if (_RequestStatus != default(RequestStatus))
{
_RequestStatusDTO = new RequestStatusDTO();
_RequestStatusDTO.Id = _RequestStatus.Id;
_RequestStatusDTO.name = _RequestStatus.name;
_RequestStatusDTO.nameAr = _RequestStatus.nameAr;
}
return(_RequestStatusDTO);
}
public List <RequestStatusDTO> GetStatus(string id)
{
MyRequestRepository myRequestRepo = new MyRequestRepository();
List <RequestStatusDO> requestStatusListDO = myRequestRepo.GetStatus(id);
List <RequestStatusDTO> requestStatusListDTO = new List <RequestStatusDTO>();
foreach (RequestStatusDO requestStatusDO in requestStatusListDO)
{
RequestStatusDTO requestStatusDTO = new RequestStatusDTO();
requestStatusDTO.RequestId = requestStatusDO.RequestId;
requestStatusDTO.TransactionDate = Convert.ToString(requestStatusDO.TransactionDate);
requestStatusDTO.RequestStatusName = requestStatusDO.RequestStatusName;
requestStatusDTO.RequestStateId = requestStatusDO.RequestStateId;
requestStatusDTO.Comment = requestStatusDO.Comment;
requestStatusListDTO.Add(requestStatusDTO);
}
return(requestStatusListDTO);
}
