private void TbCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.Enter)
{
try
{
GetBoxCode();
var a = dbContext.tbl_BoxSeries.Where(x => x.BoxCode + "-" + x.SeriesNo.ToString() == tbCode.Text.Trim()
).FirstOrDefault();
tbl_BoxSeries tbl = a as tbl_BoxSeries;
tbl.IsIssuedToProduction = false;
tbl.IsIssuedToWareHouse = true;
tbl.IsDelivered = false;
tbl.IsReturned = false;
dbContext.Entry(tbl).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
var dataBox = dbContext.tbl_PartitionSeries.Where(p => p.BoxCode == _boxcodes
&& p.IsUsed == true && p.IsIssuedToProduction == true && p.IsIssuedToWareHouse == false
&& p.IsDelivered == false && p.IsReturned == false && p.IsDisposed == false).Take(_usage).ToList();
//Update partition
dataBox.ForEach(p =>
{
p.IsUsed = true; p.IsIssuedToProduction = false; p.IsIssuedToWareHouse = true;
p.IsDelivered = false; p.IsReturned = false; p.IsDisposed = false;
}
);
dbContext.SaveChanges();
LoadData();
tbCode.Clear();
tbCode.Focus();
}
catch (Exception ex)
{
MessageBox.Show("No Records Found");
}
}
}
private void GetBoxCode()
{
var a = dbContext.tbl_BoxSeries.Where(x => x.BoxCode + "-" + x.SeriesNo.ToString() == tbCode.Text.Trim()).FirstOrDefault();
tbl_BoxSeries tbl = a as tbl_BoxSeries;
_boxcodes = tbl.BoxCode;
var b = dbContext.tbl_BoxMaster.Where(x => x.BoxCode == _boxcodes).FirstOrDefault();
tbl_BoxMaster tbl2 = b as tbl_BoxMaster;
_usage = tbl2.UsagePerBox.GetValueOrDefault();
}
private void Save()
{
if (tbQty.Value <= 0)
{
MessageBox.Show("Enter Quantity");
tbQty.Value = 0;
tbQty.Focus();
}
else if (!recDate.SelectedDate.HasValue)
{
MessageBox.Show("Purchased date is required");
recDate.Focus();
}
else
{
int?maxCount = dbContext.tbl_BoxSeries.Where(p => p.BoxCode == _boxCode).Select(p => p.SeriesNo).DefaultIfEmpty(0).Max();
int count = maxCount.GetValueOrDefault() + 1;
if (maxCount.GetValueOrDefault() == 0)
{
for (int i = count; i <= tbQty.Value; i++)
{
//MessageBox.Show(i.ToString());
tbl_BoxSeries _tb2 = new tbl_BoxSeries()
{
BoxCode = _boxCode,
SeriesNo = i,
IsDisposed = false,
IsUsed = false,
IsDelivered = false,
IsReturned = false,
IsIssuedToProduction = false,
IsIssuedToWareHouse = false,
EncodedBy = _name,
DateEncoded = DateTime.Now
};
dbContext.tbl_BoxSeries.Add(_tb2);
tbl_PurchasedHistory tbldata = new tbl_PurchasedHistory()
{
ItemCode = _boxCode + "-" + i.ToString(),
DatePurchased = recDate.SelectedDate.Value
};
dbContext.tbl_PurchasedHistory.Add(tbldata);
}
dbContext.SaveChanges();
}
else
{
for (int i = maxCount.GetValueOrDefault() + 1; i <= maxCount.GetValueOrDefault() + tbQty.Value; i++)
{
tbl_BoxSeries _tb2 = new tbl_BoxSeries()
{
BoxCode = _boxCode,
SeriesNo = i,
IsDisposed = false,
IsUsed = false,
IsDelivered = false,
IsReturned = false,
IsIssuedToProduction = false,
IsIssuedToWareHouse = false,
EncodedBy = _name,
DateEncoded = DateTime.Now
};
dbContext.tbl_BoxSeries.Add(_tb2);
tbl_PurchasedHistory tbldata = new tbl_PurchasedHistory()
{
ItemCode = _boxCode + "-" + i.ToString(),
DatePurchased = recDate.SelectedDate.Value
};
dbContext.tbl_PurchasedHistory.Add(tbldata);
}
dbContext.SaveChanges();
}
var a = from data in dbContext.tbl_BoxMaster
join boxSeries in dbContext.tbl_BoxSeries on data.BoxCode equals boxSeries.BoxCode
into UP
from boxSeries in UP.DefaultIfEmpty()
where data.BoxCode == _boxCode
orderby boxSeries.SeriesNo
select new
{
BoxCode = data.BoxCode,
SeriesNo = boxSeries.SeriesNo,
IsDisposed = boxSeries.IsDisposed,
IsUsed = boxSeries.IsUsed,
IsIssuedToProduction = boxSeries.IsIssuedToProduction,
IsIssuedToWareHouse = boxSeries.IsIssuedToWareHouse,
IsDelivered = boxSeries.IsDelivered,
IsReturned = boxSeries.IsReturned,
BoxSeriesCode = boxSeries.BoxCode + "-" + boxSeries.SeriesNo
};
string empname = string.Empty;
var empdata = dbHRIS.SKPI_GetAllEmployeesByEmpID(_empID).ToList();
foreach (DataRow dr in ConvertToDataTable(empdata).Rows)
{
empname = dr["FullName_LnameFirst"].ToString();
}
tbl_TransactionMaster transact = new tbl_TransactionMaster()
{
TransactBy = empname,
TransactionDetails = "Encoded New Box Series Quantity",
CreationDateTime = DateTime.Now
};
dbContext.tbl_TransactionMaster.Add(transact);
dbContext.SaveChanges();
MessageBox.Show("Quantity successfully added");
tbQty.Value = 0;
tbQty.Focus();
LoadData();
}
}
private void TbCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.Enter)
{
try
{
bool isexists = dbContext.tbl_BoxSeries.Any(x => x.BoxCode + "-" + x.SeriesNo.ToString() == tbCode.Text.Trim() && x.IsUsed == true && x.IsIssuedToProduction == false &&
x.IsIssuedToWareHouse == false && x.IsDelivered == false && x.IsReturned == false && x.IsDisposed == false);
if (isexists)
{
var a = dbContext.tbl_BoxSeries.Where(x => x.BoxCode + "-" + x.SeriesNo.ToString() == tbCode.Text.Trim()).FirstOrDefault();
tbl_BoxSeries tbl = a as tbl_BoxSeries;
tbl.IsIssuedToProduction = true;
tbl.IsIssuedToWareHouse = false;
tbl.IsDelivered = false;
tbl.IsReturned = false;
dbContext.Entry(tbl).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
string empname = string.Empty;
var empdata = dbHRIS.SKPI_GetAllEmployeesByEmpID(_empID).ToList();
foreach (DataRow dr in ConvertToDataTable(empdata).Rows)
{
empname = dr["FullName_LnameFirst"].ToString();
}
tbl_TransactionMaster transact = new tbl_TransactionMaster()
{
TransactBy = empname,
TransactionDetails = "Issued Item: " + tbCode.Text.Trim(),
CreationDateTime = DateTime.Now
};
dbContext.tbl_TransactionMaster.Add(transact);
dbContext.SaveChanges();
tbCode.Clear();
//tbCode.Focus();
LoadData();
}
else
{
var b = dbContext.tbl_PartitionSeries.Where(x => x.PartitionCode + "-" + x.Part_SeriesNo.ToString() == tbCode.Text.Trim()).FirstOrDefault();
tbl_PartitionSeries tbl = b as tbl_PartitionSeries;
tbl.IsIssuedToProduction = true;
tbl.IsIssuedToWareHouse = false;
tbl.IsDelivered = false;
tbl.IsReturned = false;
dbContext.Entry(tbl).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
string empname = string.Empty;
var empdata = dbHRIS.SKPI_GetAllEmployeesByEmpID(_empID).ToList();
foreach (DataRow dr in ConvertToDataTable(empdata).Rows)
{
empname = dr["FullName_LnameFirst"].ToString();
}
tbl_TransactionMaster transact = new tbl_TransactionMaster()
{
TransactBy = empname,
TransactionDetails = "Issued Item: " + tbCode.Text.Trim(),
CreationDateTime = DateTime.Now
};
dbContext.tbl_TransactionMaster.Add(transact);
dbContext.SaveChanges();
tbCode.Clear();
//tbCode.Focus();
LoadData();
}
}
catch
{
if (gridBox.Items.Count == 0 && gridPartition.Items.Count == 0)
{
divIssuance.IsEnabled = true;
tbCode.Clear();
tbQty.Value = 0;
tbQty.Focus();
}
else
{
divIssuance.IsEnabled = false;
tbQty.Value = 0;
tbCode.Clear();
tbCode.Focus();
}
}
}
}
private void RadButton_Click(object sender, RoutedEventArgs e)
{
MessageBoxResult result = MessageBox.Show("Do you want to continue?", "Confirmation", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
if (!recDate.SelectedDate.HasValue || string.IsNullOrEmpty(tbItemCode.Text))
{
MessageBox.Show("Please complete all fields");
}
else
{
bool isexists = dbContext.tbl_BoxSeries.Any(x => x.BoxCode + "-" + x.SeriesNo.ToString() == tbItemCode.Text.Trim());
if (isexists)
{
var a = dbContext.tbl_BoxSeries.Where(x => x.BoxCode + "-" + x.SeriesNo.ToString() == tbItemCode.Text.Trim()).FirstOrDefault();
tbl_BoxSeries tbl = a as tbl_BoxSeries;
tbl.IsDisposed = true;
tbl.ModifiedBy = _name;
tbl.DateModified = DateTime.Now;
dbContext.Entry(tbl).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
tbl_DisposalHistory dataDisposal = new tbl_DisposalHistory()
{
ItemCode = tbItemCode.Text,
QtyDisposed = 1,
DisposalDate = recDate.SelectedDate.Value,
DisposedBy = _name
};
dbContext.tbl_DisposalHistory.Add(dataDisposal);
dbContext.SaveChanges();
tbl_TransactionMaster transact = new tbl_TransactionMaster()
{
TransactBy = _name,
TransactionDetails = "Disposed Item: " + tbItemCode.Text.Trim(),
CreationDateTime = DateTime.Now
};
dbContext.tbl_TransactionMaster.Add(transact);
dbContext.SaveChanges();
tbItemCode.Clear();
tbItemCode.Focus();
recDate.SelectedDate = DateTime.Now;
}
else
{
var b = dbContext.tbl_PartitionSeries.Where(x => x.PartitionCode + "-" + x.Part_SeriesNo.ToString() == tbItemCode.Text.Trim()).FirstOrDefault();
tbl_PartitionSeries tbl = b as tbl_PartitionSeries;
tbl.IsDisposed = true;
tbl.ModifiedBy = _name;
tbl.DateModified = DateTime.Now;
dbContext.Entry(tbl).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
tbl_DisposalHistory dataDisposal = new tbl_DisposalHistory()
{
ItemCode = tbItemCode.Text,
QtyDisposed = 1,
DisposalDate = recDate.SelectedDate.Value,
DisposedBy = _name
};
dbContext.tbl_DisposalHistory.Add(dataDisposal);
dbContext.SaveChanges();
tbl_TransactionMaster transact = new tbl_TransactionMaster()
{
TransactBy = _name,
TransactionDetails = "Disposed Item: " + tbItemCode.Text.Trim(),
CreationDateTime = DateTime.Now
};
dbContext.tbl_TransactionMaster.Add(transact);
dbContext.SaveChanges();
tbItemCode.Clear();
tbItemCode.Focus();
recDate.SelectedDate = DateTime.Now;
}
}
}
else
{
recDate.Focus();
}
}
private void TbCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.Enter)
{
try
{
if (stat == false)
{
GetBoxCode();
var a = dbContext.tbl_BoxSeries.Where(x => x.BoxCode + "-" + x.SeriesNo.ToString() == tbCode.Text.Trim()
).FirstOrDefault();
tbl_BoxSeries tbl = a as tbl_BoxSeries;
tbl.IsIssuedToProduction = false;
tbl.IsIssuedToWareHouse = false;
tbl.IsDelivered = true;
tbl.IsReturned = false;
dbContext.Entry(tbl).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
var dataBox = dbContext.tbl_PartitionSeries.Where(p => p.BoxCode == _boxcodes
&& p.IsUsed == true && p.IsIssuedToProduction == false && p.IsIssuedToWareHouse == true
&& p.IsDelivered == false && p.IsReturned == false && p.IsDisposed == false).Take(_usage).ToList();
//Update data
dataBox.ForEach(p =>
{
p.IsUsed = true; p.IsIssuedToProduction = false; p.IsIssuedToWareHouse = false;
p.IsDelivered = true; p.IsReturned = false; p.IsDisposed = false;
}
);
dbContext.SaveChanges();
tbl_TransactionMaster transact = new tbl_TransactionMaster()
{
TransactBy = _name,
TransactionDetails = "Delivered Item: " + tbCode.Text.Trim(),
CreationDateTime = DateTime.Now
};
dbContext.tbl_TransactionMaster.Add(transact);
dbContext.SaveChanges();
LoadData();
tbCode.Clear();
tbCode.Focus();
}
else
{
bool isexists = dbContext.tbl_BoxSeries.Any(x => x.BoxCode + "-" + x.SeriesNo.ToString() == tbCode.Text.Trim());
if (isexists)
{
var a = dbContext.tbl_BoxSeries.Where(x => x.BoxCode + "-" + x.SeriesNo.ToString() == tbCode.Text.Trim()).FirstOrDefault();
tbl_BoxSeries tbl = a as tbl_BoxSeries;
tbl.IsIssuedToProduction = false;
tbl.IsIssuedToWareHouse = false;
tbl.IsDelivered = false;
tbl.IsReturned = false;
tbl.IsUsed = false;
dbContext.Entry(tbl).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
tbl_TransactionMaster transact = new tbl_TransactionMaster()
{
TransactBy = _name,
TransactionDetails = "Received Item: " + tbCode.Text.Trim(),
CreationDateTime = DateTime.Now
};
dbContext.tbl_TransactionMaster.Add(transact);
dbContext.SaveChanges();
tbCode.Clear();
tbCode.Focus();
LoadData();
}
else
{
var b = dbContext.tbl_PartitionSeries.Where(x => x.PartitionCode + "-" + x.Part_SeriesNo.ToString() == tbCode.Text.Trim()).FirstOrDefault();
tbl_PartitionSeries tbl = b as tbl_PartitionSeries;
tbl.IsIssuedToProduction = false;
tbl.IsIssuedToWareHouse = false;
tbl.IsDelivered = false;
tbl.IsReturned = false;
tbl.IsUsed = false;
dbContext.Entry(tbl).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
tbl_TransactionMaster transact = new tbl_TransactionMaster()
{
TransactBy = _name,
TransactionDetails = "Received Item: " + tbCode.Text.Trim(),
CreationDateTime = DateTime.Now
};
dbContext.tbl_TransactionMaster.Add(transact);
dbContext.SaveChanges();
tbCode.Clear();
tbCode.Focus();
LoadData();
}
}
}
catch (Exception ex)
{
MessageBox.Show("No Records Found");
}
}
}
