public void IssueGRN(long TransferInID, string SupplierDRNo, DateTime DeliveryDate)
{
try
{
string SQL = "UPDATE tblTransferIn SET " +
"SupplierDRNo = @SupplierDRNo, " +
"DeliveryDate = @DeliveryDate, " +
"Status = @Status " +
"WHERE TransferInID = @TransferInID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmSupplierDRNo = new MySqlParameter("@SupplierDRNo",MySqlDbType.String);
prmSupplierDRNo.Value = SupplierDRNo;
cmd.Parameters.Add(prmSupplierDRNo);
MySqlParameter prmDeliveryDate = new MySqlParameter("@DeliveryDate",MySqlDbType.DateTime);
prmDeliveryDate.Value = DeliveryDate.ToString("yyyy-MM-dd HH:mm:ss");
cmd.Parameters.Add(prmDeliveryDate);
MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16);
prmStatus.Value = TransferInStatus.Posted.ToString("d");
cmd.Parameters.Add(prmStatus);
MySqlParameter prmTransferInID = new MySqlParameter("@TransferInID",MySqlDbType.Int64);
prmTransferInID.Value = TransferInID;
cmd.Parameters.Add(prmTransferInID);
base.ExecuteNonQuery(cmd);
/*******************************************
* Update the status of items
* ****************************************/
TransferInItem clsTransferInItem = new TransferInItem(base.Connection, base.Transaction);
clsTransferInItem.Post(TransferInID);
/*******************************************
* Update Vendor Account
* ****************************************/
AddItemToInventory(TransferInID);
/*******************************************
* Update Account Balance
* ****************************************/
UpdateAccounts(TransferInID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
