//FERNANDES
public static List <Model.mdlCustomer> GetCustomerorWarehouseCoordinate(List <Model.mdlVisitTracking> lParamlist)
{
var mdlCustomerList = new List <Model.mdlCustomer>();
foreach (var lParam in lParamlist)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@CustomerID", SqlDbType = SqlDbType.NVarChar, Value = lParam.CustomerID
},
new SqlParameter()
{
ParameterName = "@WarehouseID", SqlDbType = SqlDbType.NVarChar, Value = lParam.WarehouseID
}
};
if (lParam.CustomerID == lParam.WarehouseID)
{
DataTable dtCustomer = Manager.DataFacade.DTSQLCommand(@"SELECT CustomerID, CustomerName, Latitude, Longitude,CustomerAddress
FROM Customer
WHERE CustomerID=@CustomerID AND Latitude <> '' AND Latitude <> '0' AND Latitude IS NOT NULL
AND Longitude <> '' AND Longitude <> '0' AND Longitude IS NOT NULL", sp);
foreach (DataRow row in dtCustomer.Rows)
{
var mdlCustomer = new Model.mdlCustomer();
mdlCustomer.CustomerID = row["CustomerID"].ToString();
mdlCustomer.CustomerName = row["CustomerName"].ToString();
mdlCustomer.CustomerAddress = row["CustomerAddress"].ToString();
mdlCustomer.Latitude = row["Latitude"].ToString();
mdlCustomer.Longitude = row["Longitude"].ToString();
mdlCustomerList.Add(mdlCustomer);
}
}
else
{
DataTable dtCustomer = Manager.DataFacade.DTSQLCommand(@"SELECT WarehouseID, WarehouseName, Latitude, Longitude, WarehouseAddress
FROM Warehouse
WHERE CustomerID=@CustomerID AND WarehouseID=@WarehouseID AND Latitude <> '' AND Latitude <> '0' AND Latitude IS NOT NULL
AND Longitude <> '' AND Longitude <> '0' AND Longitude IS NOT NULL", sp);
foreach (DataRow row in dtCustomer.Rows)
{
var mdlCustomer = new Model.mdlCustomer();
mdlCustomer.CustomerID = row["WarehouseID"].ToString();
mdlCustomer.CustomerName = row["WarehouseName"].ToString();
mdlCustomer.CustomerAddress = row["WarehouseAddress"].ToString();
mdlCustomer.Latitude = row["Latitude"].ToString();
mdlCustomer.Longitude = row["Longitude"].ToString();
mdlCustomerList.Add(mdlCustomer);
}
}
}
return(mdlCustomerList);
}
public static List <Model.mdlCustomer> GetSearchCustomerByBranch(string keyword, string branchid)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
};
var mdlCustList = new List <Model.mdlCustomer>();
DataTable dtCust = Manager.DataFacade.DTSQLCommand(@"SELECT CustomerID,
CustomerName,
CustomerAddress, BranchID
from Customer
Where BranchID IN (" + branchid + ") and (CustomerID LIKE '%" + keyword + "%' or CustomerName LIKE '%" + keyword + "%')", sp);
foreach (DataRow row in dtCust.Rows)
{
var mdlCust = new Model.mdlCustomer();
mdlCust.CustomerID = row["CustomerID"].ToString();
mdlCust.CustomerName = row["CustomerName"].ToString();
mdlCust.CustomerAddress = row["CustomerAddress"].ToString();
mdlCust.BranchID = row["BranchID"].ToString();
mdlCustList.Add(mdlCust);
}
return(mdlCustList);
}
public static List <Model.mdlCustomer> GetCustomerCoordinate(string lBranchID)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@BranchID", SqlDbType = SqlDbType.NVarChar, Value = lBranchID
},
};
var mdlCustomerList = new List <Model.mdlCustomer>();
DataTable dtCustomer = Manager.DataFacade.DTSQLCommand(@"SELECT CustomerID, CustomerName, CustomerAddress, Phone, PIC, Latitude, Longitude
FROM Customer
WHERE BranchID=@BranchID AND Latitude <> '' AND Latitude <> '0' AND Latitude IS NOT NULL
AND Longitude <> '' AND Longitude <> '0' AND Longitude IS NOT NULL", sp);
foreach (DataRow row in dtCustomer.Rows)
{
var mdlCustomer = new Model.mdlCustomer();
mdlCustomer.CustomerID = row["CustomerID"].ToString();
mdlCustomer.CustomerName = row["CustomerName"].ToString();
mdlCustomer.CustomerAddress = row["CustomerAddress"].ToString();
mdlCustomer.Phone = row["Phone"].ToString();
mdlCustomer.PIC = row["PIC"].ToString();
mdlCustomer.Latitude = row["Latitude"].ToString();
mdlCustomer.Longitude = row["Longitude"].ToString();
mdlCustomerList.Add(mdlCustomer);
}
return(mdlCustomerList);
}
public static List <Model.mdlCustomer> LoadCustomer(Model.mdlParam json)
{
var mdlCustomerList = new List <Model.mdlCustomer>();
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@Date", SqlDbType = SqlDbType.DateTime, Value = Convert.ToDateTime(json.Date).Date
},
new SqlParameter()
{
ParameterName = "@EmployeeID", SqlDbType = SqlDbType.NVarChar, Value = json.EmployeeID
},
new SqlParameter()
{
ParameterName = "@BranchID", SqlDbType = SqlDbType.NVarChar, Value = json.BranchID
}
};
DataTable dtCustomer = Manager.DataFacade.DTSQLCommand(@"SELECT * FROM Customer", sp);
foreach (DataRow drCustomer in dtCustomer.Rows)
{
var mdlCustomer = new Model.mdlCustomer();
mdlCustomer.CustomerID = drCustomer["CustomerID"].ToString();
mdlCustomer.CustomerName = drCustomer["CustomerName"].ToString();
mdlCustomer.CustomerAddress = drCustomer["CustomerAddress"].ToString();
mdlCustomer.Phone = drCustomer["Phone"].ToString();
mdlCustomer.Email = drCustomer["Email"].ToString();
mdlCustomer.PIC = drCustomer["PIC"].ToString();
mdlCustomer.CustomerTypeID = drCustomer["CustomerTypeID"].ToString();
mdlCustomer.Latitude = drCustomer["Latitude"].ToString();
mdlCustomer.Longitude = drCustomer["Longitude"].ToString();
mdlCustomer.BranchID = drCustomer["BranchID"].ToString();
mdlCustomer.Radius = drCustomer["Radius"].ToString();
mdlCustomer.City = drCustomer["City"].ToString();
mdlCustomer.CountryRegionCode = drCustomer["CountryRegionCode"].ToString();
//mdlCustomer.Blocked = drCustomer["Blocked"].ToString();
mdlCustomer.Account = drCustomer["Account"].ToString();
mdlCustomer.Channel = drCustomer["Channel"].ToString();
mdlCustomer.Distributor = drCustomer["Distributor"].ToString();
mdlCustomer.EmployeeID = drCustomer["EmployeeID"].ToString();
mdlCustomer.Mobilephone1 = drCustomer["Mobilephone1"].ToString();
mdlCustomer.Mobilephone2 = drCustomer["Mobilephone2"].ToString();
mdlCustomer.BankAccountNumber = drCustomer["BankAccountNumber"].ToString();
mdlCustomerList.Add(mdlCustomer);
}
return(mdlCustomerList);
}
