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 Boolean Save()
{
Boolean _isValid = false;
_isValid = _isValidFields();
if (!_isValid)
{
return(false);
}
int?maxCount = dbContext.tbl_PartitionSeries.Where(p => p.BoxCode == _boxCode && p.PartitionCode == _partCode.Trim()).Select(p => p.Part_SeriesNo).DefaultIfEmpty(0).Max();
int count = maxCount.GetValueOrDefault() + 1;
if (maxCount.GetValueOrDefault() == 0)
{
for (int i = count; i <= tbQty.Value; i++)
{
tbl_PartitionSeries _tb2 = new tbl_PartitionSeries()
{
BoxCode = _boxCode,
PartitionCode = _partCode,
Part_SeriesNo = i,
IsDisposed = false,
IsUsed = false,
IsDelivered = false,
IsReturned = false,
IsIssuedToProduction = false,
IsIssuedToWareHouse = false,
EncodedBy = _name,
DateEncoded = DateTime.Now
};
dbContext.tbl_PartitionSeries.Add(_tb2);
tbl_PurchasedHistory tbldata = new tbl_PurchasedHistory()
{
ItemCode = _partCode + "-" + 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_PartitionSeries _tb2 = new tbl_PartitionSeries()
{
BoxCode = _boxCode,
PartitionCode = _partCode,
Part_SeriesNo = i,
IsDisposed = false,
IsUsed = false,
IsDelivered = false,
IsReturned = false,
IsIssuedToProduction = false,
IsIssuedToWareHouse = false,
EncodedBy = _name,
DateEncoded = DateTime.Now
};
dbContext.tbl_PartitionSeries.Add(_tb2);
tbl_PurchasedHistory tbldata = new tbl_PurchasedHistory()
{
ItemCode = _partCode + "-" + i.ToString(),
DatePurchased = recDate.SelectedDate.Value
};
dbContext.tbl_PurchasedHistory.Add(tbldata);
}
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 = "Encoded New Partition Series Quantity",
CreationDateTime = DateTime.Now
};
dbContext.tbl_TransactionMaster.Add(transact);
dbContext.SaveChanges();
MessageBox.Show("Quantity successfully added");
tbQty.Value = 0;
tbQty.Focus();
LoadPartitionSeries();
return(true);
}
