/// <summary>
/// Update the RequisitionCollectionItem data from the parameter
/// </summary>
/// <param name="requisitionCollectionItem"></param>
/// <returns>
/// Return DB_STATUS
/// </returns>
public Constants.DB_STATUS Update(RequisitionCollectionItem requisitionCollectionItem)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
requisitionCollectionItemObj = inventory.RequisitionCollectionItems.Where(r => r.Id == requisitionCollectionItem.Id).First();
if (!requisitionCollectionItemObj.Equals(null))
{
RequisitionCollection requisitionCollectionId = inventory.RequisitionCollections.Where(r => r.Id == requisitionCollectionItem.RequisitionCollection.Id).First();
Item item = inventory.Items.Where(i => i.Id == requisitionCollectionItem.Item.Id).First();
Employee createdBy = inventory.Employees.Where(e => e.Id == requisitionCollectionItem.CreatedBy.Id).First();
requisitionCollectionItemObj.Id = requisitionCollectionItem.Id;
requisitionCollectionItemObj.RequisitionCollection = requisitionCollectionId;
requisitionCollectionItemObj.Item = item;
requisitionCollectionItemObj.CreatedDate = requisitionCollectionItem.CreatedDate;
requisitionCollectionItemObj.CreatedBy = createdBy;
requisitionCollectionItemObj.Qty = requisitionCollectionItem.Qty;
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return(status);
}
public RequisitionCollectionItem GetRequisitionCollectionItem(RequisitionCollectionItem requisitionCollectionItem)
{
reqCollectionItem = inventory.RequisitionCollectionItems.Where(r => r.Id == requisitionCollectionItem.Id).First();
if (!reqCollectionItem.Equals(null))
{
Item item = inventory.Items.Where(i => i.Id == reqCollectionItem.Item.Id).First();
// int i=Convert.ToInt32(inventory.Items.Last().Id) + 1;
reqCollectionItem.Item = item;
return(reqCollectionItem);
}
return(null);
}
/// <summary>
/// Insert RequisitionCollectionItem data from the parameter
/// </summary>
/// <param name="newRequisitionCollectionItem"></param>
/// <returns>
/// DB_STATUS
/// </returns>
public Constants.DB_STATUS Insert(RequisitionCollectionItem newRequisitionCollectionItem)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
inventory.AddToRequisitionCollectionItems(newRequisitionCollectionItem);
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return(status);
}
/// <summary>
/// Logically delete to the status of RequisitionCollectionItem table
/// </summary>
/// <param name="requisitionCollectionItem"></param>
/// Returns the DB_STATUS
/// </returns>
public Constants.DB_STATUS Delete(RequisitionCollectionItem requisitionCollectionItem)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
requisitionCollectionItemObj = inventory.RequisitionCollectionItems.Where(r => r.Id == requisitionCollectionItem.Id).First();
requisitionCollectionItemObj.Status = 2;
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return(status);
}
/// <summary>
/// Get the RequisitionCollectionItem from the RequisitionCollectionItem table
/// </summary>
/// <param name="requisitionCollectionItem"></param>
/// <returns>
/// Returns RequisitionCollectionItem
/// </returns>
public RequisitionCollectionItem GetRequisitionCollectionItem(RequisitionCollectionItem requisitionCollectionItem)
{
try
{
requisitionCollectionItemObj = inventory.RequisitionCollectionItems.Where(r => r.Id == requisitionCollectionItem.Id).First();
if (!requisitionCollectionItemObj.Equals(null))
{
Item item = inventory.Items.Where(i => i.Id == requisitionCollectionItemObj.Item.Id).First();
// int i=Convert.ToInt32(inventory.Items.Last().Id) + 1;
requisitionCollectionItemObj.Item = item;
}
}
catch (Exception e)
{
requisitionCollectionItemObj = null;
}
return(requisitionCollectionItemObj);
}
public Constants.DB_STATUS Update(RequisitionCollectionItem requisitionCollectionItem)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
reqCollectionItem = inventory.RequisitionCollectionItems.Where(r => r.Id == requisitionCollectionItem.Id).First();
reqCollectionItem.RequisitionCollection = requisitionCollectionItem.RequisitionCollection;
reqCollectionItem.Item = requisitionCollectionItem.Item;
reqCollectionItem.CreatedDate = requisitionCollectionItem.CreatedDate;
reqCollectionItem.CreatedBy = requisitionCollectionItem.CreatedBy;
reqCollectionItem.Qty = requisitionCollectionItem.Qty;
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return(status);
}
public Constants.ACTION_STATUS UpdateRequisitionCollection(Dictionary <string, int> itemsCollected)
{
Constants.ACTION_STATUS updateStatus = Constants.ACTION_STATUS.UNKNOWN;
int addedItem = 0;
foreach (string key in itemsCollected.Keys)
{
if (requisitionCollection.RequisitionCollectionItems.Where(x => x.Item.Id == key).Count() > 0)
{
RequisitionCollectionItem requisitionCollectionItem = requisitionCollection.RequisitionCollectionItems.Where(x => x.Item.Id == key).First();
requisitionCollectionItem.Qty = itemsCollected[key];
}
else
{
Item item = new Item();
item.Id = key;
item = itemBroker.GetItem(item);
Employee employee = new Employee();
employee.Id = currentEmployee.Id;
employee = employeeBroker.GetEmployee(employee);
requisitionCollection.RequisitionCollectionItems.Add(new RequisitionCollectionItem(requisitionCollectionItemBroker.GetRequisitionCollectionItemId() + (addedItem++), requisitionCollection, item, itemsCollected[key], DateTime.Now, employee, Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW)));
}
}
if (requisitionCollectionBroker.Update(requisitionCollection) == Constants.DB_STATUS.SUCCESSFULL)
{
updateStatus = Constants.ACTION_STATUS.SUCCESS;
}
else
{
updateStatus = Constants.ACTION_STATUS.FAIL;
}
return(updateStatus);
}
