public static bool AddAdjustGeneralItem(AdjustInventoryGeneral aAdjustGeneral)
{
if (Helper.Instance.con.State == ConnectionState.Closed)
{
try
{
Helper.Instance.con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO AdjustInventoryGeneral (Number,TellerID,Date,IsChecked) VALUES (@Number,@TellerID,@Date,@IsChecked)", Helper.Instance.con);
cmd.Parameters.Add("@Number", SqlDbType.Int).Value = aAdjustGeneral.Number;
cmd.Parameters.Add("@TellerID", SqlDbType.Int).Value = aAdjustGeneral.TellerID;
cmd.Parameters.Add("@Date", SqlDbType.Date).Value = aAdjustGeneral.Date;
cmd.Parameters.Add("@IsChecked", SqlDbType.Int).Value = 0;
// cmd.Parameters.Add("@CheckedBy", SqlDbType.NVarChar).Value = aAdjustGeneral.IsChecked;
// cmd.Parameters.Add("@CheckDate", SqlDbType.Date).Value = aAdjustGeneral.CheckDate;
// cmd.Parameters.Add("@CheckTime", SqlDbType.NVarChar).Value = aAdjustGeneral.CheckTime;
cmd.ExecuteNonQuery();
Helper.Instance.con.Close();
return(true);
}
catch (Exception ex)
{
Helper.Instance.con.Close();
throw new Exception("ERROR IN *AdjustInventoryGeneralMgmt* MGMT (AddAdjustGeneralItem FUNCTION) EX=" + ex.Message.ToString());
}
}
else
{
throw new Exception("ERROR IN *AdjustInventoryGeneralMgmt* MGMT (FUNCTION:AddAdjustGeneralItem Connection Already Open)");
}
}
public static bool CheckAdjustGeneralEntry(AdjustInventoryGeneral aAdjustGeneral)
{
if (Helper.Instance.con.State == ConnectionState.Closed)
{
try
{
Helper.Instance.con.Open();
SqlCommand cmd = new SqlCommand("UPDATE AdjustInventoryGeneral SET IsChecked=@IsChecked,CheckedBy=@CheckedBy,CheckDate=@CheckDate,CheckTime=@CheckTime WHERE Number=@Number", Helper.Instance.con);
cmd.Parameters.Add("@Number", SqlDbType.Int).Value = aAdjustGeneral.Number;
cmd.Parameters.Add("@IsChecked", SqlDbType.Int).Value = 1;
cmd.Parameters.Add("@CheckedBy", SqlDbType.NVarChar).Value = aAdjustGeneral.CheckedBy;
cmd.Parameters.Add("@CheckDate", SqlDbType.Date).Value = aAdjustGeneral.CheckDate;
cmd.Parameters.Add("@CheckTime", SqlDbType.NVarChar).Value = aAdjustGeneral.CheckTime;
cmd.ExecuteNonQuery();
Helper.Instance.con.Close();
return(true);
}
catch (Exception ex)
{
Helper.Instance.con.Close();
throw new Exception("ERROR IN *AdjustInventoryGeneralMgmt* MGMT (CheckAdjustGeneralEntry FUNCTION) EX=" + ex.Message.ToString());
}
}
else
{
throw new Exception("ERROR IN *AdjustInventoryGeneralMgmt* MGMT (FUNCTION:CheckAdjustGeneralEntry Connection Already Open)");
}
}
private int AddAdjustGeneralEntry(DataTable aTable)
{
try
{
if (!ValidateAdjustTable(aTable))
{
return -1;
}
AdjustInventoryGeneral aAdjustGeneral = new AdjustInventoryGeneral();
aAdjustGeneral.Number = AdjustInventoryGeneralMgmt.NextBillNumber();
aAdjustGeneral.TellerID = Convert.ToInt32(UsersMgmt.SelectUserIDByUserName(SharedFunctions.ReturnLoggedUserName()).ToString());
aAdjustGeneral.Date = DateTime.Now.ToShortDateString();
aAdjustGeneral.IsChecked = 0;
if (AdjustInventoryGeneralMgmt.AddAdjustGeneralItem(aAdjustGeneral))
{
return aAdjustGeneral.Number;
}
else
{
return aAdjustGeneral.Number;
}
}
catch (Exception ex)
{
MessageBox.Show("NOT ADDED \n ERROR IN ADJUSTITEMSFRM: FUNCTION:AddAdjustToDataBase {EXCEPTION }" + ex.ToString(), MsgTxt.UnexpectedError, MessageBoxButtons.OK, MessageBoxIcon.Error);
return -1;
}
}
