public bool updateStock(int disID)
{
List <DiscrepancyDetail> ldd = this.getDiscrepancyDetailByID(disID);
for (int i = 0; i < ldd.Count(); i++)
{
DiscrepancyDetail dd = ldd[i];
string _itemcode = dd.ItemCode;
int _quantity = (int)dd.Quantity;
bool _isadded = (bool)dd.IsAdded;
var x = from y in ent.Stocks
where y.ItemCode == _itemcode
select y;
Stock s = x.First <Stock>();
if (_isadded)
{
s.AvailableQty = s.AvailableQty + _quantity;
}
else
{
s.AvailableQty = s.AvailableQty - _quantity;
}
try
{
ent.SaveChanges();
}
catch (Exception ex)
{
return(false);
}
}
return(true);
}
/// <summary>
/// Show the added item in the table
/// Created By:JinChengCheng
/// Created Date:26-01-2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
/// <param name="discrepancyDetail"></param>
/// <returns>The return type of this method is datatable.</returns>
public Constants.ACTION_STATUS SelectAdd(string itemId, int qty, string reason)
{
Item item = new Item();
item.Id = itemId;
item = itemBroker.GetItem(item);
if (item != null && reason != String.Empty)
{
DiscrepancyDetail dd = new DiscrepancyDetail();
//dd.Discrepancy = discrepancy;
dd.Item = item;
int amount = qty * (int)item.Cost;
if (amount >= 250)
{
dd.DiscrepancyType = Converter.objToInt(Constants.DISCREPANCY_TYPE.MANAGER);
}
else
{
dd.DiscrepancyType = Converter.objToInt(Constants.DISCREPANCY_TYPE.SUPERVISOR);
}
dd.Qty = qty;
dd.Remarks = reason;
dd.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW);
discrepancy.DiscrepancyDetails.Add(dd);
}
return(Constants.ACTION_STATUS.SUCCESS);
}
public bool addDiscrepancyDetail(iDiscrepancyDetail idisd)
{
ReportDescrepancyController rd = new ReportDescrepancyController();
DiscrepancyDetail disd = new DiscrepancyDetail();
disd = changeiDisdtoDisdEntity(idisd);
return(rd.insertDiscrepancyDetail(disd));
}
public DiscrepancyDetail GetDiscrepancyDetail(DiscrepancyDetail discrepancyDetail)
{
discrepancyDetailObj = inventory.DiscrepancyDetails.Where(disDetailObj => disDetailObj.Id == discrepancyDetail.Id).First();
if (!discrepancyDetailObj.Equals(null))
{
return(discrepancyDetailObj);
}
return(null);
}
public bool insertDiscrepancyDetail(DiscrepancyDetail dd)
{
DiscrepancyDetail ddt = dd;
context.AddToDiscrepancyDetails(ddt);
try
{
context.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public Constants.DB_STATUS Delete(DiscrepancyDetail discrepancyDetail)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return(status);
}
public DiscrepancyDetail changeiDisdtoDisdEntity(iDiscrepancyDetail idisd)
{
DiscrepancyDetail disd = new DiscrepancyDetail();
ReportDescrepancyController rd = new ReportDescrepancyController();
disd.DiscrepancyID = rd.getDiscrepancyID();
disd.ItemCode = idisd.ItemCode;
if (idisd.Quantity < 0)
{
disd.Quantity = -1 * idisd.Quantity;
}
else
{
disd.Quantity = idisd.Quantity;
}
disd.Amount = float.Parse(idisd.Amount);
disd.IsAdded = bool.Parse(idisd.IsAdded);
disd.Reason = idisd.Reason;
disd.DeletedFlag = false;
return(disd);
}
public Constants.DB_STATUS Insert(DiscrepancyDetail discrepancyDetail)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
//disDetail = inventory.DiscrepancyDetails.Where(disDetailObj => disDetailObj.Id == discrepancyDetail.Id).FirstOrDefault();
//disDetail.ItemReference = discrepancyDetail.ItemReference;
// disDetail.Qty = discrepancyDetail.Qty;
// disDetail.Remarks = discrepancyDetail.Remarks;
try
{
inventory.AddToDiscrepancyDetails(discrepancyDetail);
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return(status);
}
public Constants.DB_STATUS Update(DiscrepancyDetail discrepancyDetail)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
discrepancyDetailObj = inventory.DiscrepancyDetails.Where(disDetailObj => disDetailObj.Id == discrepancyDetail.Id).First();
Discrepancy disId = inventory.Discrepancies.Where(d => d.Id == discrepancyDetail.Discrepancy.Id).First();
Item item = inventory.Items.Where(i => i.Id == discrepancyDetail.Item.Id).First();
discrepancyDetailObj.Qty = discrepancyDetail.Qty;
discrepancyDetailObj.Discrepancy = disId;
discrepancyDetailObj.Item = item;
discrepancyDetailObj.DiscrepancyType = discrepancyDetail.DiscrepancyType;
discrepancyDetailObj.Qty = discrepancyDetail.Qty;
discrepancyDetailObj.Remarks = discrepancyDetail.Remarks;
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return(status);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
/** get employee name **/
MembershipUser user = Membership.GetUser();
String userName = user.UserName;
String empID = rdControl.getEmployeeID(userName);
double totalAmount = calculateTotalAmount();
/** create discrepancy **/
Discrepancy addDiscrepancy = new Discrepancy();
addDiscrepancy.DateRaised = DateTime.Now;
addDiscrepancy.DateUpdated = DateTime.Now;
addDiscrepancy.DiscrepancyStatus = "Pending Approval";
addDiscrepancy.DeletedFlag = false;
addDiscrepancy.ApprovedBy = null;
addDiscrepancy.Comment = null;
addDiscrepancy.RaisedBy = empID;
addDiscrepancy.TotalAmount = totalAmount;
if (rdControl.insertDiscrepancy(addDiscrepancy))
{
int discrepancyID = rdControl.getDiscrepancyID();
/** create discrepancy details **/
foreach (GridViewRow row in discrepancyGrid.Rows)
{
DiscrepancyDetail addDiscrepancyDetail = new DiscrepancyDetail();
addDiscrepancyDetail.DiscrepancyID = discrepancyID;
addDiscrepancyDetail.ItemCode = row.Cells[0].Text;
TextBox txtQtyAdjusted = (TextBox)row.FindControl("txtQtyAdjusted");
addDiscrepancyDetail.Quantity = Convert.ToInt32(txtQtyAdjusted.Text);
Label lblAmount = (Label)row.FindControl("lblAmount");
addDiscrepancyDetail.Amount = Convert.ToDouble(lblAmount.Text);
TextBox txtReason = (TextBox)row.FindControl("txtReason");
addDiscrepancyDetail.Reason = txtReason.Text;
CheckBox chkDeduct = (CheckBox)row.FindControl("chkDeduct");
if (chkDeduct.Checked)
{
addDiscrepancyDetail.IsAdded = false;
}
else
{
addDiscrepancyDetail.IsAdded = true;
}
addDiscrepancyDetail.DeletedFlag = false;
if (rdControl.insertDiscrepancyDetail(addDiscrepancyDetail))
{
lblStatus.ForeColor = System.Drawing.Color.Green;
lblStatus.Text = "Successfully submitted the request";
}
else
{
lblStatus.ForeColor = System.Drawing.Color.Red;
lblStatus.Text = "Could not submit the request";
}
}
}
else
{
lblStatus.ForeColor = System.Drawing.Color.Red;
lblStatus.Text = "Could not submit the request";
}
}
