public ICollection <RequestDTO> GetAllRequestsByStatusfromDB(int status)
{
ICollection <RequestDTO> outputList = default(ICollection <RequestDTO>);
try
{
// 1- Select All Groups From DB
RequestBusiness _RequestBusiness = new RequestBusiness();
//RequestList _RequestList = _RequestBusiness.SelectRows(null, null, null, null, null, null, null, null,
// null, null, null, null, null, null, null, null);
RequestList _RequestList = _RequestBusiness.SelectRows(null, null, null, null, null, null, null, null, null,
null, null, null, null, status, null, null);
if (_RequestList != null && _RequestList.Count > 0)
//outputList = Mapper.MapUserAsOutput();
{
// 2- Prepare Mapping Obects (Fill Values from DB)
//if(Mapper._RequestTypeList == default(List<RequestType>)) ==> In case we try to save DB hits (we apply that check for all lists)
//Mapper._RequestTypeList = fillRequestTypeList();
Mapper._RequestList = _RequestList;
Mapper._RequestDetailList = fillRequestDetailListbyRequestStatus(Mapper._RequestList);
Mapper._RequestTypeList = fillRequestTypeList();
Mapper._RequestStatusList = fillRequestStatusList();
Mapper._RequestClassList = fillRequestClassList();
Mapper._RequestPriorityList = fillRequestPriorityList();
Mapper._RejectReasonList = fillRejectReasonList();
Mapper._CardTypeList = fillCardTypeList();
Mapper._CardValidityList = fillCardValidityList();
Mapper._WorkFieldList = fillWorkFieldList();
Mapper._CustomerList = fillCustomerList();
Mapper._UserList = fillUserList();
//UserGroupBusiness _UserGroupBusiness = new UserGroupBusiness();
//UserGroupList _UserGroupList = default(UserGroupList);
//foreach (User _User in _UserList)
//{
// _UserGroupList = _UserGroupBusiness.SelectRows(null, _User.Id, null);
// if (_UserGroupList != null && _UserGroupList.Count > 0)
// foreach (UserGroup _UserGroup in _UserGroupList)
// Mapper._UserGroupList.Add(Copier.copyUserGroup(_UserGroup));
//}
// 3- Perform Mapping to Output
outputList = Mapper.MapRequestAsOutput();
}
}
catch (Exception ex)
{
// Log Exception Here
throw; //new Exception(ex.Message);
}
return(outputList);
}
public StudentController()
{
RSMEntities db = new RSMEntities();
slFactory = new SelectListFactory(db);
ClassBO = new ClassBusiness(db);
StuBO = new StudentBusiness(db);
AccBO = new AccountBusiness(db);
RollBO = new RollCallBusiness(db);
ReBO = new RequestBusiness(db);
}
public AdminController()
{
RSMEntities db = new RSMEntities();
StuBO = new StudentBusiness(db);
ClaBO = new ClassBusiness(db);
ReBO = new RequestBusiness(db);
SlFactory = new SelectListFactory(db);
StaffBO = new StaffBusiness(db);
AccBO = new AccountBusiness(db);
StuImBO = new StudentImageBusiness(db);
}
private void RefreshRequests()
{
_reqBLL = new RequestBusiness(_user);
dgvRequests.DataSource = null;
try
{
dgvRequests.DataSource = _reqBLL.GetAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public Request[] GetAll()
{
try
{
using (var c = new RequestBusiness())
{
return(c.GetAll().ToArray());
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(null);
}
}
public bool Delete(Request request)
{
try
{
using (var u = new RequestBusiness())
{
return(u.Delete(request));
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(false);
}
}
public bool Insert(Request request)
{
try
{
using (var u = new RequestBusiness())
{
u.Insert(request);
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(false);
}
}
public List <RequestDTO> SearchRequestinDB(RequestSearchDTO requestSearchDTO)
{
ICollection <RequestDTO> outputList = default(ICollection <RequestDTO>);
try
{
// 1- Perform Mapping to Input (for Saving in DB)
if (Mapper.MapRequestSearchAsInput(requestSearchDTO))
{
RequestBusiness requestBusiness = new RequestBusiness();
RequestList _RequestList = requestBusiness.SelectRequestDynamicSearch(Mapper._RequestSearch);
if (_RequestList != null && _RequestList.Count > 0)
//outputList = Mapper.MapUserAsOutput();
{
// 2- Prepare Mapping Objects (Fill Values from DB)
Mapper._RequestList = _RequestList;
Mapper._RequestDetailList = fillRequestDetailList();
Mapper._RequestTypeList = fillRequestTypeList();
Mapper._RequestStatusList = fillRequestStatusList();
Mapper._RequestClassList = fillRequestClassList();
Mapper._RequestPriorityList = fillRequestPriorityList();
Mapper._RejectReasonList = fillRejectReasonList();
Mapper._CardTypeList = fillCardTypeList();
Mapper._CardValidityList = fillCardValidityList();
Mapper._WorkFieldList = fillWorkFieldList();
Mapper._CustomerList = fillCustomerList();
Mapper._UserList = fillUserList();
// 3- Perform Mapping to Output
outputList = Mapper.MapRequestAsOutput();
}
}
else
{
throw new ArgumentNullException("requestSearchDTO");
}
}
catch (Exception)
{
throw;
}
return(outputList.ToList());
}
public IHttpActionResult Delete([FromBody] Request request)
{
try
{
using (var c = new RequestBusiness())
{
if (c.Delete(request))
{
return(Ok());
}
return(NotFound());
}
}
catch (Exception ex)
{
return(BadRequest($"{ex}"));
}
}
public BaseAPIController() : base()
{
lgBus = new LoginBusiness(this.GetContext());
newsBus = new NewsBusiness(this.GetContext());
notiBus = new NotifyBusiness(this.GetContext());
giftBus = new GiftBusiness(this.GetContext());
rqBus = new RequestBusiness(this.GetContext());
cusBus = new CustomerBusiness(this.GetContext());
mBus = new MessageBusiness(this.GetContext());
apiBus = new RequestAPIBusiness(this.GetContext());
pBus = new PointBusiness(this.GetContext());
statisticBus = new StatisticBusiness(this.GetContext());
shopBus = new ShopBusiness(this.GetContext());
itemBus = new ItemBusiness(this.GetContext());
orderBus = new OrderBusiness(this.GetContext());
packBus = new PackageBusiness(this.GetContext());
vnPay = new VNPay(this.GetContext());
}
public IHttpActionResult Get(int id)
{
try
{
using (var c = new RequestBusiness())
{
var temp = c.GetAll().Where(s => s.Id == id).FirstOrDefault();
if (temp == null)
{
return(NotFound());
}
return(Ok(temp));
}
}
catch (Exception ex)
{
return(BadRequest($"{ex}"));
}
}
public IHttpActionResult Get()
{
try
{
using (var c = new RequestBusiness())
{
var templist = c.GetAll().ToList();
if (templist == null)
{
return(NotFound());
}
return(Ok(templist));
}
}
catch (Exception ex)
{
return(BadRequest($"{ex}"));
}
}
private void btnSave_Click(object sender, EventArgs e)
{
_reqBLL = new RequestBusiness(_user);
_req.ProjectID = _projectId;
_req.Description = txtDescription.Text;
_req.RecievedDate = dtpRecievedDate.Value;
_req.RequestTypeID = (int)cmbRequestType.SelectedValue;
bool result = false;
try
{
result = _reqBLL.Add(_req);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
MessageBox.Show((result) ? "İstek eklendi." : "İstek eklenemedi.");
}
public BaseController() : base()
{
loginBusiness = new LoginBusiness(this.GetContext());
batchBusiness = new BatchBusiness(this.GetContext());
cardBusiness = new CardBusiness(this.GetContext());
requestBusiness = new RequestBusiness(this.GetContext());
newsBusiness = new NewsBusiness(this.GetContext());
cusBusiness = new CustomerBusiness(this.GetContext());
rankBusiness = new RankBusiness(this.GetContext());
configBusiness = new ConfigBusiness(this.GetContext());
pointBusiness = new PointBusiness(this.GetContext());
warrantyBusiness = new WarrantyBusiness(this.GetContext());
statisticBus = new StatisticBusiness(this.GetContext());
orderBus = new OrderBusiness(this.GetContext());
userBusiness = new UserBusiness(this.GetContext());
itemBusiness = new ItemBusiness(this.GetContext());
productsBusiness = new ItemBusiness(this.GetContext());
notifyBusiness = new NotifyBusiness(this.GetContext());
shopBusiness = new ShopBusiness(this.GetContext());
agentBusiness = new AgentBusiness(this.GetContext());
vnpay = new VNPay(this.GetContext());
}
private void btnFilter_Click(object sender, EventArgs e)
{
string input = txtRequestInput.Text;
if (input != null)
{
_reqBLL = new RequestBusiness(_user);
dgvRequests.DataSource = null;
try
{
dgvRequests.DataSource = _reqBLL.GetAllFiltered(input);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
RefreshRequests();
}
}
private void cmiDeleteRequest_Click(object sender, EventArgs e)
{
if (dgvRequests.SelectedRows.Count > 0)
{
bool isDeleted = false;
int projectId = (int)dgvRequests.Rows[0].Cells["ProjectID"].Value;
DialogResult result = MessageBox.Show("Bu isteği silmek istediğinizden emin misiniz?", "Dikkat", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
_reqBLL = new RequestBusiness(_user);
Request deleteRequest = _reqBLL.Get(projectId);
try
{
_reqBLL.Remove(deleteRequest);
isDeleted = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
MessageBox.Show(isDeleted ? "Seçilen istek silindi." : "Seçilen istek silinemedi.");
}
}
}
public ImageController()
{
ReBO = new RequestBusiness();
StuImaBO = new StudentImageBusiness();
}
public RequestDTO UpdateRequestinDB(RequestDTO requestDTO)
{
BaseDataAccess _db = new BaseDataAccess();
using (DbTransaction dbTransaction = _db.CreateTransaction())
{
try
{
// 1- Perform Mapping to Input (for Saving in DB)
if (Mapper.MapRequestAsInput(requestDTO))
{
// 2- Select Request to be updated
RequestBusiness requestBusiness = new RequestBusiness();
RequestList requestList = requestBusiness.SelectRows(Mapper._Request.Id, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null);
if (requestList != null && requestList.Count > 0)
{
requestList[0].requestNumber = Mapper._Request.requestNumber;
requestList[0].totalQuantity = Mapper._Request.totalQuantity;
requestList[0].PDD = Mapper._Request.PDD;
requestList[0].customerID = Mapper._Request.customerID;
requestList[0].creationDate = Mapper._Request.creationDate;
requestList[0].creationUserID = Mapper._Request.creationUserID;
requestList[0].approvalDate = Mapper._Request.approvalDate;
requestList[0].approvalUserID = Mapper._Request.approvalUserID;
requestList[0].receiveDate = Mapper._Request.receiveDate;
requestList[0].receiveUserID = Mapper._Request.receiveUserID;
requestList[0].rejectionDate = Mapper._Request.rejectionDate;
requestList[0].rejectionUserID = Mapper._Request.rejectionUserID;
requestList[0].rejectionReasonID = Mapper._Request.rejectionReasonID;
requestList[0].requestTypeID = Mapper._Request.requestTypeID;
requestList[0].requestStatusID = Mapper._Request.requestStatusID;
requestList[0].requestCalssID = Mapper._Request.requestCalssID;
requestList[0].requestPriorityID = Mapper._Request.requestPriorityID;
// 3- Update Request Data by Input Values
requestBusiness = new RequestBusiness();
if (requestBusiness.UpdateRow(dbTransaction, requestList[0]) > 0)
{
// 4- Remove Request Details Already Saved for that Request in DB
RequestDetailBusiness requestDetailBusiness = new RequestDetailBusiness();
RequestDetailList requestDetailList = requestDetailBusiness.SelectRows(null, null, Mapper._Request.Id);
if (requestDetailList != null && requestDetailList.Count > 0)
{
foreach (RequestDetail requestDetail in requestDetailList)
{
requestDetailBusiness = new RequestDetailBusiness();
requestDetailBusiness.DeleteRow(dbTransaction, requestDetail);
}
}
// 5- Add New Request Details from Input
if (Mapper._RequestDetailListInput != null && Mapper._RequestDetailListInput.Count > 0)
{
foreach (RequestDetail requestDetail in Mapper._RequestDetailListInput)
{
requestDetailBusiness = new RequestDetailBusiness();
requestDetailBusiness.InsertRow(dbTransaction, requestDetail);
}
dbTransaction.Commit();
}
}
else
{
dbTransaction.Rollback();
throw new Exception("DataBase Operation Failure");
}
}
else
{
throw new Exception("Request Id Not Found in DB");
}
}
else
{
throw new ArgumentNullException("requestDTO");
}
}
catch (Exception ex)
{
dbTransaction.Rollback();
throw new Exception("DataBase Operation Failure");
}
}
return(requestDTO);
}
/// <summary>Faz a publicação de uma determinada requisição</sumary>
public ObjResult Send(int request_id, int user_id, string action, Message msg)
{
connection = db.GetCon();
connection.Open();
Request request = new Request();
ObjResult result = new ObjResult();
List <string> messages_list = new List <string>();
RequestDao requestDao = new RequestDao(connection, null);
RequestBusiness business = new RequestBusiness(connection, null);
try
{
// Validar requisição
request = requestDao.GetById(request_id);
Console.WriteLine("Status da requisição: " + request.req_status);
messages_list = business.Validate(request, user_id, action);
if (messages_list.Count > 0)
{
result.resultStatus = "error";
result.resultMessages = messages_list;
connection.Close();
return(result);
}
}
finally
{
connection.Close();
}
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
RequestItemDao itemDao = new RequestItemDao(connection, transaction);
MessageDao messageDao = new MessageDao(connection, transaction);
RequestDao r_dao = new RequestDao(connection, transaction);
try
{
// Altera o status da requisição para ativa
request_id = r_dao.ChangeStatus(request_id, 'A');
// Altera o status de todos os itens para <AAT> Aguardando Aprovação Técnica
foreach (RequestItem item in itemDao.GetItemsByRequest(request_id))
{
itemDao.SetStatus(item.itm_id, "AAT");
}
// Envia mensagem e informa que foi gerada por meio de uma requisição de compra
msg.SetSourceKey(request_id);
msg.SetSourceType("request");
messageDao.Post(msg);
// Adiciona o status de sucesso e data
result.Success();
result.SetData(request_id);
// Comita as alterações
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.ToString());
}
finally
{
connection.Close();
}
return(result);
}
public RequestDTO AddRequesttoDB(RequestDTO requestDTO)
{
BaseDataAccess _db = new BaseDataAccess();
using (DbTransaction dbTransaction = _db.CreateTransaction())
{
try
{
// 1- Perform Mapping to Input (for Saving in DB)
if (Mapper.MapRequestAsInput(requestDTO))
{
////User user = Mapper._User;
////List<UserGroup> userGroups = Mapper._UserGroupListInput;
//Mapper._User.createDate = DateTime.Now;
Mapper._Request.creationDate = DateTime.Now;
// 2- Insert Request in DB
RequestBusiness requestBusiness = new RequestBusiness();
if (requestBusiness.InsertRow(dbTransaction, Mapper._Request) > 0)
{
requestDTO.Id = Mapper._Request.Id;
if (Mapper._RequestDetailListInput != null && Mapper._RequestDetailListInput.Count > 0)
{
RequestDetailBusiness requestDetailBusiness = new RequestDetailBusiness();
// 3- Insert Group Functions in DB
foreach (RequestDetail requestDetail in Mapper._RequestDetailListInput)
{
requestDetail.requestID = Mapper._Request.Id;
requestDetailBusiness = new RequestDetailBusiness();
requestDetailBusiness.InsertRow(dbTransaction, requestDetail);
}
dbTransaction.Commit();
}
else
{
dbTransaction.Rollback();
}
}
else
{
throw new Exception("DataBase Operation Failure");
}
}
else
{
throw new ArgumentNullException("requestDTO");
}
}
catch (Exception ex)
{
dbTransaction.Rollback();
throw;
}
}
return(requestDTO);
}
/// <summary>
/// Reabre uma determinada requisição
/// </summary>
/// <param name="request_id">É o id da requisição</param>
/// <param name="user_id">É o id do usuário que está solicitando a reabertura da requisição</param>
/// <param name="action">É o tipo de ação que está sendo feita pelo usuário</param>
/// <returns></returns>
public ObjResult ReopenRequest(int request_id, int user_id, string action)
{
connection = db.GetCon();
connection.Open();
ObjResult result = new ObjResult();
List <string> messages_list = new List <string>();
Request request = new Request();
RequestDao dao = new RequestDao(connection, null);
RequestBusiness business = new RequestBusiness(connection, null);
RequestItemDao item_dao = new RequestItemDao(connection, null);
// Fazer a validação primeiro da requisição, se pode ser revertida, se o usuário tem autorização para realizar essa ação etc.
try
{
request = dao.GetById(request_id);
messages_list = business.Validate(request, user_id, action);
if (messages_list.Count > 0)
{
result.resultStatus = "error";
result.resultMessages = messages_list;
connection.Close();
return(result);
}
}
finally
{
connection.Close();
}
// Agora vem a ação de reabrir a requisição
// Obs.: As transações são feitas separadamente para cada serviço chamado.
try
{
// Excluir as mensagens que estiverem associadas à requisição
MessageService msg_service = new MessageService();
List <Message> messages = new List <Message>();
messages = msg_service.GetMessagesBySourceKey(request_id);
if (messages.Count != 0)
{
foreach (Message msg in messages)
{
msg_service.DeleteMessage(msg.msg_id);
}
}
// Alterar o status de todos os itens da requisição para 1 <ED>
foreach (RequestItem item in item_dao.GetItemsByRequest(request_id))
{
item_dao.SetStatus(item.itm_id, "ED");
}
// Altera o status da requisição para 'E' (Em digitação).
request_id = ChangeStatus(request_id, 'E');
result.resultStatus = "success";
result.data = request_id;
}
catch (Exception e)
{
throw new Exception(e.ToString());
}
return(result);
}
