private void frmCustomerSales_Load(object sender, EventArgs e)
{
formloaded = false;
CustParameters = new CustomerServicesParameters();
using (var context = new TTI2Entities())
{
var Customers = context.TLADM_CustomerFile.OrderBy(x => x.Cust_Description).ToList();
foreach (var Customer in Customers)
{
cmboCustomers.Items.Add(new CustomerServices.CheckComboBoxItem(Customer.Cust_Pk, Customer.Cust_Description, false));
}
var Styles = context.TLADM_Styles.OrderBy(x => x.Sty_Description).ToList();
foreach (var Style in Styles)
{
cmboStyles.Items.Add(new CustomerServices.CheckComboBoxItem(Style.Sty_Id, Style.Sty_Description, false));
}
var Colours = context.TLADM_Colours.Where(x => !(bool)x.Col_Discontinued).OrderBy(x => x.Col_Display).ToList();
foreach (var Colour in Colours)
{
cmboColours.Items.Add(new CustomerServices.CheckComboBoxItem(Colour.Col_Id, Colour.Col_Display, false));
}
var Sizes = context.TLADM_Sizes.Where(x => !(bool)x.SI_Discontinued).OrderBy(x => x.SI_DisplayOrder).ToList();
foreach (var Size in Sizes)
{
cmboSizes.Items.Add(new CustomerServices.CheckComboBoxItem(Size.SI_id, Size.SI_Description, false));
}
}
rbSummarisedByCustomer.Checked = false;
formloaded = true;
}
private void frmOutStandingPL_Load(object sender, EventArgs e)
{
formloaded = false;
QueryParms = new CustomerServicesParameters();
using (var context = new TTI2Entities())
{
var WareHouses = context.TLADM_WhseStore.Where(x => x.WhStore_GradeA).OrderBy(x => x.WhStore_Description).ToList();
foreach (var WareHouse in WareHouses)
{
cmboWareHouses.Items.Add(new CustomerServices.CheckComboBoxItem(WareHouse.WhStore_Id, WareHouse.WhStore_Description, false));
}
var Styles = context.TLADM_Styles.OrderBy(x => x.Sty_Description).ToList();
foreach (var Style in Styles)
{
cmboStyles.Items.Add(new CustomerServices.CheckComboBoxItem(Style.Sty_Id, Style.Sty_Description, false));
}
var Colours = context.TLADM_Colours.Where(x => (bool)!x.Col_Discontinued).OrderBy(x => x.Col_Display).ToList();
foreach (var Colour in Colours)
{
cmboColours.Items.Add(new CustomerServices.CheckComboBoxItem(Colour.Col_Id, Colour.Col_Display, false));
}
var Sizes = context.TLADM_Sizes.Where(x => (bool)!x.SI_Discontinued).OrderBy(x => x.SI_DisplayOrder).ToList();
foreach (var Size in Sizes)
{
cmboSizes.Items.Add(new CustomerServices.CheckComboBoxItem(Size.SI_id, Size.SI_Description, false));
}
}
formloaded = true;
}
private void frmResetPickingList_Load(object sender, EventArgs e)
{
var ComboSource = new BindingList <KeyValuePair <int, string> >();
FormLoaded = false;
cmboOrderAssigned.DataSource = null;
cmboOrderAssigned.Items.Clear();
QueryParms = new CustomerServicesParameters();
using (var context = new TTI2Entities())
{
var WareHouses = context.TLADM_WhseStore.Where(x => x.WhStore_GradeA).OrderBy(x => x.WhStore_Description).ToList();
foreach (var WareHouse in WareHouses)
{
cmboWarehouses.Items.Add(new CustomerServices.CheckComboBoxItem(WareHouse.WhStore_Id, WareHouse.WhStore_Description, false));
}
var Customers = context.TLADM_CustomerFile.OrderBy(x => x.Cust_Description).ToList();
foreach (var Customer in Customers)
{
cmboCustomer.Items.Add(new CustomerServices.CheckComboBoxItem(Customer.Cust_Pk, Customer.Cust_Description, false));
}
}
FormLoaded = true;
}
private void frmSeleEMailAddress_Load(object sender, EventArgs e)
{
QueryParms = new CustomerServicesParameters();
using (var context = new TTI2Entities())
{
var Ua = context.TLSEC_UserAccess.Where(x => !(bool)x.TLSECUA_Discontinued && x.TLSUCUA_EmailAddress.Length != 0).OrderBy(x => x.TLSECUA_UserName).ToList();
foreach (var U in Ua)
{
cmboEMailAddress.Items.Add(new CheckComboBoxItem(U.TLSECUA_Pk, U.TLSECUA_UserName, false));
}
}
}
private void frmTransferWarehouseToWarehouse_Load(object sender, EventArgs e)
{
FormLoaded = false;
using (var context = new TTI2Entities())
{
cmboFromwarehouse.DataSource = context.TLADM_WhseStore.Where(x => x.WhStore_WhseOrStore).ToList();
cmboFromwarehouse.DisplayMember = "WhStore_Description";
cmboFromwarehouse.ValueMember = "WhStore_Id";
cmboFromwarehouse.SelectedItem = -1;
cmboTowareHouse.DataSource = context.TLADM_WhseStore.Where(x => x.WhStore_WhseOrStore).ToList();
cmboTowareHouse.DisplayMember = "WhStore_Description";
cmboTowareHouse.ValueMember = "WhStore_Id";
cmboTowareHouse.SelectedItem = -1;
var Styles = context.TLADM_Styles.OrderBy(x => x.Sty_Description).ToList();
foreach (var Style in Styles)
{
cmboStyle.Items.Add(new CustomerServices.CheckComboBoxItem(Style.Sty_Id, Style.Sty_Description, false));
}
var Colours = context.TLADM_Colours.OrderBy(x => x.Col_Display).ToList();
foreach (var Colour in Colours)
{
cmboColour.Items.Add(new CustomerServices.CheckComboBoxItem(Colour.Col_Id, Colour.Col_Display, false));
}
var Sizes = context.TLADM_Sizes.Where(x => !(bool)x.SI_Discontinued).OrderBy(x => x.SI_DisplayOrder).ToList();
foreach (var Size in Sizes)
{
cmboSizes.Items.Add(new CustomerServices.CheckComboBoxItem(Size.SI_id, Size.SI_Description, false));
}
}
QueryParms = new CustomerServicesParameters();
TransferMode = false;
btnSubmit.Text = "Submit";
FormLoaded = true;
}
private void frmStockLists_Load(object sender, EventArgs e)
{
FormLoaded = false;
repo = new Repository();
QueryParms = new CustomerServicesParameters();
using (var context = new TTI2Entities())
{
var WareHouses = context.TLADM_WhseStore.Where(x => x.WhStore_WhseOrStore).OrderBy(x => x.WhStore_Description).ToList();
foreach (var WareHouse in WareHouses)
{
this.comboWareHouse.Items.Add(new CheckComboBoxItem(WareHouse.WhStore_Id, WareHouse.WhStore_Description, false));
}
var Styles = context.TLADM_Styles.OrderBy(x => x.Sty_Description).ToList();
foreach (var Style in Styles)
{
this.comboStyles.Items.Add(new CheckComboBoxItem(Style.Sty_Id, Style.Sty_Description, false));
}
var Colours = context.TLADM_Colours.Where(x => !(bool)x.Col_Discontinued).OrderBy(x => x.Col_Display).ToList();
foreach (var Colour in Colours)
{
this.comboColour.Items.Add(new CheckComboBoxItem(Colour.Col_Id, Colour.Col_Display, false));
}
var Sizes = context.TLADM_Sizes.Where(x => !(bool)x.SI_Discontinued).OrderBy(x => x.SI_DisplayOrder).ToList();
foreach (var Size in Sizes)
{
this.comboSizes.Items.Add(new CheckComboBoxItem(Size.SI_id, Size.SI_Description, false));
}
}
//--------------------------------------------------------
// wire up the check state changed event
//--------------------------------------------------------------------------------------------------------
FormLoaded = true;
}
private void frmNegativeStock_Load(object sender, EventArgs e)
{
formloaded = false;
using (var context = new TTI2Entities())
{
var Customers = (from Cust in context.TLADM_CustomerFile
join CustTypes in context.TLADM_CustomerTypes on Cust.Cust_CustomerCat_FK equals CustTypes.CT_Id
where CustTypes.CT_ShortCode == "WS"
select Cust).ToList();
foreach (var Customer in Customers)
{
cmboCustomers.Items.Add(new CustomerServices.CheckComboBoxItem(Customer.Cust_Pk, Customer.Cust_Description, false));
}
var Styles = context.TLADM_Styles.Where(x => (bool)!x.Sty_Discontinued).OrderBy(x => x.Sty_Description).ToList();
foreach (var Style in Styles)
{
cmboStyles.Items.Add(new CustomerServices.CheckComboBoxItem(Style.Sty_Id, Style.Sty_Description, false));
}
var Colours = context.TLADM_Colours.Where(x => (bool)!x.Col_Discontinued).OrderBy(x => x.Col_Display).ToList();
foreach (var Colour in Colours)
{
cmboColours.Items.Add(new CustomerServices.CheckComboBoxItem(Colour.Col_Id, Colour.Col_Display, false));
}
var Sizes = context.TLADM_Sizes.Where(x => (bool)!x.SI_Discontinued).OrderBy(x => x.SI_DisplayOrder).ToList();
foreach (var Size in Sizes)
{
cmboSizes.Items.Add(new CustomerServices.CheckComboBoxItem(Size.SI_id, Size.SI_Description, false));
}
repo = new Repository();
}
QueryParms = new CustomerServicesParameters();
formloaded = true;
}
private void frmDetailCustomerOrders_Load(object sender, EventArgs e)
{
IList <TLADM_CustomerFile> CustFile = null;
formloaded = false;
repo = new Repository();
parms = new CustomerServicesParameters();
var reportOptions = new BindingList <KeyValuePair <int, string> >();
using (var context = new TTI2Entities())
{
if (UserDet._External == false)
{
CustFile = context.TLADM_CustomerFile.OrderBy(x => x.Cust_Description).ToList();
foreach (var Customer in CustFile)
{
comboCustomers.Items.Add(new CustomerServices.CheckComboBoxItem(Customer.Cust_Pk, Customer.Cust_Description, false));
}
}
else
{
var AccessPermitted = context.TLADM_CustomerAccess.Where(x => x.CustAcc_User_Fk == UserDet._UserPk).ToList();
foreach (var Access in AccessPermitted)
{
var CustDesc = context.TLADM_CustomerFile.Find(Access.CustAcc_Customer_Fk).Cust_Description;
comboCustomers.Items.Add(new CustomerServices.CheckComboBoxItem(Access.CustAcc_Customer_Fk, CustDesc, false));
}
}
var Styles = context.TLADM_Styles.OrderBy(x => x.Sty_Description).ToList();
foreach (var Style in Styles)
{
comboStyles.Items.Add(new CustomerServices.CheckComboBoxItem(Style.Sty_Id, Style.Sty_Description, false));
}
var Colours = context.TLADM_Colours.OrderBy(x => x.Col_Display).ToList();
foreach (var Colour in Colours)
{
comboColours.Items.Add(new CustomerServices.CheckComboBoxItem(Colour.Col_Id, Colour.Col_Display, false));
}
var Sizes = context.TLADM_Sizes.Where(x => (bool)!x.SI_Discontinued).OrderBy(x => x.SI_DisplayOrder).ToList();
foreach (var Size in Sizes)
{
comboSizes.Items.Add(new CustomerServices.CheckComboBoxItem(Size.SI_id, Size.SI_Description, false));
}
rbProvisionalOrdersOnly.Checked = false;
rbStdOrdersOnly.Checked = true;
}
//--------------------------------------------------------
// wire up the check state changed event
//--------------------------------------------------------------------------------------------------------
this.comboCustomers.CheckStateChanged += new System.EventHandler(this.comboCust_CheckStateChanged);
this.comboStyles.CheckStateChanged += new System.EventHandler(this.cmboStyles_CheckStateChanged);
this.comboColours.CheckStateChanged += new System.EventHandler(this.cmboColours_CheckStateChanged);
this.comboSizes.CheckStateChanged += new System.EventHandler(this.cmboSizes_CheckStateChanged);
formloaded = true;
}
private void frmPivotTables_Load(object sender, EventArgs e)
{
IList <TLADM_WhseStore> WareHouses = null;
IList <TLADM_CustomerFile> Customers = null;
DGVOutput.Visible = false;
using (var context = new TTI2Entities())
{
if (!UserD._External)
{
WareHouses = context.TLADM_WhseStore.Where(x => x.WhStore_WhseOrStore).OrderBy(x => x.WhStore_Description).ToList();
foreach (var WareHouse in WareHouses)
{
cmboWareHouses.Items.Add(new CustomerServices.CheckComboBoxItem(WareHouse.WhStore_Id, WareHouse.WhStore_Description, false));
}
Customers = context.TLADM_CustomerFile.OrderBy(x => x.Cust_Description).ToList();
foreach (var Customer in Customers)
{
cmboCustomers.Items.Add(new CustomerServices.CheckComboBoxItem(Customer.Cust_Pk, Customer.Cust_Description, false));
}
}
else
{
WareHouses = context.TLADM_WhseStore.Where(x => x.WhStore_WhseOrStore && !x.WhStore_RePack && x.WhStore_GradeA).OrderBy(x => x.WhStore_Description).ToList();
foreach (var WareHouse in WareHouses)
{
cmboWareHouses.Items.Add(new CustomerServices.CheckComboBoxItem(WareHouse.WhStore_Id, WareHouse.WhStore_Description, false));
}
var AccessPermitted = context.TLADM_CustomerAccess.Where(x => x.CustAcc_User_Fk == UserD._UserPk).ToList();
foreach (var Access in AccessPermitted)
{
var CustDesc = context.TLADM_CustomerFile.Find(Access.CustAcc_Customer_Fk).Cust_Description;
cmboCustomers.Items.Add(new CustomerServices.CheckComboBoxItem(Access.CustAcc_Customer_Fk, CustDesc, false));
}
}
var Styles = context.TLADM_Styles.OrderBy(x => x.Sty_Description).ToList();
foreach (var Style in Styles)
{
cmboStyles.Items.Add(new CustomerServices.CheckComboBoxItem(Style.Sty_Id, Style.Sty_Description, false));
}
var Sizes = context.TLADM_Sizes.Where(x => (bool)!x.SI_Discontinued).OrderBy(x => x.SI_DisplayOrder).ToList();
foreach (var Size in Sizes)
{
cmboSizes.Items.Add(new CustomerServices.CheckComboBoxItem(Size.SI_id, Size.SI_Description, false));
}
var Colours = context.TLADM_Colours.OrderBy(x => x.Col_Display).ToList();
foreach (var Colour in Colours)
{
cmboColours.Items.Add(new CustomerServices.CheckComboBoxItem(Colour.Col_Id, Colour.Col_Display, false));
}
}
QueryParms = new CustomerServicesParameters();
formloaded = true;
}
private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
Repository repo = new Repository();
CustomerServicesParameters parms = new CustomerServicesParameters();
CSVServices svces = new CSVServices();
int TransNumber = 0;
if (oBtn != null && formloaded)
{
var SelectedTransporter = (TLADM_Transporters)cmboTransporters.SelectedItem;
if (SelectedTransporter == null)
{
MessageBox.Show("Please select a transporter");
return;
}
using (var context = new TTI2Entities())
{
var selected = (TLADM_CustomerFile)cmboCustomers.SelectedItem;
if (selected == null)
{
MessageBox.Show("Please select a customer from the drop down box");
return;
}
parms.Customers.Add(repo.LoadCustomers(selected.Cust_Pk));
var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("CSV")).FirstOrDefault();
if (Dept != null)
{
var LNU = context.TLADM_LastNumberUsed.Where(x => x.LUN_Department_FK == Dept.Dep_Id).FirstOrDefault();
if (LNU != null)
{
TransNumber = LNU.col4;
LNU.col4 += 1;
txtDeliveryNo.Text = "F" + LNU.col4.ToString().PadLeft(5, '0');
}
}
int Fk = 0;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if ((bool)row.Cells[1].Value == false)
{
continue;
}
// Find the record the allocated file
//----------------------------------------------------
var pk = (int)row.Cells[0].Value;
parms.OrdersAllocated.Add(repo.LoadOrderAllocated(pk));
var Allocated = context.TLCSV_OrderAllocated.Find(pk);
if (Allocated != null)
{
Allocated.TLORDA_Delivered = true;
Allocated.TLORDA_DeliveredDate = DateTime.Now;
Allocated.TLORDA_DelTransNumber = TransNumber;
Allocated.TLORDA_Transporter = string.Empty;
Allocated.TLORDA_Transporter_FK = SelectedTransporter.TLTRNS_Pk;
Allocated.TLORDA_PLStockOrder = false;
Fk = (int)row.Cells[6].Value;
var soh = context.TLCSV_StockOnHand.Where(x => x.TLSOH_PickListNo == Fk && !x.TLSOH_Sold).ToList();
foreach (var rec in soh)
{
rec.TLSOH_Sold = true;
rec.TLSOH_SoldDate = DateTime.Now;
rec.TLSOH_Customer_Fk = selected.Cust_Pk;
rec.TLSOH_DNListNo = TransNumber;
rec.TLSOH_DNListDate = DateTime.Now;
var POD = context.TLCSV_PuchaseOrderDetail.Find(rec.TLSOH_POOrderDetail_FK);
if (POD != null)
{
POD.TLCUSTO_Delivered = true;
POD.TLCUSTO_DeliveredDate = DateTime.Now;
POD.TLCUSTO_DeliveryNumber = TransNumber;
POD.TLCUSTO_QtyDelivered_ToDate += rec.TLSOH_BoxedQty;
if (POD.TLCUSTO_Qty - POD.TLCUSTO_QtyDelivered_ToDate <= 0)
{
POD.TLCUSTO_Closed = true;
}
}
}
//Make this a global transaction
//===========================================================
var RePackTransactions = context.TLCSV_RePackTransactions.Where(x => x.REPACT_PurchaseOrder_FK == Allocated.TLORDA_POOrder_FK).ToList();
foreach (var RePackTransaction in RePackTransactions)
{
var RePackConfig = context.TLCSV_RePackConfig.Find(RePackTransaction.REPACT_RePackConfig_FK);
if (RePackConfig != null)
{
RePackConfig.PORConfig_SizeBoxQty_Delivered += RePackTransaction.REPACT_BoxedQty;
}
}
}
}
try
{
context.SaveChanges();
MessageBox.Show("data successfully saved to database");
dataGridView1.Rows.Clear();
cmboCustomers.SelectedValue = -1;
svces.TransNumber = TransNumber;
svces.DateIntoStock = DateTime.Now;
svces.DNReprint = false;
frmCSViewRep vRep = new frmCSViewRep(10, parms, svces);
int h = Screen.PrimaryScreen.WorkingArea.Height;
int w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog(this);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
private void frmStockOnHand_Load(object sender, EventArgs e)
{
IList <TLADM_WhseStore> Whses = null;
formloaded = false;
repo = new Repository();
QueryParms = new CustomerServicesParameters();
if (_OptionNo == 1)
{
this.Text = "Stock quantities on hand";
}
else
{
this.Text = "Boxes in stock";
}
rbGradeA.Checked = true;
using (var context = new TTI2Entities())
{
if (_Ud == null || !_Ud._External)
{
Whses = context.TLADM_WhseStore.Where(x => x.WhStore_WhseOrStore && x.WhStore_GradeA).ToList();
}
else
{
Whses = context.TLADM_WhseStore.Where(x => x.WhStore_WhseOrStore && x.WhStore_GradeA && !x.WhStore_RePack).ToList();
}
foreach (var Whse in Whses)
{
comboWhses.Items.Add(new CustomerServices.CheckComboBoxItem(Whse.WhStore_Id, Whse.WhStore_Description, false));
}
var Styles = context.TLADM_Styles.OrderBy(x => x.Sty_Description).ToList();
foreach (var Style in Styles)
{
comboStyles.Items.Add(new CustomerServices.CheckComboBoxItem(Style.Sty_Id, Style.Sty_Description, false));
}
var Colours = context.TLADM_Colours.OrderBy(x => x.Col_Display).ToList();
foreach (var Colour in Colours)
{
comboColours.Items.Add(new CustomerServices.CheckComboBoxItem(Colour.Col_Id, Colour.Col_Display, false));
}
var Sizes = context.TLADM_Sizes.Where(x => (bool)!x.SI_Discontinued).OrderBy(x => x.SI_DisplayOrder).ToList();
foreach (var Size in Sizes)
{
comboSizes.Items.Add(new CustomerServices.CheckComboBoxItem(Size.SI_id, Size.SI_Description, false));
}
//--------------------------------------------------------
// wire up the check state changed event
//--------------------------------------------------------------------------------------------------------
this.comboWhses.CheckStateChanged += new System.EventHandler(this.cmboWhses_CheckStateChanged);
this.comboStyles.CheckStateChanged += new System.EventHandler(this.cmboStyles_CheckStateChanged);
this.comboColours.CheckStateChanged += new System.EventHandler(this.cmboColours_CheckStateChanged);
this.comboSizes.CheckStateChanged += new System.EventHandler(this.cmboSizes_CheckStateChanged);
}
formloaded = true;
}
private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
TLCSV_OrderAllocated OrderAllocated = null;
Repository repo = new Repository();
CSVServices services = new CSVServices();
shirtParameters = new CustomerServicesParameters();
if (oBtn != null && formloaded)
{
var WareHouse = (TLADM_WhseStore)cmboWareHouse.SelectedItem;
if (WareHouse == null)
{
MessageBox.Show("Please select a warehouse from the drop down box");
return;
}
if (txtCustomerRef.Text.Length == 0)
{
MessageBox.Show("Please enter a customer reference");
return;
}
if (txtReasons.Text.Length == 0)
{
MessageBox.Show("Please enter the reason these goods are being returned");
return;
}
if (txtApprovedBy.Text.Length == 0)
{
MessageBox.Show("Please enter the name of the approver");
return;
}
//----------------------------------------------------------------------------------
using (var context = new TTI2Entities())
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if ((bool)row.Cells[1].Value == false)
{
continue;
}
OrderAllocated = new TLCSV_OrderAllocated();
var Pk = (int)row.Cells[0].Value;
OrderAllocated = context.TLCSV_OrderAllocated.Find(Pk);
if (OrderAllocated != null)
{
OrderAllocated.TLORDA_Returned = true;
OrderAllocated.TLORDA_ReturnCustRef = txtCustomerRef.Text;
OrderAllocated.TLORDA_ApprovedBy = txtApprovedBy.Text;
OrderAllocated.TLORDA_ReturnNumber = TransNumber;
OrderAllocated.TLORDA_ReturnedDate = dtpTransactionDate.Value;
shirtParameters.OrdersAllocated.Add(repo.LoadOrderAllocated(Pk));
}
}
foreach (DataGridViewRow row in dataGridView2.Rows)
{
if ((bool)row.Cells[1].Value == false)
{
continue;
}
var ReSold = (bool)row.Cells[2].Value;
int Pk = (int)row.Cells[0].Value;
var soh = context.TLCSV_StockOnHand.Find(Pk);
if (soh != null)
{
int BoxedQty = (int)row.Cells[7].Value;
soh.TLSOH_ReturnedBoxQty = BoxedQty;
soh.TLSOH_BoxedQty = BoxedQty;
soh.TLSOH_WareHouse_FK = WareHouse.WhStore_Id;
soh.TLSOH_ReturnNumber = TransNumber;
soh.TLSOH_ReturnedDate = dtpTransactionDate.Value;
if (!ReSold)
{
soh.TLSOH_Returned = true;
soh.TLSOH_Grade = "B";
}
else
{
soh.TLSOH_Picked = false;
soh.TLSOH_PickListDate = null;
soh.TLSOH_PickListNo = 0;
soh.TLSOH_Sold = false;
soh.TLSOH_DNListDate = null;
soh.TLSOH_DNListNo = 0;
soh.TLSOH_Grade = "A";
soh.TLSOH_SoldDate = null;
soh.TLSOH_WareHousePickList = 0;
soh.TLSOH_WareHouseDeliveryNo = 0;
}
}
}
try
{
var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("CSV")).FirstOrDefault();
if (Dept != null)
{
var LNU = context.TLADM_LastNumberUsed.Where(x => x.LUN_Department_FK == Dept.Dep_Id).FirstOrDefault();
if (LNU != null)
{
TransNumber = LNU.col5;
LNU.col5 += 1;
}
}
//-------------------------------------------------------
//
//-----------------------------------------------------------
string Mach_IP = Dns.GetHostEntry(Dns.GetHostName())
.AddressList.First(f => f.AddressFamily == AddressFamily.InterNetwork)
.ToString();
TLADM_DailyLog DailyLog = new TLADM_DailyLog();
DailyLog.TLDL_IPAddress = Mach_IP;
DailyLog.TLDL_Dept_Fk = Dept.Dep_Id;
DailyLog.TLDL_Date = DateTime.Now;
DailyLog.TLDL_TransDetail = "Customer Services - Stock Returned";
DailyLog.TLDL_AuthorisedBy = txtApprovedBy.Text;;
DailyLog.TLDL_Comments = txtCustomerRef.Text;
context.TLADM_DailyLog.Add(DailyLog);
context.SaveChanges();
MessageBox.Show("Data successfully saved to the database");
dataGridView1.Rows.Clear();
dataGridView2.Rows.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
services.ApprovedBy = txtApprovedBy.Text;
services.Reasons = txtReasons.Text;
services.ReturnDate = dtpTransactionDate.Value;
services.CustomerRef = txtCustomerRef.Text;
services.WareHouse = WareHouse.WhStore_Id;
frmCSViewRep vRep = new frmCSViewRep(11, shirtParameters, services);
int h = Screen.PrimaryScreen.WorkingArea.Height;
int w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog(this);
frmCustomerReturns_Load(this, null);
}
}
}