LoginDetails _userType = new LoginDetails(); //Access Privilages handler
public FinalAnalysis()
{
InitializeComponent();
_context = new adoraDBContext(); // Initialize DB Context
_dao = new FinalAnalysisDAO(); // Initialize Data access object
// Set the ChartController class as the dataContext for this class
DataContext = new ChartController();
// Yearly radio button is checked defaultly
radioYearly.IsChecked = true;
// Yearly radio button in tabular format is checked defaultly
radioYearly1.IsChecked = true;
// Add years from 2012 onwards till current year
for (int i = 2012; i <= DateTime.Today.Year; i++)
{
dropYear.Items.Add(i);
dropYear1.Items.Add(i);
}
// Select Current Year and month defaultly
dropYear1.SelectedIndex = dropYear1.Items.Count -1;
dropMonth1.SelectedIndex = DateTime.Now.Month -1;
// Populate statistical data
populateData();
}
//method a list of strings
public List<string> getItems()
{
try
{
using (adoraDBContext a = new adoraDBContext())
{
var items = (from e in a.StockInHands
where e.ACostID == null
select new {e.ItemName, e.StockID}
).Distinct().ToList();
List<string> rlist = new List<string>();
for (int i = 0; i < items.Count; i++)
{
rlist.Add(items[i].ItemName +" |" + items[i].StockID.ToString());
}
return rlist;
}
}
catch (ArgumentException argumentException)
{
addException(argumentException, "getItems()");
return null;
}
}
//this method is used to update the combobox contet according to the users key strocks in fabric tab, catagory combo box
public void updateSearchComboBoxFab(ComboBox cmbBox)
{
try
{
using (adoraDBContext a = new adoraDBContext())
{
String searchText = cmbBox.Text.ToString();
var fabtype = (from e in a.Fabrics
where e.Category.Contains(searchText)
select new { e.Category }
).Distinct().ToList();
List<String> nList = new List<string>();
for (int i = 0; i < fabtype.Count; i++)
{
String n = fabtype[i].Category.ToString();
String nm = n;
nList.Add(nm);
}
cmbBox.ItemsSource = nList;
cmbBox.IsDropDownOpen = true;
}
}
catch (Exception e)
{
}
}
//this method will update the combo box unit in accessories according to the users key strokes
public void updateSearchComboBoxAccUni(ComboBox cmbBox)
{
try
{
using (adoraDBContext a = new adoraDBContext())
{
String searchText = cmbBox.Text.ToString();
var unitType = (from e in a.Accessories
where e.UnitType.Contains(searchText)
select new { e.UnitType }
).Distinct().ToList();
List<String> nList = new List<string>();
for (int i = 0; i < unitType.Count; i++)
{
String n = unitType[i].UnitType.ToString();
String nm = n;
nList.Add(nm);
}
cmbBox.ItemsSource = nList;
cmbBox.IsDropDownOpen = true;
}
}
catch (Exception e)
{
}
}
}//addFixedOverHead method ends
//this returns the month if it is already in the fixed overhead table eles returs null
public string getmonth(int month, int year)
{
string fixID = "";
try
{
using (adoraDBContext a = new adoraDBContext())
{
var mnth = (from ea in a.FixedOverheads
where (ea.Year == year && ea.Month == month)
select ea.FixID
).ToList();
if (mnth.Count() > 0)
{
fixID = mnth.First();
}
else
fixID = null;
return fixID;
}
}
catch (Exception ex)
{
addException(ex, "getmonth");
return null;
}
}//getmonth methods ends
// This method calculates total price for given item and display it in a given currency type
public double calctotalPrice(double pricePerPiece, int noOfPieces, String currency)
{
double total = (pricePerPiece * noOfPieces); // Calculates the total Price in LKR
double trueValue = 0;
// If the user selected currency type is not LKR
if (currency != "LKR")
{
using (adoraDBContext a = new adoraDBContext())
{
// Linq query to get the ID of the currency which is specified by the user
var id = (from e in a.CurCategories
where (e.Category == currency)
select e.CurCatID).SingleOrDefault();
// Linq query to get the value of the currency specified by the user
var val = (from s in a.Currencies
where s.CurrencyCategory == id
select s.Value).ToList();
// Convert the retrieved value to double
double value = Convert.ToDouble(val.Last());
// Convert the LKR to required currency type
trueValue = total / value;
}
}
// If the selected currency is LKR
else
{
trueValue = total;
}
return trueValue;
}
public StockLotsSales()
{
InitializeComponent();
_context = new adoraDBContext(); // Initialize DB Context
_handler = new StockLotSalesHandle(); // Initialize Handler
_dao = new StockLotSalesDAO(); // Initialize Data access object
_validator = new StockLotsSalesValidator(); // Initialize validator object
_userHandler = new LoginDetails(); // Initialize user handler object
_val = new Validations();
}
//this method returns a list of fabric types
public List<string> getFabTypes()
{
try
{
using (adoraDBContext a = new adoraDBContext())
{
var items = (from e in a.Fabrics
select e.Category
).Distinct().ToList();
return items;
}
}
catch (ArgumentException argumentException)
{
addException(argumentException, "getFabTypes()");
return null;
}
}
//this method update stockin hand table when actual cost is calculated
public bool updateStock(string id, string actId)
{
try{
using (adoraDBContext a = new adoraDBContext())
{
StockInHand stockObj = _context.StockInHands.First(i => i.StockID == id);
stockObj.ACostID = actId;
int chk = _context.SaveChanges();
if (chk != -1)
return true;
else
return false;
}
}
catch (InvalidCastException invalidCastException)
{
addException(invalidCastException, "updateStock()");
return false;
}
}
private void populateFabID(ComboBox fabID,ComboBox fabCat)
{
String category =null;
if ((fabCat.SelectedItem) != null)
{
category = fabCat.SelectedValue.ToString();
try
{
using (adoraDBContext a = new adoraDBContext())
{
var fbID = (from e in a.Fabrics
where e.Category == category
select e.FabID
).Distinct().ToList();
fabID.ItemsSource = fbID;
}
}
catch (Exception e)
{
MessageBox.Show(e.InnerException.ToString());
}
}
}
// This method reloads the table displaying data
// @returns nothing
private void refreshTable()
{
// Create new viewsource and set the current viewsource to it
System.Windows.Data.CollectionViewSource showBnSDetailViewSource =
((System.Windows.Data.CollectionViewSource)(this.FindResource("showBnSDetailViewSource")));
// Create new db Context
adoraDBContext adbc = new adoraDBContext();
adbc.BnSFrequencies.Load(); // Reload BnSFrequency table
adbc.showBnSDetails.Load(); // Reload showBnSDetails table
// Reassign the viewsource with reloaded BnSDetails view
showBnSDetailViewSource.Source = adbc.showBnSDetails.Local;
}
private void refreshTable()
{
System.Windows.Data.CollectionViewSource showCurDetailViewSource =
((System.Windows.Data.CollectionViewSource)(this.FindResource("showCurDetailViewSource")));
adoraDBContext adbc = new adoraDBContext();
adbc.showCurDetails.Load();
showCurDetailViewSource.Source = adbc.showCurDetails.Local;
System.Windows.Data.CollectionViewSource userViewSource =
((System.Windows.Data.CollectionViewSource)(this.FindResource("userViewSource")));
adbc.Users.Load();
userViewSource.Source = adbc.Users.Local;
}
private void populateCurrencyTypes(ComboBox cmbBox)
{
try
{
using (adoraDBContext a = new adoraDBContext())
{
var types = (from e in a.CurCategories
select e.Category
).Distinct().ToList();
cmbBox.ItemsSource = types;
}
}
catch (Exception e)
{
MessageBox.Show(e.InnerException.ToString());
}
}
private void dropCurrency_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if ((txtAddTotalCost.Text != null && txtAddTotalCost.Text != "") && (txtAddCPP.Text != null && txtAddCPP.Text != ""))
{
int No = Convert.ToInt32(txtAddNoPieces.Text);
double PPP = Convert.ToDouble(txtAddPricePiece.Text);
double Trans = Convert.ToDouble(txtAddTrans.Text);
double SupCom = Convert.ToDouble(txtAddSupComm.Text);
double Misc = Convert.ToDouble(txtAddMisc.Text);
StockLotPurchaseHandle stl = new StockLotPurchaseHandle();
double total = Convert.ToDouble(stl.CalcTotShipment(No, PPP, Trans, SupCom, Misc));
//txtAddTotalCost.Text = value1.ToString("0.00");
double actual = Convert.ToDouble(stl.CalcCPP(No, PPP, Trans, SupCom, Misc));
//txtAddCPP.Text = value2.ToString("0.00");
double trueTotal = 0;
double trueActual = 0;
if (dropCurrency.SelectedValue.ToString() != "LKR")
{
using (adoraDBContext a = new adoraDBContext())
{
var id = (from ee in a.CurCategories
where (ee.Category == dropCurrency.SelectedValue.ToString())
select ee.CurCatID).SingleOrDefault();
var val = (from s in a.Currencies
where s.CurrencyCategory == id
select s.Value).ToList();
double value = Convert.ToDouble(val.Last());
trueTotal = total / value;
trueActual = actual / value;
}
}
else
{
trueTotal = total;
trueActual = actual;
}
//MessageBox.Show(dropCurrency.SelectedValue.ToString());
txtAddTotalCost.Text = trueTotal.ToString("F");
txtAddCPP.Text = trueActual.ToString("F");
curlbl1.Content = dropCurrency.SelectedValue.ToString();
curlbl2.Content = dropCurrency.SelectedValue.ToString();
}
}
//populate combo box unit
public void populateAccUnit(ComboBox cmbBox)
{
try
{
using (adoraDBContext a = new adoraDBContext())
{
var unitType = (from e in a.Accessories
select e.UnitType
).Distinct().ToList();
cmbBox.ItemsSource = unitType;
}
}
catch (Exception e)
{
}
}
private void fillvalsToTextAcc(ComboBox accID)
{
if (accID.SelectedItem != null)
{
try
{
String accesID = accID.Text;
lbleditAssID.Content = accesID;
using (adoraDBContext a = new adoraDBContext())
{
var Category = (from e in a.Accessories
where (e.AccID == accesID)
select e.Category).SingleOrDefault();
var pricePerunit = (from e in a.Accessories
where (e.AccID == accesID)
select e.PricePerUnit).SingleOrDefault();
var noOfUnits = (from s in a.Accessories
where (s.AccID == accesID)
select s.NoOfUnits).SingleOrDefault();
var transport = (from s in a.Accessories
where (s.AccID == accesID)
select s.TransportCost).SingleOrDefault();
var unit = (from s in a.Accessories
where (s.AccID == accesID)
select s.UnitType).SingleOrDefault();
cmbFOBPAddAccUnit.SelectedItem = unit.ToString();
cmbFOBPAddAccType.SelectedItem = Category.ToString();
txtFOBPAddAccPricePerUnit.Text = pricePerunit.ToString();
txtFOBPAddAccNoOfUnits.Text = noOfUnits.ToString();
txtFOBPAddAccCourierTransport.Text = transport.ToString();
calAss();
btnFOBPAddAccAdd.Content = "Update";
}
}
catch (Exception e)
{
MessageBox.Show(e.InnerException.ToString());
}
}
else
{
}
}
// this section is use to refresh the table
private void refreshTable()
{
System.Windows.Data.CollectionViewSource showFobSalesDataSource =
((System.Windows.Data.CollectionViewSource)(this.FindResource("fOBSalesFrequencyViewSource")));
// creating the new databse context object
adoraDBContext adbc = new adoraDBContext();
// loading the FOBSalesFrequencies table
adbc.FOBSalesFrequencies.Load();
showFobSalesDataSource.Source = adbc.FOBSalesFrequencies.Local;
}
// This method returns a frequency object according to the given details
public BnSFrequency getFrequency(String shipId, int freqId, adoraDBContext _Context)
{
try
{
// LINQ query to get the required frequency object
var freq = (from s1 in _Context.BnSFrequencies
where (s1.ShipmentID == shipId && s1.FrequencyID == freqId)
select s1).FirstOrDefault();
return freq;
}
catch (ArgumentNullException e)
{
addException(e, "updateFrequency");
return null;
}
}
private void populateShipmentNames(ComboBox cmbBox)
{
try
{
using (adoraDBContext a = new adoraDBContext())
{
var shipments = (from e in a.PurchasingShipments
select e.Title
).Distinct().ToList();
cmbBox.ItemsSource = shipments;
}
txtDelDate.SelectedIndex = -1;
}
catch (Exception e)
{
MessageBox.Show(e.InnerException.ToString());
}
}
public void refresh()
{
System.Windows.Data.CollectionViewSource purchasingShipmentViewSource =
((System.Windows.Data.CollectionViewSource)(this.FindResource("purchasingShipmentViewSource")));
// Load is an extension method on IQueryable,
// defined in the System.Data.Entity namespace.
// This method enumerates the results of the query,
// similar to ToList but without creating a list.
// When used with Linq to Entities this method
// creates entity objects and adds them to the context.
adoraDBContext adb = new adoraDBContext();
adb.PurchasingShipments.Load();
// After the data is loaded call the DbSet<T>.Local property
// to use the DbSet<T> as a binding source.
purchasingShipmentViewSource.Source = adb.PurchasingShipments.Local;
btnEdit.Visibility = Visibility.Hidden;
}
}//updateFixData method ends
//this method return the fixed ID when the month and year
public string getIdByMonthNYear(int month, int year)
{
using (adoraDBContext a = new adoraDBContext())
{
var fid = (from ea in a.FixedOverheads
where (ea.Year == year && ea.Month == month)
select ea.FixID
).ToList();
return fid.First();
}
}//getIdByMonthNYear mothod ends
}//deleteFixOH method ends
public List<int?> getMonthByYear(int year)
{
try
{
using (adoraDBContext a = new adoraDBContext())
{
var mnth = (from e in a.FixedOverheads
where e.Year == year
select e.Month
).Distinct().ToList();
return mnth;
}
}
catch (Exception eb)
{
addException(eb, "getMonthByYear()");
return null;
}
}//getmonthebyyear method ends
public void populateAccCat(ComboBox cmbBox)
{
try
{
using (adoraDBContext a = new adoraDBContext())
{
var catog = (from e in a.Accessories
select e.Category
).Distinct().ToList();
cmbBox.ItemsSource = catog;
}
}
catch (Exception e)
{
}
}
private void populateAccID(ComboBox accID, ComboBox accCat)
{
String category = null;
if ((accCat.SelectedItem) != null)
{
category = accCat.SelectedValue.ToString();
try
{
using (adoraDBContext a = new adoraDBContext())
{
var accId = (from e in a.Accessories
where e.Category == category
select e.AccID
).Distinct().ToList();
accID.ItemsSource = accId;
}
}
catch (Exception e)
{
MessageBox.Show(e.InnerException.ToString());
}
}
}
private void fillvalsToTextFab(ComboBox fabID)
{
if (fabID.SelectedItem != null)
{
try
{
String fabricID = fabID.Text;
lbleditFabID.Content = fabricID;
using (adoraDBContext a = new adoraDBContext())
{
var Category = (from e in a.Fabrics
where (e.FabID == fabricID)
select e.Category).SingleOrDefault();
var pricePerYard = (from e in a.Fabrics
where (e.FabID == fabricID)
select e.PricePerYard).SingleOrDefault();
var yardage = (from s in a.Fabrics
where (s.FabID == fabricID)
select s.Yardage).SingleOrDefault();
var transport = (from s in a.Fabrics
where (s.FabID == fabricID)
select s.TransportCost).SingleOrDefault();
cmbFOBPAddFabType.SelectedItem = Category.ToString();
txtFOBPAddFabPricePerYard.Text = Convert.ToDouble(pricePerYard).ToString("0.00");
txtFOBPAddFabYardage.Text = Convert.ToDouble(yardage).ToString("0.00");
txtFOBPAddFabCourierTransport.Text =Convert.ToDouble(transport).ToString("0.00");
calFab();
btnFOBPAddFab.Content = "Update";
}
}
catch (Exception e)
{
MessageBox.Show(e.InnerException.ToString());
}
}
else
{
}
}
private void fillForEdit()
{
btnEdit.Visibility = Visibility.Visible;
string ShipmentID = null;
lblShipID.Content = ShipmentID;
string ShipName = txtDelShipName.Text;
//System.DateTime ShipDate = Convert.ToDateTime(txtDelDate.SelectedValue);
try
{
using (adoraDBContext ad = new adoraDBContext())
{
lblShipID.Content = txtDelDate.SelectedValue.ToString();
ShipmentID = lblShipID.Content.ToString();
var NoPieces = (from ab in ad.PurchasingShipments
where (ab.ShipmentID == ShipmentID)
select ab.NoOfPieces).SingleOrDefault();
var PPP = (from ab in ad.PurchasingShipments
where (ab.ShipmentID == ShipmentID)
select ab.PricePerPiece).SingleOrDefault();
var Trans = (from ab in ad.PurchasingShipments
where (ab.ShipmentID == ShipmentID)
select ab.TransportCost).SingleOrDefault();
var SupCom = (from ab in ad.PurchasingShipments
where (ab.ShipmentID == ShipmentID)
select ab.SupplierCommission).SingleOrDefault();
var Misc = (from ab in ad.PurchasingShipments
where (ab.ShipmentID == ShipmentID)
select ab.Micelleneous).SingleOrDefault();
var Date = (from ab in ad.PurchasingShipments
where (ab.ShipmentID == ShipmentID)
select ab.date).SingleOrDefault();
txtAddDate.SelectedDate = Convert.ToDateTime(Date.ToString());
txtAddShipName.Text = txtDelShipName.Text;
txtAddNoPieces.Text = NoPieces.ToString();
txtAddPricePiece.Text = PPP.ToString();
txtAddTrans.Text = Trans.ToString();
txtAddSupComm.Text = SupCom.ToString();
txtAddMisc.Text = Misc.ToString();
}
}
catch (Exception e)
{
// MessageBox.Show(e.ToString());
}
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
// If the user is authorized to perform the delete operation
if (_userType.getUserLevel() == 1 || _userType.getUserLevel() == 2)
{
try
{
string id = lblShipID.Content.ToString();
if (MessageBox.Show("Do you want to delete " + id, "Confirm", MessageBoxButton.YesNoCancel, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
adoraDBContext adb = new adoraDBContext();
PurchasingShipment psp = adb.PurchasingShipments.FirstOrDefault(i => i.ShipmentID == id);
adb.PurchasingShipments.Remove(psp);
adb.SaveChanges();
// this.purchasingShipmentDataGrid.Items.Refresh();
//context.PurchasingShipments.Load();
populateShipmentNames(txtDelShipName);
MessageBox.Show("Successfully Deleted", "Done", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
catch (Exception es)
{
MessageBox.Show("You cannot delete Shipments which are having associated frequencies! Please delete associated frequencies before deleting the shipment");
}
//adoraDBContext _con = new adoraDBContext();
//_con.PurchasingShipments.Load();
//this.purchasingShipmentDataGrid.Items.Refresh();
refresh();
}
else
{
ModernDialog.ShowMessage("You are not privilaged to perform this action", "Access Denied!", MessageBoxButton.OK);
}
}
}//getmonthebyyear method ends
public void populateYears(ComboBox cmbBox, ComboBox cmbFOHEditMonth)
{
cmbBox.SelectedIndex = -1;
cmbFOHEditMonth.SelectedIndex = -1;
try
{
using (adoraDBContext a = new adoraDBContext())
{
var year = (from e in a.FixedOverheads select e.Year).Distinct().ToList();
cmbBox.ItemsSource = year;
}
}
catch (ArgumentException argumentException)
{
addException(argumentException, "populateYears()");
}
}//populateYears method ends
private void populateShipmentID(ComboBox ID, ComboBox shipName)
{
String shipmentName = null;
if ((shipName.SelectedItem) != null)
{
shipmentName = shipName.SelectedValue.ToString();
try
{
using (adoraDBContext a = new adoraDBContext())
{
var ids = (from e in a.PurchasingShipments
where e.Title == shipmentName
select e.ShipmentID
).Distinct().ToList();
ID.ItemsSource = ids;
//date.SelectedIndex = 0;
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
}
private void btnEdit_Click(object sender, RoutedEventArgs e)
{
ValidateValues();
bool a = lblAddNoPieces.IsVisible;
bool b = lblAddTrans.IsVisible;
bool c = lblAddSupCom.IsVisible;
bool d = lblAddMisc.IsVisible;
bool f = lblAddPPP.IsVisible;
bool g = lblAddDate.IsVisible;
bool h = lblAddShipName.IsVisible;
if (a || b || c || d || f || g || h)
{
MessageBox.Show("Check Values Again", "Message");
}
else
{
StockLotPurchaseHandle stl = new StockLotPurchaseHandle();
int No = Convert.ToInt32(txtAddNoPieces.Text);
double PPP = Convert.ToDouble(txtAddPricePiece.Text);
double Trans = Convert.ToDouble(txtAddTrans.Text);
double SupCom = Convert.ToDouble(txtAddSupComm.Text);
double Misc = Convert.ToDouble(txtAddMisc.Text);
string ShipID = lblShipID.Content.ToString();
double total = stl.CalcTotShipment(No, PPP, Trans, SupCom, Misc);
double actualcostpp = stl.CalcCPP(No, PPP, Trans, SupCom, Misc);
decimal pPPP = Convert.ToDecimal(PPP);
decimal pTrans = Convert.ToDecimal(Trans);
decimal pSupCom = Convert.ToDecimal(SupCom);
decimal pMisc = Convert.ToDecimal(Misc);
string pShipName = txtAddShipName.Text;
DateTime pDate = Convert.ToDateTime(txtAddDate.Text);
try
{
adoraDBContext con = new adoraDBContext();
PurchasingShipment ps = _context.PurchasingShipments.First(i => i.ShipmentID == ShipID);
ps.PricePerPiece = pPPP;
ps.TransportCost = pTrans;
ps.SupplierCommission = pSupCom;
ps.Micelleneous = pMisc;
ps.Title = pShipName;
ps.date = pDate;
_context.SaveChanges();
populateShipmentNames(txtDelShipName);
this.purchasingShipmentDataGrid.Items.Refresh();
_context.PurchasingShipments.Load();
System.Windows.MessageBox.Show("Succesfully Updated", "Done", MessageBoxButton.OK, MessageBoxImage.Information);
refresh();
reset();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
