/** Get first record in item wise list **/
public StationeryRetrievalDetail getFirstItem(int retrievalID)
{
var q = from rd in context.StationeryRetrievalDetails
where (rd.RetrievalID == retrievalID)
orderby rd.ItemCode ascending
select rd;
StationeryRetrievalDetail sd = (StationeryRetrievalDetail)q.FirstOrDefault();
return(sd);
}
/** Get stationery retrieval details **/
public void displayStationeryRetrieval(StationeryRetrieval sr)
{
lblDBRetrievalID.Text = sr.RetrievalID.ToString();
lblDBDate.Text = sr.DateRetrieved.Value.ToString("dd/MM/yyyy");
/** Get the item wise list **/
StationeryRetrievalGrid.DataSource = srControl.getItemWiseList(sr.RetrievalID);
StationeryRetrievalGrid.DataBind();
/** Display first record in Department wise list **/
StationeryRetrievalDetail sd = srControl.getFirstItem(sr.RetrievalID);
lblDBItemNo.Text = sd.ItemCode;
lblDBDescription.Text = sd.Stock.ItemDescription;
DepartmentWiseDetailsGrid.DataSource = srControl.getDepartmentWiseList(sr.RetrievalID, sd.ItemCode);
DepartmentWiseDetailsGrid.DataBind();
}
/** Create Stationery Retrieval Detail **/
public void createItemWiseList(List <RequestDetail> rdList, ArrayList itemList, int RetrievalID)
{
String itemCode;
int itemCount;
int availableQty;
foreach (var i in itemList)
{
itemCode = i.ToString();
itemCount = 0;
availableQty = 0;
try
{
foreach (RequestDetail r in rdList)
{
if (itemCode == r.ItemCode)
{
itemCount += Convert.ToInt32(r.Quantity);
availableQty = Convert.ToInt32(r.Stock.AvailableQty);
}
}
/**create new stationery retrieval detail**/
StationeryRetrievalDetail addStationeryRetrievalDetail = new StationeryRetrievalDetail();
addStationeryRetrievalDetail.RetrievalID = RetrievalID;
addStationeryRetrievalDetail.ItemCode = itemCode;
addStationeryRetrievalDetail.RequestedQty = itemCount;
addStationeryRetrievalDetail.AvailableQty = availableQty;
addStationeryRetrievalDetail.DeletedFlag = false;
context.AddToStationeryRetrievalDetails(addStationeryRetrievalDetail);
context.SaveChanges();
updateStock(itemCode, itemCount);
}
catch (Exception ex)
{
errorState = true;
errorMsg = "Failed to generate Stationery Retrieval Form";
throw new Exception_Package.CreateFailedException(errorMsg);
}
}
}
