public List<Customer> listCustomerForPriceList()
{
List<Customer> listCustomer = null;
try
{
using (SqlConnection con = new SqlConnection(VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString))
{
Constant.VisitaJayaPerkasaApplication.anyConnection = false;
con.Open();
Constant.VisitaJayaPerkasaApplication.anyConnection = true;
using (SqlCommand command = new SqlCommand(
"SELECT * FROM [Customer] WHERE (deleted is null OR deleted = '0')"
, con))
{
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Customer customer = new Customer();
customer.ID = Utility.Utility.ConvertToUUID(reader.GetValue(0).ToString());
customer.CustomerName = (Utility.Utility.IsDBNull(reader.GetValue(1))) ? null : reader.GetString(1);
customer.Office = (Utility.Utility.IsDBNull(reader.GetValue(2))) ? null : reader.GetString(2);
customer.Address = (Utility.Utility.IsDBNull(reader.GetValue(3))) ? null : reader.GetString(3);
customer.Phone = (Utility.Utility.IsDBNull(reader.GetValue(4))) ? null : reader.GetString(4);
customer.Fax = (Utility.Utility.IsDBNull(reader.GetValue(5))) ? null : reader.GetString(5);
customer.Email = (Utility.Utility.IsDBNull(reader.GetValue(6))) ? null : reader.GetString(6);
customer.ContactPerson = (Utility.Utility.IsDBNull(reader.GetValue(7))) ? null : reader.GetString(7);
customer.StatusPPN = (Utility.Utility.IsDBNull(reader.GetValue(8))) ? 0 : Convert.ToInt32(reader.GetBoolean(8));
if (listCustomer == null)
listCustomer = new List<Customer>();
listCustomer.Add(customer);
customer = null;
}
}
}
}
catch (Exception e)
{
Logging.Error("SqlCustomerRepository.cs - listCustomerForPriceList() " + e.Message);
}
return listCustomer;
}
private void btnClearAll_Click(object sender, EventArgs e)
{
listPriceDeleteExistsData.Clear();
listIndexPriceDeleteExistsData.Clear();
radButton2.Enabled = true;
pickerTo.Enabled = true;
pickerFrom.Enabled = true;
cboTypeSupplier.Enabled = true;
searchResultCustomer = null;
txtCustomer.Text = "";
if(cboTypeSupplier.Text.ToLower().Equals("dooring agent")){
RefreshTypeSupplier();
SetTypeOfSupplierDooringAgent();
return;
}
cboTypeSupplier.SelectedItem = cboTypeSupplier.Items.ElementAt(0);
}
/*
private bool validateDate(VisitaJayaPerkasa.Entities.PriceList objPriceList, List<String> listID, List<VisitaJayaPerkasa.Entities.PriceList> priceList)
{
bool result = true;
if (sqlPriceListRepository == null)
sqlPriceListRepository = new SqlPriceListRepository();
//query the db
string customerID;
if (searchResultCustomer != null)
customerID = searchResultCustomer.ID.ToString();
else
customerID = Guid.Empty.ToString();
int count = sqlPriceListRepository.FindPriceByDateSupplierCustomer(objPriceList.Date, listSupplier[cbSupplier.SelectedIndex].Id.ToString(), customerID);
if (count > 0)
{
VisitaJayaPerkasa.Entities.PriceList oldPriceList = sqlPriceListRepository.GetPriceByDateSupplierCustomer(objPriceList.Date, listSupplier[cbSupplier.SelectedIndex].Id.ToString(), customerID);
//decimal oldPrice = sqlPriceListRepository.GetSupplierPriceByDateSupplierCustomer(objPriceList.Date, listSupplier[cbSupplier.SelectedIndex].Id.ToString(), customerID);
DialogResult dlgRes = DialogResult.Yes;
if (objPriceList.PriceSupplier != oldPriceList.PriceSupplier)
dlgRes = MessageBox.Show("We already have price list on " + objPriceList.Date.ToString("dd/MMMM/yyyy") + ". Do you want to override supplier price to "+ objPriceList.PriceSupplier.ToString("#,###") +"?", "Data Duplication!", MessageBoxButtons.YesNo);
if (dlgRes == DialogResult.Yes)
{
//query the price id we want to override and set the current data id to existing
objPriceList.ID = oldPriceList.ID;
//add ID to deleted list
if (!listID.Contains(objPriceList.ID.ToString()))
listID.Add(objPriceList.ID.ToString());
for (int i = priceList.Count-1; i >= 0; i--)
{
if (priceList[i].ID.Equals(objPriceList.ID))
priceList.Remove(priceList[i]);
}
result = true;
}
else if (dlgRes == DialogResult.No)
{
//check to the list. if exist, let it be. if not, cancel delete id
bool exist = false;
for (int i = priceList.Count - 1; i >= 0; i--)
{
if (priceList[i].ID.Equals(objPriceList.ID))
{
exist = true;
break;
}
}
if (exist)
listID.Remove(objPriceList.ID.ToString());
//remove this data from list
result = false;
}
}
return result;
}
private bool validateTrucking(VisitaJayaPerkasa.Entities.PriceList objPriceList, List<String> listID, List<VisitaJayaPerkasa.Entities.PriceList> priceList)
{
bool result = true;
if (sqlPriceListRepository == null)
sqlPriceListRepository = new SqlPriceListRepository();
//query the db
string customerID;
if (searchResultCustomer != null)
customerID = searchResultCustomer.ID.ToString();
else
customerID = Guid.Empty.ToString();
string msg = sqlPriceListRepository.FindPriceBySupplierCustomerStuffing(objPriceList.DateFrom, listSupplier[cbSupplier.SelectedIndex].Id.ToString(), customerID, listWarehouse[cboStuffingPlace.SelectedIndex].Id.ToString(), objPriceList.TypeID.ToString());
if (msg != "")
{
VisitaJayaPerkasa.Entities.PriceList oldPriceList = sqlPriceListRepository.GetPriceBySupplierCustomerStuffing(objPriceList.DateFrom, listSupplier[cbSupplier.SelectedIndex].Id.ToString(), customerID, listWarehouse[cboStuffingPlace.SelectedIndex].Id.ToString(), objPriceList.TypeID.ToString());
DialogResult dlgRes = DialogResult.Yes;
if (objPriceList.PriceSupplier != oldPriceList.PriceSupplier || objPriceList.PriceCourier != oldPriceList.PriceCourier)
dlgRes = MessageBox.Show("We already have price list on:\n" + msg + ".\nDo you want to override supplier price to " + objPriceList.PriceSupplier.ToString("#,###") + " and courier price to " + objPriceList.PriceCourier.ToString("#,###") + "?", "Data Duplication!", MessageBoxButtons.YesNo);
if (dlgRes == DialogResult.Yes)
{
//query the price id we want to override and set the current data id to existing
objPriceList.ID = oldPriceList.ID;
//add ID to deleted list
if (!listID.Contains(objPriceList.ID.ToString()))
listID.Add(objPriceList.ID.ToString());
for (int i = priceList.Count - 1; i >= 0; i--)
{
if (priceList[i].ID.Equals(objPriceList.ID))
priceList.Remove(priceList[i]);
}
result = true;
}
else if (dlgRes == DialogResult.No)
{
//check to the list. if exist, let it be. if not, cancel delete id
bool exist = false;
for (int i = priceList.Count - 1; i >= 0; i--)
{
if (priceList[i].ID.Equals(objPriceList.ID))
{
exist = true;
break;
}
}
if (exist)
listID.Remove(objPriceList.ID.ToString());
//remove this data from list
result = false;
}
}
return result;
}
*/
private void cbDislayAll_ToggleStateChanged(object sender, StateChangedEventArgs args)
{
if (args.ToggleState == ToggleState.On)
{
searchResultCustomer = null;
txtCustomer.Text = "";
btnSearch.Enabled = false;
}
else
btnSearch.Enabled = true;
}
private void btnSearch_Click(object sender, EventArgs e)
{
new SearchCustomer().ShowDialog();
if (Constant.VisitaJayaPerkasaApplication.objGetOtherView != null)
{
searchResultCustomer = (VisitaJayaPerkasa.Entities.Customer)Constant.VisitaJayaPerkasaApplication.objGetOtherView;
txtCustomer.Text = searchResultCustomer.CustomerName;
}
Constant.VisitaJayaPerkasaApplication.objGetOtherView = null;
}