// GET: /Requisiton/RequisitionDetails
public ActionResult RequisitionDetails(string rid)
{
Requisition r = requisitionRepository.FindById(rid);
RequisitionDetailViewModel viewModel = new RequisitionDetailViewModel();
try
{
viewModel.Status = r.Status.Name;
viewModel.RequisitionID = r.RequisitionId;
try
{
viewModel.DisbursementId = r.Retrieval.Disbursements.Where(x => x.Department.DepartmentCode == r.Department.DepartmentCode).First().DisbursementId;
} catch {
viewModel.DisbursementId = "";
}
viewModel.Department = r.Department == null ? "" : r.Department.Name;
viewModel.CollectionPoint = r.CollectionPoint == null ? "" : r.CollectionPoint.Name;
viewModel.CreatedBy = r.CreatedBy == null ? "" : String.Format("{0} {1}", r.CreatedBy.FirstName, r.CreatedBy.LastName);
viewModel.CreatedTime = String.Format("{0} {1}", r.CreatedDateTime.ToShortDateString(), r.CreatedDateTime.ToShortTimeString());
viewModel.UpdatedBy = r.UpdatedBy == null ? "" : String.Format("{0} {1}", r.UpdatedBy.FirstName, r.UpdatedBy.LastName);
viewModel.UpdatedTime = r.UpdatedDateTime == null ? "" : String.Format("{0} {1}", r.UpdatedDateTime.Value.ToShortDateString(), r.UpdatedDateTime.Value.ToShortTimeString());
viewModel.ApprovedBy = r.ApprovedBy == null ? "" : String.Format("{0} {1}", r.ApprovedBy.FirstName, r.ApprovedBy.LastName);
viewModel.ApprovedTime = r.ApprovedDateTime == null ? "" : String.Format("{0} {1}", r.ApprovedDateTime.Value.ToShortDateString(), r.ApprovedDateTime.Value.ToShortTimeString());
viewModel.ApproverRemarks = r.HeadRemarks;
viewModel.RequesterRemarks = r.EmployeeRemarks;
}
catch
{
return(new HttpStatusCodeResult(400));
}
return(View(viewModel));
}
private RequisitionDetailViewModel GetRequisionInfo(int requisitionID, int fdpID)
{
var requisitionDetail = _reliefRequisitionDetailService.FindBy(m => m.RequisitionID == requisitionID && m.FDPID == fdpID).FirstOrDefault();
if (requisitionDetail != null)
{
var requisitonDetailInfo = new RequisitionDetailViewModel()
{
CommodityID = requisitionDetail.CommodityID,
CommodityName = requisitionDetail.Commodity.Name,
BeneficaryNumber = requisitionDetail.BenficiaryNo,
AllocatedAmount = requisitionDetail.Amount
};
return(requisitonDetailInfo);
}
return(null);
}
public List <RequisitionDetailViewModel> GetViewModelFromRequisitionRecord(Requisition_Record record)
{
List <RequisitionDetailViewModel> vmList = new List <RequisitionDetailViewModel>();
foreach (var item in record.Requisition_Detail)
{
RequisitionDetailViewModel vm = new RequisitionDetailViewModel();
vm.ItemCode = item.itemCode;
vm.RequestQty = (item.qty == null) ? 0 : (int)item.qty;
vm.RequisitionNo = record.requisitionNo;
vm.ReceivedQty = (item.fulfilledQty == null) ? 0 : (int)item.fulfilledQty;
vm.UOM = item.Stationery.unitOfMeasure;
vm.Description = item.Stationery.description;
vm.RequestDate = (DateTime)record.requestDate;
vmList.Add(vm);
}
return(vmList);
}
public RequisitionDetailViewModel GetRequisitionDetail(int id)
{
RequisitionDetailViewModel model = new RequisitionDetailViewModel();
using (SqlConnection con = new SqlConnection(connectionString))
{
String query = @"SELECT
[RequisitionID]
,[statusOfRequest]
,[DateofSubmission]
,[Comments]
,r.[DeptID_FK]
,r.[UserID_FK]
,d.[Departmentname]
,u.[Username]
FROM [RequisitionList] r
Inner join Department d on r.DeptID_FK = d.DepartmentID
Inner join Users u on r.UserID_FK = u.UserID
WHERE r.[RequisitionID] = " + id;
con.Open();
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
model.RequisitionID = reader[0] != DBNull.Value ? (int)reader[0] : 0;
model.statusOfRequest = reader[1] != DBNull.Value ? (string)reader[1] : "";
model.DateofSubmission = reader[2] != DBNull.Value ? (string)reader[2] : "";
model.Comments = reader[3] != DBNull.Value ? (string)reader[3] : "";
model.DeptID_FK = reader[4] != DBNull.Value ? (string)reader[4] : "";
model.UserID_FK = reader[5] != DBNull.Value ? (int)reader[5] : 0;
model.DepartmentName = reader[6] != DBNull.Value ? (string)reader[6] : "";
model.UserName = reader[7] != DBNull.Value ? (string)reader[7] : "";
}
con.Close();
con.Open();
query = @"SELECT [RequisitionDetailID]
,[RequisitionID]
,s.[ItemID]
,[RequisitionQuantity]
,s.ItemName
FROM [dbo].[RequisitionDetail] d
Inner join Stationery s on s.ItemID = d.ItemID
WHERE RequisitionID = " + id;
cmd = new SqlCommand(query, con);
DataTable dtl = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dtl);
foreach (DataRow row in dtl.Rows)
{
RequisitionDetailsWithItem reqDtl = new RequisitionDetailsWithItem();
reqDtl.RequisitionDetailID = row[0] != DBNull.Value ? (String)row[0] : "0";
reqDtl.RequisitionID = row[1] != DBNull.Value ? (int)row[1] : 0;
reqDtl.ItemID = row[2] != DBNull.Value ? (String)row[2] : "0";
reqDtl.RequisitionQuantity = row[3] != DBNull.Value ? (String)row[3] : "0";
reqDtl.ItemName = row[4] != DBNull.Value ? (String)row[4] : "0";
model.ReqDetails.Add(reqDtl);
}
con.Close();
}
return(model);
}
public ActionResult Detail(int id)
{
RequisitionDetailViewModel model = reqService.GetRequisitionDetail(id);
return(View(model));
}
