public static bool UpdateDetailedSingleEntry(AdjustInventoryDetailed aAdjustDetailed)
{
if (Helper.Instance.con.State == ConnectionState.Closed)
{
try
{
Helper.Instance.con.Open();
SqlCommand cmd = new SqlCommand("UPDATE AdjustInventoryDetailed SET OldQty=@OldQty,NewQty=@NewQty,DifferenceQty=@DifferenceQty,DifferenceValue=@DifferenceValue WHERE ItemID=@ItemID AND Number=@Number ", Helper.Instance.con);
cmd.Parameters.Add("@OldQty", SqlDbType.Float).Value = aAdjustDetailed.OldQty;
cmd.Parameters.Add("@NewQty", SqlDbType.Float).Value = aAdjustDetailed.NewQty;
cmd.Parameters.Add("@DifferenceQty", SqlDbType.Float).Value = aAdjustDetailed.DifferenceQty;
cmd.Parameters.Add("@DifferenceValue", SqlDbType.Float).Value = aAdjustDetailed.DifferenceValue;
cmd.Parameters.Add("@ItemID", SqlDbType.Int).Value = aAdjustDetailed.ItemID;
cmd.Parameters.Add("@Number", SqlDbType.Int).Value = aAdjustDetailed.Number;
cmd.ExecuteNonQuery();
Helper.Instance.con.Close();
return(true);
}
catch (Exception ex)
{
Helper.Instance.con.Close();
throw new Exception("ERROR IN *AdjustInventoryDetailedMgmt* MGMT (UpdateDetailedSingleEntry FUNCTION) EX=" + ex.Message.ToString());
}
}
else
{
throw new Exception("ERROR IN *AdjustInventoryDetailedMgmt* MGMT (UpdateDetailedSingleEntry FUNCTION Connection already open) ");
}
}
private bool UpdateAdjustDetailedEntry(DataTable aTable, int GeneralNumber)
{
try
{
AdjustInventoryDetailed aAdjustDetailed = new AdjustInventoryDetailed();
foreach (DataRow aRow in aItemsTable.Rows)
{
aAdjustDetailed.Number = GeneralNumber;
aAdjustDetailed.ItemID = int.Parse(aRow["ItemID"].ToString());
aAdjustDetailed.OldQty = double.Parse(aRow["NewQty"].ToString());/* bug it should be updated to the next one*/
aAdjustDetailed.NewQty = double.Parse(aRow["PhysicalCountColumn"].ToString());
aAdjustDetailed.DifferenceQty = double.Parse(aRow["DifferencesColumn"].ToString());
aAdjustDetailed.DifferenceValue = double.Parse(aRow["DiffValueColumn"].ToString());
double CurrentQty = double.Parse(ReportsHelper.FindData(AllItemsTable,"ID","Qty",aRow["ItemID"].ToString()));
if (AdjustInventoryDetailedMgmt.UpdateDetailedSingleEntry(aAdjustDetailed))
{
if (!ItemsMgmt.UpdateItemQtyByID(aAdjustDetailed.ItemID, (CurrentQty - (aAdjustDetailed.OldQty - aAdjustDetailed.NewQty))))
{
return false;
}
continue;
}
else
{
return false;
}
}
return true;
}
catch (Exception ex)
{
MessageBox.Show("Exception in UpdateAdjustDetailedEntry {EXCEPTION}" + ex.ToString(), "PLEASE CONTACT CALCIUM", MessageBoxButtons.OK, MessageBoxIcon.Error);
return false;
}
}
public static bool AddAdjustDetailedItem(AdjustInventoryDetailed aAdjustDetailed)
{
if (Helper.Instance.con.State == ConnectionState.Closed)
{
try
{
Helper.Instance.con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO AdjustInventoryDetailed (Number, ItemID ,OldQty, NewQty,DifferenceQty,DifferenceValue) VALUES (@Number,@ItemID,@OldQty,@NewQty,@DifferenceQty,@DifferenceValue)", Helper.Instance.con);
cmd.Parameters.Add("@Number", SqlDbType.Int).Value = aAdjustDetailed.Number;
cmd.Parameters.Add("@ItemID", SqlDbType.Int).Value = aAdjustDetailed.ItemID;
cmd.Parameters.Add("@OldQty", SqlDbType.Float).Value = aAdjustDetailed.OldQty;
cmd.Parameters.Add("@NewQty", SqlDbType.Float).Value = aAdjustDetailed.NewQty;
cmd.Parameters.Add("@DifferenceQty", SqlDbType.Float).Value = aAdjustDetailed.DifferenceQty;
cmd.Parameters.Add("@DifferenceValue", SqlDbType.Float).Value = aAdjustDetailed.DifferenceValue;
cmd.ExecuteNonQuery();
Helper.Instance.con.Close();
return(true);
}
catch (Exception ex)
{
Helper.Instance.con.Close();
throw new Exception("ERROR IN *AdjustInventoryDetailedMgmt* MGMT (AddAdjust FUNCTION) EX=" + ex.Message.ToString());
}
}
else
{
throw new Exception("ERROR IN *AdjustInventoryDetailedMgmt* MGMT (Connection Already Open)");
}
}
private bool AddAdjustDetailedEntry(DataTable aTable, int GeneralNumber)
{
try
{
AdjustInventoryDetailed aAdjustDetailed = new AdjustInventoryDetailed();
foreach (DataRow aRow in aItemsTable.Rows)
{
if (double.Parse(aRow["DifferencesColumn"].ToString()) == 0)
{
continue;
}
aAdjustDetailed.Number = GeneralNumber;
aAdjustDetailed.ItemID = int.Parse(aRow["ID"].ToString());
aAdjustDetailed.OldQty = double.Parse(aRow["Qty"].ToString());
aAdjustDetailed.NewQty = double.Parse(aRow["PhysicalCountColumn"].ToString());
aAdjustDetailed.DifferenceQty = double.Parse(aRow["DifferencesColumn"].ToString());
aAdjustDetailed.DifferenceValue = double.Parse(aRow["DiffValueColumn"].ToString());
if (AdjustInventoryDetailedMgmt.AddAdjustDetailedItem(aAdjustDetailed))
{
if (!ItemsMgmt.UpdateItemQtyByID(aAdjustDetailed.ItemID, aAdjustDetailed.NewQty))
{
return false;
}
continue;
}
else
{
return false;
}
}
return true;
}
catch (Exception ex)
{
MessageBox.Show("Exception in AddAdjustDetailedEntry {EXCEPTION}" + ex.ToString(), "PLEASE CONTACT CALCIUM", MessageBoxButtons.OK, MessageBoxIcon.Error);
return false;
}
}
