private void navBarItem4_LinkClicked(object sender, NavBarLinkEventArgs e)
{
var fm = new SearchSales();
fm.Width = ChildFormWidth;
AddChildForm(fm, navBarItem4.Caption);
}
public static List <SearchSales> GetSalesForCollex(string criteria, int branchID)
{
var dbUtil = new DatabaseManager();
var sales = new List <SearchSales>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spGetSalesForCollex";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@strCriteria", criteria);
cmd.Parameters.AddWithValue("@intBranchID", branchID);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var sale = new SearchSales
{
SaleID = ReferenceEquals(reader["intSaleID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSaleID"]),
AccountCode = ReferenceEquals(reader["strAccountCode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strAccountCode"]),
AccountDate = ReferenceEquals(reader["datAccountDate"], DBNull.Value) ? string.Empty : Convert.ToString(reader["datAccountDate"]),
CustomerID = ReferenceEquals(reader["intCustomerID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intCustomerID"]),
CustomerName = ReferenceEquals(reader["strCustomerName"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCustomerName"]),
Rebate = ReferenceEquals(reader["curRebate"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curRebate"]),
intIDMasAccountStatus = ReferenceEquals(reader["intIDMasAccountStatus"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasAccountStatus"])
};
sales.Add(sale);
}
return(sales);
}
}
}
}
