public static List <Model.mdlGetWarehouseCoordinate> GetCustomerCoordinateAll(string customerID)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@customerID", SqlDbType = SqlDbType.NVarChar, Value = customerID
}
};
string query = "";
query = "SELECT WarehouseID,CustomerID,Latitude,Longitude,Radius FROM Warehouse where CustomerID = @customerID";
DataTable dtWarehouse = Manager.DataFacade.DTSQLCommand(query, sp);
var listCoordinate = new List <Model.mdlGetWarehouseCoordinate>();
foreach (DataRow row in dtWarehouse.Rows)
{
if (row["Latitude"].ToString() != "" && row["Longitude"].ToString() != "")
{
var mdlWarehouse = new Model.mdlGetWarehouseCoordinate();
mdlWarehouse.WarehouseID = row["WarehouseID"].ToString();
mdlWarehouse.CustomerID = row["CustomerID"].ToString();
mdlWarehouse.Latitude = row["Latitude"].ToString();
mdlWarehouse.Longitude = row["Longitude"].ToString();
mdlWarehouse.Radius = row["Radius"].ToString();
listCoordinate.Add(mdlWarehouse);
}
}
query = "SELECT '' as WarehouseID,CustomerID,Latitude,Longitude,Radius FROM Customer where CustomerID=@customerID";
DataTable dtCustomer = Manager.DataFacade.DTSQLCommand(query, sp);
foreach (DataRow row in dtCustomer.Rows)
{
var mdlWarehouse = new Model.mdlGetWarehouseCoordinate();
mdlWarehouse.WarehouseID = row["WarehouseID"].ToString();
mdlWarehouse.CustomerID = row["CustomerID"].ToString();
mdlWarehouse.Latitude = row["Latitude"].ToString();
mdlWarehouse.Longitude = row["Longitude"].ToString();
mdlWarehouse.Radius = row["Radius"].ToString();
listCoordinate.Add(mdlWarehouse);
}
return(listCoordinate);
}
public static Model.mdlGetWarehouseCoordinate GetWarehouseCoordinate(string customerID, string warehouseID)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@customerID", SqlDbType = SqlDbType.NVarChar, Value = '%' + customerID + '%'
},
new SqlParameter()
{
ParameterName = "@warehouseID", SqlDbType = SqlDbType.NVarChar, Value = '%' + warehouseID + '%'
}
};
string query = "";
if (warehouseID != "" || warehouseID != null)
{
query = "SELECT WarehouseID,CustomerID,Latitude,Longitude,Radius FROM Warehouse where CustomerID LIKE @customerID AND WarehouseID LIKE @warehouseID";
}
else
{
query = "SELECT '' as WarehouseID,CustomerID,Latitude,Longitude,Radius FROM Customer where CustomerID LIKE @customerID";
}
DataTable dtWarehouse = Manager.DataFacade.DTSQLCommand(query, sp);
var mdlWarehouse = new Model.mdlGetWarehouseCoordinate();
foreach (DataRow row in dtWarehouse.Rows)
{
mdlWarehouse.WarehouseID = row["WarehouseID"].ToString();
mdlWarehouse.CustomerID = row["CustomerID"].ToString();
mdlWarehouse.Latitude = row["Latitude"].ToString();
mdlWarehouse.Longitude = row["Longitude"].ToString();
mdlWarehouse.Radius = row["Radius"].ToString();
}
return(mdlWarehouse);
}
public static string GetEmail(string customerID)
{
string email = string.Empty;
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@customerID", SqlDbType = SqlDbType.NVarChar, Value = '%' + customerID + '%'
}
};
DataTable dtWarehouse = Manager.DataFacade.DTSQLCommand("SELECT Email FROM Customer where CustomerID LIKE @customerID", sp);
var mdlWarehouse = new Model.mdlGetWarehouseCoordinate();
foreach (DataRow row in dtWarehouse.Rows)
{
email = row["Email"].ToString();
}
return(email);
}
