public async void LoadSuppliersAsync()
{
List <Supplier> suppliers = null;
try
{
suppliers = await PersistencyService.LoadSuppliersAsync();
}
catch (Exception e)
{
Debug.WriteLine(e);
throw;
}
if (suppliers != null)
{
foreach (Supplier supplier in suppliers)
{
SupplierList.Add(supplier);
}
}
else
{
throw new ArgumentNullException("Suppliers list null");
}
}
private void AddSupplierExecuted(object obj)
{
SupplierData data = new SupplierData(null, obj as string, null, null, null, null, null);
SupplierList.Add(data);
_database.InsertSupplier(data);
}
/// <summary>
/// 显示列表
/// </summary>
public void ShowSupplierTable()
{
foreach (var model in GetSupplierList())
{
SupplierList.Add(model);
}
ShowSupplierList();
}
//Adds a new supplier to the DB-Grace
public bool AddNewSupplier(int supplierID, string name, string phoneNum, string email, string street, string city, string county, string additionalInfo)
{
SupplierList = DataLayer.getAllSuppliers();
ISupplier supplier;
DataLayer.AddNewSupplierToDB(supplierID, name, phoneNum, email, street, city, county, additionalInfo);
supplier = SupplierFactory.GetSupplier(supplierID, name, phoneNum, email, street, city, county, additionalInfo); // Using a Factory to create the user entity object. ie seperating object creation from business logic
SupplierList.Add(supplier);
// Add a reference to the newly created object to the Models UserList
//Gets the DataLayer to add the new user to the DB.
return(true);
}
public Boolean addnewSupplier(string SupplierID, string CompanyName, string Email, string Phone, string Street, string City, string County, string Country)
{
try
{
ISupplier theSupplier = SupplierFactory.GetSupplier(SupplierID, CompanyName, Email, Phone, Street, City, County, Country); // Using a Factory to create the user entity object. ie seperating object creation from business logic
SupplierList.Add(theSupplier); // Add a reference to the newly created object to the Models UserList
DataLayer.addNewSupplierToDB(theSupplier); //Gets the DataLayer to add the new user to the DB.
return(true);
}
catch (System.Exception excep)
{
return(false);
}
}
/// <summary>
/// Fetch SupplierList.
/// </summary>
/// <param name="criteria">The criteria.</param>
/// <returns></returns>
public SupplierList Fetch(SupplierCriteria criteria)
{
SupplierList item = (SupplierList)Activator.CreateInstance(typeof(SupplierList), true);
bool cancel = false;
OnFetching(criteria, ref cancel);
if (cancel)
{
return(item);
}
// Fetch Child objects.
using (var connection = new SqlConnection(ADOHelper.ConnectionString))
{
connection.Open();
using (var command = new SqlCommand("[dbo].[CSLA_Supplier_Select]", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddRange(ADOHelper.SqlParameters(criteria.StateBag));
command.Parameters.AddWithValue("@p_NameHasValue", criteria.NameHasValue);
command.Parameters.AddWithValue("@p_Addr1HasValue", criteria.Addr1HasValue);
command.Parameters.AddWithValue("@p_Addr2HasValue", criteria.Addr2HasValue);
command.Parameters.AddWithValue("@p_CityHasValue", criteria.CityHasValue);
command.Parameters.AddWithValue("@p_StateHasValue", criteria.StateHasValue);
command.Parameters.AddWithValue("@p_ZipHasValue", criteria.ZipHasValue);
command.Parameters.AddWithValue("@p_PhoneHasValue", criteria.PhoneHasValue);
using (var reader = new SafeDataReader(command.ExecuteReader()))
{
if (reader.Read())
{
do
{
item.Add(new SupplierFactory().Map(reader));
} while(reader.Read());
}
}
}
}
MarkOld(item);
MarkAsChild(item);
OnFetched();
return(item);
}
//constructor
public ManageSupplierList()
{
//loading supplier list
SupplierManager supplierManager = new SupplierManager();
for (Iterator i = supplierManager.getAllSuppliers().iterator(); i.hasNext();)
{
SupplierInfo supplierInfo = (SupplierInfo)i.next();
SupplierInfoNJ supplierInfoNJ = new SupplierInfoNJ();
supplierInfoNJ.ProfileInfoNJ.Id = supplierInfo.getProfileInfo().getId();
supplierInfoNJ.ProfileInfoNJ.FirstName = supplierInfo.getProfileInfo().getFirstName();
supplierInfoNJ.ProfileInfoNJ.LastName = supplierInfo.getProfileInfo().getLastName();
supplierInfoNJ.ProfileInfoNJ.Phone = supplierInfo.getProfileInfo().getPhone();
supplierInfoNJ.ProfileInfoNJ.Fax = supplierInfo.getProfileInfo().getFax();
supplierInfoNJ.ProfileInfoNJ.Email = supplierInfo.getProfileInfo().getEmail();
supplierInfoNJ.ProfileInfoNJ.Website = supplierInfo.getProfileInfo().getWebsite();
supplierInfoNJ.Remarks = supplierInfo.getRemarks();
SupplierList.Add(supplierInfoNJ);
}
}
/*
* This method will search supplier info
* @author A.K.M. Nazmul Islam on 30th january 2016
*/
private void OnSearch()
{
SupplierManager supplierManager = new SupplierManager();
SupplierList.Clear();
for (Iterator i = supplierManager.searchSuppliers(SearchSupplierByPhone).iterator(); i.hasNext();)
{
SupplierInfo supplierInfo = (SupplierInfo)i.next();
SupplierInfoNJ supplierInfoNJ = new SupplierInfoNJ();
supplierInfoNJ.ProfileInfoNJ.Id = supplierInfo.getProfileInfo().getId();
supplierInfoNJ.ProfileInfoNJ.FirstName = supplierInfo.getProfileInfo().getFirstName();
supplierInfoNJ.ProfileInfoNJ.LastName = supplierInfo.getProfileInfo().getLastName();
supplierInfoNJ.ProfileInfoNJ.Phone = supplierInfo.getProfileInfo().getPhone();
supplierInfoNJ.ProfileInfoNJ.Fax = supplierInfo.getProfileInfo().getFax();
supplierInfoNJ.ProfileInfoNJ.Email = supplierInfo.getProfileInfo().getEmail();
supplierInfoNJ.ProfileInfoNJ.Website = supplierInfo.getProfileInfo().getWebsite();
supplierInfoNJ.Remarks = supplierInfo.getRemarks();
SupplierList.Add(supplierInfoNJ);
}
}
public void CreateSupplierList()
{
SupplierList.Clear();
SqlConnection con = Methods.AccessDatabase();
SqlDataAdapter autoNode = new SqlDataAdapter("SELECT * From [SUPPLIER]", con);
DataTable dt = new DataTable();
autoNode.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
SUPPLIER newSupplier = new SUPPLIER();
newSupplier.SupplierID = Convert.ToInt16(dt.Rows[i]["Supplier_ID"]);
newSupplier.SupplierName = dt.Rows[i]["Supplier_Name"].ToString();
newSupplier.SupplierDetails = dt.Rows[i]["Supplier_Details"].ToString();
SupplierList.Add(newSupplier);
}
}
/// <summary>
/// Fetch SupplierList.
/// </summary>
/// <param name="criteria">The criteria.</param>
/// <returns></returns>
public SupplierList Fetch(SupplierCriteria criteria)
{
SupplierList item = (SupplierList)Activator.CreateInstance(typeof(SupplierList), true);
bool cancel = false;
OnFetching(criteria, ref cancel);
if (cancel)
{
return(item);
}
// Fetch Child objects.
string commandText = String.Format("SELECT [SuppId], [Name], [Status], [Addr1], [Addr2], [City], [State], [Zip], [Phone] FROM [dbo].[Supplier] {0}", ADOHelper.BuildWhereStatement(criteria.StateBag));
using (var connection = new SqlConnection(ADOHelper.ConnectionString))
{
connection.Open();
using (var command = new SqlCommand(commandText, connection))
{
command.Parameters.AddRange(ADOHelper.SqlParameters(criteria.StateBag));
using (var reader = new SafeDataReader(command.ExecuteReader()))
{
if (reader.Read())
{
do
{
item.Add(new SupplierFactory().Map(reader));
} while(reader.Read());
}
}
}
}
MarkOld(item);
MarkAsChild(item);
OnFetched();
return(item);
}
/*
* This method will add/update a supplier
* @author nazmul hasan on 5th january 2016
*/
private void OnAdd()
{
if (!ValidateSupplier())
{
MessageBox.Show(ErrorMessage);
return;
}
ProfileInfo profileInfo = new ProfileInfo();
profileInfo.setId(SupplierInfoNJ.ProfileInfoNJ.Id);
profileInfo.setFirstName(SupplierInfoNJ.ProfileInfoNJ.FirstName);
profileInfo.setLastName(SupplierInfoNJ.ProfileInfoNJ.LastName);
profileInfo.setEmail(SupplierInfoNJ.ProfileInfoNJ.Email);
profileInfo.setPhone(SupplierInfoNJ.ProfileInfoNJ.Phone);
profileInfo.setFax(SupplierInfoNJ.ProfileInfoNJ.Fax);
profileInfo.setWebsite(SupplierInfoNJ.ProfileInfoNJ.Website);
SupplierInfo supplierInfo = new SupplierInfo();
supplierInfo.setProfileInfo(profileInfo);
SupplierManager supplierManager = new SupplierManager();
SupplierInfoNJ supplierInfoNJ = new SupplierInfoNJ();
supplierInfoNJ.ProfileInfoNJ.Id = SupplierInfoNJ.ProfileInfoNJ.Id;
supplierInfoNJ.ProfileInfoNJ.FirstName = SupplierInfoNJ.ProfileInfoNJ.FirstName;
supplierInfoNJ.ProfileInfoNJ.LastName = SupplierInfoNJ.ProfileInfoNJ.LastName;
supplierInfoNJ.ProfileInfoNJ.Email = SupplierInfoNJ.ProfileInfoNJ.Email;
supplierInfoNJ.ProfileInfoNJ.Phone = SupplierInfoNJ.ProfileInfoNJ.Phone;
supplierInfoNJ.ProfileInfoNJ.Fax = SupplierInfoNJ.ProfileInfoNJ.Fax;
supplierInfoNJ.ProfileInfoNJ.Website = SupplierInfoNJ.ProfileInfoNJ.Website;
supplierInfoNJ.Remarks = supplierInfo.getRemarks();
ResultEvent resultEvent = new ResultEvent();
if (SupplierInfoNJ.ProfileInfoNJ.Id > 0)
{
resultEvent = supplierManager.updateSupplier(supplierInfo);
}
else
{
resultEvent = supplierManager.createSupplier(supplierInfo);
}
if (resultEvent.getResponseCode() == Responses.RESPONSE_CODE_SUCCESS)
{
if (SupplierInfoNJ.ProfileInfoNJ.Id > 0)
{
for (int counter = 0; counter < SupplierList.Count; counter++)
{
SupplierInfoNJ tempSupplierInfoNJ = SupplierList.ElementAt(counter);
if (tempSupplierInfoNJ.ProfileInfoNJ.Id == SupplierInfoNJ.ProfileInfoNJ.Id)
{
SupplierList.RemoveAt(counter);
SupplierList.Insert(counter, supplierInfoNJ);
}
}
}
else
{
SupplierInfo responseSupplierInfo = (SupplierInfo)resultEvent.getResult();
SupplierInfoNJ.ProfileInfoNJ.Id = responseSupplierInfo.getProfileInfo().getId();
supplierInfoNJ.ProfileInfoNJ.Id = SupplierInfoNJ.ProfileInfoNJ.Id;
if (SupplierList.Count == 0)
{
SupplierList.Add(supplierInfoNJ);
}
else
{
SupplierList.Insert(0, supplierInfoNJ);
}
}
}
MessageBox.Show(resultEvent.getMessage());
//resetting supplier info fields
OnReset();
}
