public SupplyOrderFollowUpList GetSupplyOrderFollowup(int OrganizationId, string name, string SupplierName, int?batch)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
SupplyOrderFollowUpList model = new SupplyOrderFollowUpList();
string query = @"
SELECT distinct SI.SupplyOrderItemId,I.ItemName,case when I.CriticalItem = 1 then 'Critical' else '-' end CriticalItem,
SI.OrderedQty,Su.SupplierName,convert(varchar,SF.ExpectedDate,106) ExpectedDate,S.RequiredDate,SF.Remarks,I.BatchRequired,
CONCAT(S.SupplyOrderNo, ' - ' , ISNULL(CONVERT(VARCHAR(15),SupplyOrderDate,106), '')) SupplyOrderDate
from SupplyOrder S inner join Supplier Su on Su.SupplierId=S.SupplierId
inner join SupplyOrderItem SI on S.SupplyOrderId=SI.SupplyOrderId
inner join PurchaseRequestItem PI on PI.PurchaseRequestItemId=SI.PurchaseRequestItemId
inner join Item I on PI.ItemId=I.ItemId
left join SupplyOrderFollowup SF on SF.SupplyOrderItemId=SI.SupplyOrderItemId
left join GRNItem GI ON GI.SupplyOrderItemId=SI.SupplyOrderItemId where S.OrganizationId=@OrganizationId and ItemName LIKE '%'+@name+'%'
and SupplierName Like '%'+@SupplierName+'%' and BatchRequired = ISNULL(@batch,BatchRequired)
AND ISNULL(S.isApproved, 0) = 1 AND GI.SupplyOrderItemId is null" ;
// model.SupplyOrderFollowups = connection.Query<SupplyOrderFollowup>(query).ToList<SupplyOrderFollowup>();
model.SupplyOrderFollowups = connection.Query <SupplyOrderFollowup>(query, new
{
OrganizationId = OrganizationId,
name = name,
SupplierName = SupplierName,
batch = batch
}).ToList <SupplyOrderFollowup>();
return(model);
}
}
//public ActionResult Pending()
//{
// SupplyOrderFollowupRepository repo = new SupplyOrderFollowupRepository();
// var model = repo.GetSupplyOrderFollowup(OrganizationId);
// return View(model);
//}
// [HttpPost]
public ActionResult Save(SupplyOrderFollowUpList model)
{
foreach (SupplyOrderFollowup item in model.SupplyOrderFollowups)
{
if (item.ExpectedDate == DateTime.MinValue)
{
continue;
}
item.CreatedDate = System.DateTime.Now;
item.CreatedBy = UserID.ToString();
item.OrganizationId = OrganizationId;
item.SupplyOrderFollowupDate = System.DateTime.Now;
}
var rtn = new SupplyOrderFollowupRepository().InsertSupplyOrderFollowup(model.SupplyOrderFollowups);
TempData["Success"] = "Added Successfully!";
return(RedirectToAction("Index"));
}
