private void mnuDeleteAll_Click(object sender, EventArgs e)
{
CompactSQL comsql = new CompactSQL();
comsql.deleteRecord("StockTakeEntry");
this.Close();
StockTake st = new StockTake(uname, staffdim, ulevel);
st.Show();
}
private void ImportXMLToSQL()
{
Cursor.Current = Cursors.WaitCursor;
try
{
CompactSQL comsql = new CompactSQL();
string ApplicationPath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().GetName().CodeBase);
ApplicationPath = ApplicationPath + "\\Stocktake.xml";
if (File.Exists(ApplicationPath))
{
var result = MessageBox.Show("Are you sure to replace current data?", "Confirmation",
MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
if (result == DialogResult.Yes)
{
comsql.deleteRecord("StockTakeEntry");
//XMl to SQL
DataSet ds = new DataSet();
ds.ReadXml(ApplicationPath);
foreach (DataRow dRow in ds.Tables[0].Rows)
{
object[] array = new object[7];
array[0] = dRow["ItemNo"].ToString();
array[1] = dRow["BinCode"].ToString();
array[2] = dRow["Quantity"].ToString();
array[3] = dRow["PostDate"].ToString();
array[4] = dRow["StaffName"].ToString();
array[5] = dRow["Category"].ToString();
array[6] = dRow["Loc"].ToString();
dt.Rows.Add(array);
comsql.InsertRecord("StockTakeEntry", array);
}
// this.Close();
MessageBox.Show("Restore Successfully");
StockTake St = new StockTake(uname, staffdim, ulevel);
St.Show();
}
}
else
{
MessageBox.Show("Nothing to restore data");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
Cursor.Current = Cursors.Default;
}
private void menuItem1_Click(object sender, EventArgs e)
{
if (GrdDailyLoss == null)
{
MessageBox.Show("There is no record to register!");
}
else
{
Cursor.Current = Cursors.WaitCursor;
try
{
decimal countotal = 0;
bool flagtemp = false;
string itemtemp;
string locationtemp;
string bincodetemp;
ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service dlservice = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service();
dlservice.Url = WebServiceInstants.GetURL(ServiceType.ItemJournalDailyLossQH);
dlservice.Credentials = nc;
QHSalesReceivableSetup.QHSalesReceivableSetup_Service qhsalesev = new QHMobile.QHSalesReceivableSetup.QHSalesReceivableSetup_Service();
qhsalesev.Credentials = nc;
qhsalesev.Url = WebServiceInstants.GetURL(ServiceType.QHSalesReceivableSetup);
QHSalesReceivableSetup.QHSalesReceivableSetup[] qhsaleGet = qhsalesev.ReadMultiple(null, null, 0);
for (int i = 0; i < dl_array.Count; i++)
{
ItemJournalDailyLossQH.ItemJournalDailyLossQH dl = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH();
dlservice.Create(qhsaleGet[0].Change_Size_Batch, ref dl); // Actual value should be DOA
dl.Posting_Date = DateTime.Now;
if (dl_array[i].entrytype.Equals("Positive Adjmt."))
{
dl.Entry_Type = ItemJournalDailyLossQH.Entry_Type.Positive_Adjmt;
}
else if (dl_array[i].entrytype.Equals("Negative Adjmt."))
{
dl.Entry_Type = ItemJournalDailyLossQH.Entry_Type.Negative_Adjmt;
}
dl.Entry_TypeSpecified = true;
dl.Item_No = dl_array[i].itemno;
dl.Quantity = Convert.ToInt32(dl_array[i].quantity);
dl.Location_Code = dl_array[i].location;
//dl.Posting_Date = dl_array[i].postdate;
dl.Staff_Dimension_Code = staffdim;
dl.Bin_Code = dl_array[i].bincode;
dlservice.Update(qhsaleGet[0].Change_Size_Batch, ref dl);
}
//// to adjust ////
ArrayList tnk = new ArrayList();
for (int i = 0; i < dl_array.Count; i++)
{
if ((dl_array[i].EmptyTank == true) && (dl_array[i].entrytype.Equals("Negative Adjmt.")))
{
if (i == 0)
{
tnk.Add(dl_array[i].bincode);
}
else
{
if (!tnk.Contains(dl_array[i].bincode))
{
tnk.Add(dl_array[i].bincode);
}
}
}
}
for (int j = 0; j < tnk.Count; j++)
{
countotal = 0;
flagtemp = false;
itemtemp = "";
locationtemp = "";
bincodetemp = "";
for (int k = 0; k < dl_array.Count; k++)
{
if ((dl_array[k].EmptyTank == true) && (dl_array[k].entrytype.Equals("Negative Adjmt.")))
{
if (tnk[j].ToString().Equals(dl_array[k].bincode))
{
itemtemp = dl_array[k].itemno;
countotal = countotal + Convert.ToDecimal(dl_array[k].quantity);
locationtemp = dl_array[k].location;
bincodetemp = dl_array[k].bincode;
if (dl_array[k].EmptyTank == true)
{
flagtemp = true;
}
}
}
}
//QHBinContent.QHBinContent_Service qhsev = new QHMobile.QHBinContent.QHBinContent_Service();
//qhsev.Credentials = nc;
//qhsev.Url = WebServiceInstants.GetURL(ServiceType.QHBinContent);
//List<QHBinContent.QHBinContent_Filter> filterArr = new List<QHMobile.QHBinContent.QHBinContent_Filter>();
//QHBinContent.QHBinContent_Filter binfilter = new QHMobile.QHBinContent.QHBinContent_Filter();
//binfilter.Field = QHMobile.QHBinContent.QHBinContent_Fields.Bin_Code;
//binfilter.Criteria = bincodetemp;
////QHBinContent.QHBinContent_Filter Qtyfilter = new QHMobile.QHBinContent.QHBinContent_Filter();
////Qtyfilter.Field = QHMobile.QHBinContent.QHBinContent_Fields.Quantity_Base;
////Qtyfilter.Criteria = "<>0";
//QHBinContent.QHBinContent_Filter itemFilter = new QHMobile.QHBinContent.QHBinContent_Filter();
//itemFilter.Field = QHMobile.QHBinContent.QHBinContent_Fields.Item_No;
//itemFilter.Criteria = itemtemp;
//filterArr.Add(binfilter);
////filterArr.Add(Qtyfilter);
//filterArr.Add(itemFilter);
//QHBinContent.QHBinContent[] qhbincon = qhsev.ReadMultiple(filterArr.ToArray(), null, 5);
if (flagtemp == true) //qhbincon[0].Quantity_Base < countotal ||
{
// qhfun.TankAdj_NAV(itemtemp, packworksheet, locationtemp, bincodetemp, countotal, flagtemp);
//qhfun.TankAdj_NAV(itemtemp, packworksheet, locationtemp, bincodetemp, countotal);
QHEmptyTank.QHEmptyTank_Service qhempty = new QHMobile.QHEmptyTank.QHEmptyTank_Service();
qhempty.Url = WebServiceInstants.GetURL(ServiceType.QHEmptyTank);
qhempty.Credentials = nc;
QHEmptyTank.QHEmptyTank qhcheck = qhempty.Read(bincodetemp);
if (qhcheck == null)
{
QHEmptyTank.QHEmptyTank qhtnk = new QHMobile.QHEmptyTank.QHEmptyTank();
qhtnk.Bin_Code = bincodetemp;
qhempty.Create(ref qhtnk);
qhtnk.Batch_Name = qhsaleGet[0].Change_Size_Batch;
qhtnk.Item_No = itemtemp;
qhtnk.Location_Code = locationtemp;
qhempty.Update(ref qhtnk);
}
}
//else if (qhbincon[0].Quantity - qhbincon[0].PDA_Inv_Pick_Quantity < countotal)
//{
// QH_Functions.QH_Functions qhfun = new QHMobile.QH_Functions.QH_Functions();
// qhfun.Url = WebServiceInstants.GetURL(ServiceType.QH_Functions);
// qhfun.Credentials = nc;
// decimal updatecount = countotal - (qhbincon[0].Quantity - qhbincon[0].PDA_Inv_Pick_Quantity);
// qhfun.InsertIJLPositiveAdjustment(itemtemp, "", locationtemp, bincodetemp, updatecount);
// //qhfun.TankAdj_NAV(itemtemp, "", locationtemp, bincodetemp, countotal, flagtemp);
//}
}
//// to adjust ////
CompactSQL comsql = new CompactSQL();
comsql.deleteRecord("ChangeSize");
MessageBox.Show("Submitted.");
this.Close();
DailyLossTS dilts = new DailyLossTS(staffname, staffdim, stafflevel);
dilts.Show();
}
catch (Exception ex)
{
MessageBox.Show("Error:" + ex);
}
Cursor.Current = Cursors.Default;
//DailyLossTS dts = new DailyLossTS(staffname, staffdim, stafflevel);
}
}
private void mnuRegisterToNav_Click(object sender, EventArgs e)
{
try
{
if (GrdPO.DataSource != null)
{
Cursor.Current = Cursors.WaitCursor;
PurchaseQH.PurchaseQH_Service purSev = new QHMobile.PurchaseQH.PurchaseQH_Service();
purSev.Credentials = nc;
purSev.Url = WebServiceInstants.GetURL(ServiceType.PurchaseQH);
PurchaseQH.PurchaseQH phcreate = new QHMobile.PurchaseQH.PurchaseQH();
purSev.Create(ref phcreate);
PO = phcreate.No;
PurchaseQH.PurchaseQH phupdate = purSev.Read(phcreate.No);
phupdate.Buy_from_Vendor_No = txtVendorNo.Text.Trim();
phupdate.Buy_from_Vendor_Name = txtVendorName.Text.Trim();
phupdate.Order_Date = DateTime.Now;
purSev.Update(ref phupdate);
phupdate.PurchLines = new QHMobile.PurchaseQH.Purchase_Order_Line[PoArray.Count];
for (int i = 0; i < PoArray.Count; i++)
{
phupdate.PurchLines[i] = new QHMobile.PurchaseQH.Purchase_Order_Line();
}
purSev.Update(ref phupdate);
for (int j = 0; j < phupdate.PurchLines.Length; j++)
{
phupdate.PurchLines[j].Type = QHMobile.PurchaseQH.Type.Item;
phupdate.PurchLines[j].No = PoArray[j].itemno;
phupdate.PurchLines[j].Location_Code = PoArray[j].location;
phupdate.PurchLines[j].Quantity = Convert.ToInt32(PoArray[j].quantity);
phupdate.PurchLines[j].Bin_Code = "";
}
purSev.Update(ref phupdate);
lblPO.Text = "PO:" + phupdate.No;
if (!String.IsNullOrEmpty(phupdate.No))
{
QH_Functions.QH_Functions qhfun = new QHMobile.QH_Functions.QH_Functions();
qhfun.Credentials = nc;
qhfun.Url = WebServiceInstants.GetURL(ServiceType.QH_Functions);
//qhfun.ReleasePO(PO);
qhfun.ReleasePO(phupdate.No.Trim());
MessageBox.Show("Purchase Order is created succesfully!" + phupdate.No);
CompactSQL comsql = new CompactSQL();
comsql.deleteRecord("PurchaseOrder");
PurChaseOrder po = new PurChaseOrder(vuser, vstaffdimension, vstafflevel);
po.Show();
}
Cursor.Current = Cursors.Default;
}
else
{
MessageBox.Show("There is no line to post!");
}
}
catch (Exception ex)
{
MessageBox.Show("Error:" + ex);
}
}
private void MnuNewGRN_Click(object sender, EventArgs e)
{
try
{
if (dgGRNLine.DataSource == null)
{
MessageBox.Show("Please scan the item first!");
}
else
{
Cursor.Current = Cursors.WaitCursor;
try
{
qhStockTakeWS.StockTakeWS_Service qhserv = new QHMobile.qhStockTakeWS.StockTakeWS_Service();
qhserv.Url = WebServiceInstants.GetURL(ServiceType.StockTakeWS);
qhserv.Credentials = nc;
CurrencyManager cm = (CurrencyManager)this.BindingContext[dgGRNLine.DataSource];
DataView dv = (DataView)cm.List;
//qhStockTakeWS.StockTakeWS[] stock_list = new qhStockTakeWS.StockTakeWS[stmod.Count];
qhStockTakeWS.StockTakeWS[] stock_list = new qhStockTakeWS.StockTakeWS[dv.Count];
//qhStockTakeWS.StockTakeWS[] stock_all = qhserv.ReadMultiple(null, null, 0);
//linecount = stock_all.Count();
QH_Functions.QH_Functions qhfun = new QHMobile.QH_Functions.QH_Functions();
qhfun.Url = WebServiceInstants.GetURL(ServiceType.QH_Functions);
qhfun.Credentials = nc;
for (int i = 0; i < dv.Count; i++)
{
qhStockTakeWS.StockTakeWS updatestock = new QHMobile.qhStockTakeWS.StockTakeWS();
updatestock.Stock_take_Code = "1";
updatestock.Item_No = stmod[i].ItemNo;
//updatestock.Item_No = dgGRNLine[i, 0].ToString();
// updatestock.Line_NoSpecified = true;
//linecount = qhfun.GetStockTakeLastLineNo();
// linecount = ++linecount;
//updatestock.Line_No = linecount;
updatestock.BinCode = stmod[i].binNo;
//updatestock.BinCode = dgGRNLine[i, 1].ToString();
updatestock.Stock_take_QuantitySpecified = true;
updatestock.Stock_take_Quantity = stmod[i].qty;
//updatestock.Stock_take_Quantity = Convert.ToInt32(dgGRNLine[i, 2].ToString());
updatestock.Stock_take_DateSpecified = true;
updatestock.Stock_take_Date = stmod[i].postDate;
//updatestock.Stock_take_Date = Convert.ToDateTime(dgGRNLine[i, 3].ToString());
updatestock.Staff_Dimension_Code = staffdim;
//updatestock.Staff_Dimension_Code = dgGRNLine[i, 4].ToString();
updatestock.Entry_DateSpecified = true;
updatestock.Entry_Date = stmod[i].entryDate;
//updatestock.Entry_Date = Convert.ToDateTime(dgGRNLine[i, 5].ToString());
updatestock.Registered_DateSpecified = true;
updatestock.Registered_Date = stmod[i].entryDate;
//updatestock.Registered_Date = Convert.ToDateTime(dgGRNLine[i, 5].ToString());
updatestock.Message = "Items not in Phys. Invty Jnl";
if (string.IsNullOrEmpty(txtLocation.Text.ToString()))
{
updatestock.Location_Code = "QH1";
}
else
{
updatestock.Location_Code = txtLocation.Text.ToString();
}
updatestock.Category = stmod[i].category;
//updatestock.Category = dgGRNLine[i, 6].ToString();
updatestock.Skip_Auto_NumberSpecified = false;
updatestock.Skip_Auto_Number = false;
qhserv.Create(ref updatestock);
//stock_list[i] = updatestock;
}
//qhserv.CreateMultiple(ref stock_list);
CompactSQL comsql = new CompactSQL();
comsql.deleteRecord("StockTakeEntry");
Cursor.Current = Cursors.Default;
MessageBox.Show("Submitted!");
this.Close();
StockTake st = new StockTake(uname, staffdim, ulevel);
st.Show();
}
catch (Exception ex)
{
Cursor.Current = Cursors.Default;
MessageBox.Show("Error" + ex);
}
}
}catch (Exception ex)
{
MessageBox.Show("Error" + ex);
}
}
private void menuItem2_Click(object sender, EventArgs e)
{
if (GrdTO == null)
{
MessageBox.Show("There is no record to register!");
}
else
{
Cursor.Current = Cursors.WaitCursor;
try
{
ItemJournalQH.ItemJournalQH_Service journalService = new QHMobile.ItemJournalQH.ItemJournalQH_Service();
journalService.Url = WebServiceInstants.GetURL(ServiceType.ItemJournalQH);
journalService.Credentials = nc;
for (int i = 0; i < journalarray.Count; i++)
{
ItemJournalQH.ItemJournalQH journal = new QHMobile.ItemJournalQH.ItemJournalQH();
journalService.Create("DEFAULT", ref journal);
journal.Document_Date = journalarray[i].postingDate;
journal.Document_DateSpecified = true;
journal.Posting_Date = journalarray[i].postingDate;
journalService.Update("DEFAULT", ref journal);
journal.Item_No = journalarray[i].ItemNo;
journal.Location_Code = journalarray[i].location;
journal.Bin_Code = journalarray[i].frombin;
journal.New_Location_Code = journalarray[i].location;
journal.New_Bin_Code = journalarray[i].tobin;
journal.Quantity = journalarray[i].quantity;
journal.Staff_Dimension_Code = journalarray[i].staffdimension;
journalService.Update("DEFAULT", ref journal);
}
ArrayList tnk = new ArrayList();
for (int i = 0; i < journalarray.Count; i++)
{
if (i == 0)
{
tnk.Add(journalarray[i].frombin);
}
else
{
if (!tnk.Contains(journalarray[i].frombin))
{
tnk.Add(journalarray[i].frombin);
}
}
}
decimal countotal = 0;
bool flagtemp = false;
string itemtemp;
string locationtemp;
string bincodetemp;
for (int j = 0; j < tnk.Count; j++)
{
countotal = 0;
flagtemp = false;
itemtemp = "";
locationtemp = "";
bincodetemp = "";
for (int k = 0; k < journalarray.Count; k++)
{
if (tnk[j].ToString().Equals(journalarray[k].frombin))
{
itemtemp = journalarray[k].ItemNo;
countotal = countotal + Convert.ToDecimal(journalarray[k].quantity);
locationtemp = journalarray[k].location;
bincodetemp = journalarray[k].frombin;
if (journalarray[k].emptyBin == true)
{
flagtemp = true;
}
}
}
if (flagtemp == true) //qhbincon[0].Quantity_Base < countotal ||
{
QHEmptyTank.QHEmptyTank_Service qhempty = new QHMobile.QHEmptyTank.QHEmptyTank_Service();
qhempty.Url = WebServiceInstants.GetURL(ServiceType.QHEmptyTank);
qhempty.Credentials = nc;
QHEmptyTank.QHEmptyTank qhcheck = qhempty.Read(bincodetemp);
if (qhcheck == null)
{
QHEmptyTank.QHEmptyTank qhtnk = new QHMobile.QHEmptyTank.QHEmptyTank();
qhtnk.Bin_Code = bincodetemp;
qhempty.Create(ref qhtnk);
qhtnk.Batch_Name = "IReclass";
qhtnk.Item_No = itemtemp;
qhtnk.Location_Code = locationtemp;
qhempty.Update(ref qhtnk);
}
}
}
CompactSQL comsql = new CompactSQL();
comsql.deleteRecord("ItemReclass");
MessageBox.Show("Submitted to Journal.");
TransferOrder tro = new TransferOrder(staffname, staffdimension, stafflevel);
tro.Show();
GrdTO.DataSource = null;
Cursor.Current = Cursors.Default;
}
catch (Exception ex)
{
MessageBox.Show("Eorror:" + ex);
}
Cursor.Current = Cursors.Default;
}
}