public static List <OrderModifi> SearchSalesOrder(string ItemCategoryCode, string Code)
{
string strSQL = string.Empty;
List <OrderModifi> list = new List <OrderModifi>();
SqlDataReader reader;
strSQL = "SP_WA_SalesOrderSearchForInternal";
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand(strSQL);
try
{
db.AddInParameter(dbCommand, "@ItemCategoryCode", DbType.String, ItemCategoryCode);
db.AddInParameter(dbCommand, "@OrderNo", DbType.String, Code);
reader = (SqlDataReader)db.ExecuteReader(dbCommand);
if (reader.HasRows)
{
while (reader.Read())
{
OrderModifi obj = new OrderModifi();
obj.OrderNo = Convert.ToString(reader.GetValue(reader.GetOrdinal("OrderNo")));
obj.Amount = Math.Round(Convert.ToDouble(reader.GetValue(reader.GetOrdinal("Amount"))));
obj.PostingDate = Convert.ToString(reader.GetValue(reader.GetOrdinal("PostingDate")));
obj.BlanketOrderNo = Convert.ToString(reader.GetValue(reader.GetOrdinal("BlanketOrderNo")));
list.Add(obj);
}
}
if (!reader.IsClosed)
{
reader.Close();
}
}
catch (SqlException e)
{ throw e; }
catch (Exception e)
{ throw e; }
finally
{
dbCommand.Dispose();
dbCommand = null;
db = null;
}
return(list);
}
public static List <OrderModifi> InternalListApprover()
{
string strSQL = string.Empty;
List <OrderModifi> list = new List <OrderModifi>();
SqlDataReader reader;
strSQL = "SP_WA_OrderModificationInternalHistory_Approver";
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand(strSQL);
try
{
reader = (SqlDataReader)db.ExecuteReader(dbCommand);
if (reader.HasRows)
{
while (reader.Read())
{
OrderModifi obj = new OrderModifi();
obj.OrderNo = Convert.ToString(reader.GetValue(reader.GetOrdinal("OrderNo")));
list.Add(obj);
}
}
if (!reader.IsClosed)
{
reader.Close();
}
}
catch (SqlException e)
{ throw e; }
catch (Exception e)
{ throw e; }
finally
{
dbCommand.Dispose();
dbCommand = null;
db = null;
}
return(list);
}
