public void getSERSHeader()
{
DBConnection dbCon = new DBConnection();
cMySQLCommands oMySQLCommand = new cMySQLCommands();
MySqlDataReader reader;
oMySQLCommand._fields = "";
oMySQLCommand._tblName = " sers_tran ";
oMySQLCommand._condition = " sers_tran.rsh_no = '" + _sersno + "'";
reader = oMySQLCommand.selectQueryWhere();
if (reader.HasRows)
{
while (reader.Read())
{
_dateRequested = reader.GetString(3);
_dateNeeded = reader.GetString(4);
_loccode = reader.GetString(5);
_deptcode = reader.GetString(6);
_datestamp = reader.GetString(7);
_status = reader.GetString(8);
_uid = reader.GetString(9);
_remarks = reader.GetString(10);
_sersType = reader.GetString(22);
_noOfCopies = reader.GetString(25);
_approvedBy = reader.GetString(35);
}
}
}
//used to return attachments included from the supplier
//in the quotation transaction. Query is based on
//transaction number and supplier
public List <cAttachment> loadSupQuoteAttachment(string transno, string supcd, string loccd)
{
List <cAttachment> cAttachGetList = new List <cAttachment>();
cMySQLCommands mySqlCom = new cMySQLCommands();
MySqlDataReader reader;
mySqlCom._tblName = "attachments";
_transtype = "Quotation";
_transno = transno;
_supcd = supcd;
_loccd = loccd;
mySqlCom.addFields("transno");
mySqlCom.addFields("sup_code");
mySqlCom.addFields("filename");
mySqlCom._condition = "transno = '" + transno + "' and sup_code ='" + supcd + "' and loc_code = '" + _loccd + "'";
reader = mySqlCom.selectQueryWhere();
if (reader.HasRows)
{
while (reader.Read())
{
cAttachGetList.Add(new cAttachment
{
_Code = reader.GetString(0),
_supcd = reader.GetString(1),
_attachmentName = reader.GetString(2),
});
}
}
return(cAttachGetList);
}
public void getPOCurrency()
{
DBConnection dbCon = new DBConnection( );
cMySQLCommands oMySQLCommand = new cMySQLCommands();
MySqlDataReader reader;
oMySQLCommand._fields = "";
oMySQLCommand._tblName = "spo_currency";
//oMySQLCommand._condition = " spo_currency.poc_no = " + _pocno;
oMySQLCommand._condition = " spo_currency.ers_no = '" + _pocersno + "' and spo_currency.loc_code = '" + _pocLocCode + "'";
reader = oMySQLCommand.selectQueryWhere();
if (reader.HasRows)
{
while (reader.Read())
{
_pocdate = reader.GetString(3);
_curCode = reader.GetString(4);
_curname = reader.GetString(5);
_curVal = reader.GetString(6);
_remarks = reader.GetString(7);
_pocPrepBy = reader.GetString(8);
_pocConfirm = reader.GetString(9);
_pocLocCode = reader.GetString(10);
}
}
}
public void setLocationConfig()
{
cMySQLCommands oMySQLCommands = new cMySQLCommands();
MySqlDataReader reader;
oMySQLCommands._fields = "";
oMySQLCommands._tblName = " locationconfig ";
oMySQLCommands._condition = " loc_code = '" + _LocCode + "'";
reader = oMySQLCommands.selectQueryWhere();
if (reader.HasRows)
{
while (reader.Read())
{
_Database = reader.GetString(2);
_Masterfile = reader.GetString(3);
_CNVPICT = reader.GetString(4);
_SERVER = reader.GetString(5);
_DOMAIN = reader.GetString(6);
_DBFUSER = reader.GetString(7);
_DBFPASS = reader.GetString(8);
_DBNAME = reader.GetString(9);
_DBUSER = reader.GetString(10);
_DBPASS = reader.GetString(11);
_SELLOCCODE = reader.GetString(12);
_SERVERLOC = reader.GetString(13);
}
}
}
public MySqlDataReader getQuoteSupplierERS()
{
cMySQLCommands cMySQLCom = new cMySQLCommands();
MySqlDataReader reader;
cMySQLCom.addFields("quote_supplier.sup_code");
cMySQLCom.addFields("supplier.sup_extype");
cMySQLCom.addFields("supplier.sup_active");
cMySQLCom.addFields("quote_supplier.discount1");
cMySQLCom.addFields("quote_supplier.discount2");
cMySQLCom.addFields("quote_supplier.discount3");
cMySQLCom.addFields("quote_supplier.discount4");
cMySQLCom.addFields("quote_supplier.special");
cMySQLCom.addFields("quote_supplier.vat");
cMySQLCom.addFields("quote_supplier.freight");
cMySQLCom.addFields("quote_supplier.othercharges");
cMySQLCom.addFields("quote_supplier.netamt");
cMySQLCom._tblName = " quote_supplier ";
cMySQLCom._innerTableName = " supplier ";
cMySQLCom._innerLeftOn = " quote_supplier.sup_code ";
cMySQLCom._innerRightOn = " supplier.sup_code ";
cMySQLCom._condition = " quote_supplier.quote_no = '" + _quoteno + "' and quote_supplier.selected = True and quote_supplier.quote_loccd = '" + _locCode + "'";
reader = cMySQLCom.innerSelectQueryWhere();
return(reader);
}
public List <cCurrencyValue> getCurrencyList()
{
cMySQLCommands cMySQLCom = new cMySQLCommands();
List <cCurrencyValue> oCurrencyList = new List <cCurrencyValue>();
MySqlDataReader reader;
cMySQLCom.addFields("quote_currency.cur_isoCode");
cMySQLCom.addFields("currency.cur_name");
cMySQLCom.addFields("quote_currency.cur_value");
cMySQLCom.addFields("quote_currency.selected");
cMySQLCom._tblName = "quote_currency";
cMySQLCom._innerTableName = "currency";
cMySQLCom._innerLeftOn = "quote_currency.cur_isoCode";
cMySQLCom._innerRightOn = "currency.cur_isocode";
reader = cMySQLCom.innerSelectQuery();
if (reader.HasRows)
{
while (reader.Read())
{
oCurrencyList.Add(new cCurrencyValue
{
_currIsoCode = reader.GetString(0),
_currName = reader.GetString(1),
_currExchange = reader.GetDouble(2),
_selected = reader.GetString(3)
});
}
}
return(oCurrencyList);
}
public MySqlDataReader getQuoteLineERS()
{
MySqlDataReader reader;
//DBConnection dbcon = new DBConnection();
//edited to fix bugs unselected items included in ers
cMySQLCommands cMySQLCom = new cMySQLCommands();
cMySQLCom.addFields("quote_line.itm_code");
cMySQLCom.addFields("quote_line.itm_qty");
cMySQLCom.addFields("quote_line.itm_uom");
cMySQLCom.addFields("quote_line.itm_cost");
cMySQLCom.addFields("(quote_line.itm_cost * quote_line.itm_qty) AS itm_amt");
cMySQLCom.addFields("quote_line.itm_disc");
cMySQLCom.addFields("quote_line.itm_net");
cMySQLCom.addFields("item_mst.itm_specs");
cMySQLCom._tblName = "quote_line";
cMySQLCom._innerTableName = "item_mst";
cMySQLCom._innerLeftOn = "quote_line.itm_code";
cMySQLCom._innerRightOn = "item_mst.itm_code";
//added quote _quote no due to varchar
cMySQLCom._condition = " quote_line.quote_no = '" + _quoteno + "' and quote_line.selected = 'True' and " +
"quote_line.quote_loccd = '" + _locCode + "'";
reader = cMySQLCom.innerSelectQueryWhere();
return(reader);
}
//retrieves the department details based on the current
//company code provided and sets the details on the properties
public void setDepartmentDetails()
{
cMySQLCommands osetDeptDetails = new cMySQLCommands();
MySqlDataReader reader;
osetDeptDetails._fields = "";
osetDeptDetails._tblName = "company";
osetDeptDetails._condition = "company.com_code='" + _code + "'";
reader = osetDeptDetails.selectQueryWhere();
if (reader.HasRows)
{
while (reader.Read())
{
_code = reader.GetString(1);
_name = reader.GetString(2);
_locCode = reader.GetString(3);
_navdeptcd = reader.GetString(4);
_navdeptyp = reader.GetString(5);
_comprccd = reader.GetString(6);
_comhead1 = reader.GetString(7);
_comhead2 = reader.GetString(8);
_comaddr = reader.GetString(9);
_comtelno = reader.GetString(10);
_comuseg = reader.GetString(11);
_comconper = reader.GetString(12);
_commobil = reader.GetString(13);
_comemail = reader.GetString(14);
_comuser = reader.GetString(15);
_comdupdat = reader.GetString(16);
_comfad = reader.GetString(17);
}
}
}
//same as savetotable function but the only difference is the query
//removes all existing attachments related to the transaction no and transaction type
//and adds all attachments included
public void edittotable(string transno, string transtype, List <cAttachment> cAttachList)
{
//remove all transaction entries first
cMySQLCommands mySqlCom = new cMySQLCommands();
cMySQLCommands mySqlDel = new cMySQLCommands();
mySqlDel._tblName = "attachments";
mySqlDel._condition = " transno = '" + transno + "' and transtype = '" + transtype + "' and loc_code = '" + selLocCode + "'";
mySqlDel.deleteQuery();
mySqlCom._tblName = "attachments";
mySqlCom.addFields("transno");
mySqlCom.addFields("transtype");
mySqlCom.addFields("sup_code");
mySqlCom.addFields("filename");
mySqlCom.addFields("loc_code");
//adds attachment values per entry in list
foreach (cAttachment cAttach in cAttachList)
{
mySqlCom._values = "";
mySqlCom.addValues(transno);
mySqlCom.addValues(transtype);
mySqlCom.addValues(cAttach._supcd);
mySqlCom.addValues(Path.GetFileName(cAttach._attachmentName));
mySqlCom.addValues(cAttach._loccd);
copyToCNVPICT(cAttach._attachmentName);
mySqlCom.insertQuery();
}
}
public MySqlDataReader getQuoteLine()
{
cMySQLCommands cMySQLCom = new cMySQLCommands();
MySqlDataReader reader;
cMySQLCom.addFields("quote_line.itm_code");
cMySQLCom.addFields("quote_line.itm_qty");
cMySQLCom.addFields("quote_line.itm_uom");
cMySQLCom.addFields("quote_line.itm_cost");
cMySQLCom.addFields("quote_line.itm_disc");
cMySQLCom.addFields("quote_line.itm_freight");
cMySQLCom.addFields("quote_line.itm_vat");
cMySQLCom.addFields("quote_line.itm_net");
cMySQLCom._tblName = "quote_line";
cMySQLCom._innerTableName = "item_mst";
cMySQLCom._innerLeftOn = "quote_line.itm_code";
cMySQLCom._innerRightOn = "item_mst.itm_code";
cMySQLCom._condition = " quote_line.quote_no = '" + _quoteno + "'";
reader = cMySQLCom.innerSelectQueryWhere();
return(reader);
}
//set location details based on location code
//retrieved on mysql location table
public void setLocationDetails()
{
cMySQLCommands osetLocationDetails = new cMySQLCommands();
MySqlDataReader reader;
osetLocationDetails._fields = "";
osetLocationDetails._tblName = "location";
osetLocationDetails._condition = "location.loc_code='" + _code.TrimEnd() + "'";
reader = osetLocationDetails.selectQueryWhere();
if (reader.HasRows)
{
while (reader.Read())
{
_name = reader.GetString(2);
_comHed = reader.GetString(3);
_main = reader.GetString(4);
_navcd = reader.GetString(5);
_addr = reader.GetString(6);
_conper = reader.GetString(7);
_connum = reader.GetString(8);
_email = reader.GetString(9);
_web = reader.GetString(10);
_user = reader.GetString(11);
_dupdat = reader.GetString(12);
}
}
}
public void savePOCurrency()
{
cMySQLCommands cMySQLCom = new cMySQLCommands();
cMySQLCom._tblName = "spo_currency";
cMySQLCom.addFields("poc_no");
cMySQLCom.addFields("ers_no");
cMySQLCom.addFields("poc_date");
cMySQLCom.addFields("cur_code");
cMySQLCom.addFields("cur_name");
cMySQLCom.addFields("cur_val");
cMySQLCom.addFields("remarks");
cMySQLCom.addFields("prepby");
cMySQLCom.addFields("confirmed");
cMySQLCom.addFields("loc_code");
cMySQLCom._values = "";
cMySQLCom.addValues(_pocno);
cMySQLCom.addValues(_pocersno);
cMySQLCom.addValues(_pocdate);
cMySQLCom.addValues(_curCode);
cMySQLCom.addValues(_curname);
cMySQLCom.addValues(_curVal);
cMySQLCom.addValues(_pocremarks);
cMySQLCom.addValues(_pocPrepBy);
cMySQLCom.addValues(_pocConfirm);
cMySQLCom.addValues(_pocLocCode);
cMySQLCom.insertQuery();
}
//set ers columns based on object's values
public void setStatus()
{
cMySQLCommands cMySQLCom = new cMySQLCommands();
//cMySQLCommands oDeleteOldEntry = new cMySQLCommands();
//oDeleteOldEntry._values = "";
cMySQLCom._values = "";
//oDeleteOldEntry._tblName = "ers_tagged";
cMySQLCom._tblName = "ers_tagged";
//oDeleteOldEntry._condition = "ers_tagged.rst_no = '"+ _rstNo +
//"' and ers_tagged.tag_status = '' and ers_tagged.rst_loccd='"+ _rstLocCd + "'";
cMySQLCom.addFields("tag_status");
cMySQLCom.addFields("rst_no");
cMySQLCom.addFields("rst_locCd");
cMySQLCom.addValues(_rstStat);
cMySQLCom.addValues(_rstNo);
cMySQLCom.addValues(_rstLocCd);
//oDeleteOldEntry.deleteQuery();
cMySQLCom.insertQuery();
}
//getERSLine is a method used to update the properties of the class
//it retrieves the details included in E-Requisiton Line MySqltable
//data is based on the initialized ERS No
//entry items are listed in the Property List
public List <cERequisitionLine> getERSLine()
{
cMySQLCommands oMySQLCommand = new cMySQLCommands();
MySqlDataReader reader;
//oMySQLCommand.addFields("pod_date");
oMySQLCommand.addFields("rsd_itemcd");
oMySQLCommand.addFields("item_mst.itm_desc");
oMySQLCommand.addFields("rsd_qty");
oMySQLCommand.addFields("rsd_untms");
oMySQLCommand.addFields("rsd_untcst");
oMySQLCommand.addFields("rsd_amt");
oMySQLCommand.addFields("rsd_itemno");
oMySQLCommand.addFields("rsd_dcount");
oMySQLCommand.addFields("rsd_netamt");
oMySQLCommand.addFields("rsd_detl");
oMySQLCommand.addFields("rsd_rrstat");
oMySQLCommand.addFields("rsd_balanc");
oMySQLCommand._tblName = "ers_line";
oMySQLCommand._innerTableName = "item_mst";
oMySQLCommand._innerLeftOn = "ers_line.rsd_itemcd";
oMySQLCommand._innerRightOn = "item_mst.itm_code";
oMySQLCommand._condition = "ers_line.rsd_no = " + _ersno;
reader = oMySQLCommand.innerSelectQueryWhere();
if (reader.HasRows)
{
while (reader.Read())
{
cErequisitionItems.Add(new cERequisitionLine
{
//_poddate = reader.GetString(0),
_itemCode = reader.GetString(0),
_iDescription = reader.GetString(1),
_quantity = reader.GetString(2),
_UOM = reader.GetString(3),
_unitCost = reader.GetString(4),
_amt = reader.GetString(5),
_itemno = reader.GetString(6),
_discount = reader.GetString(7),
_itmnetamt = reader.GetString(8),
_details = reader.GetString(9),
_rrstat = reader.GetString(10),
_balance = reader.GetString(11)
});
}
}
return(cErequisitionItems);
}
public List <cPurchaseOrderItem> getPOLine()
{
DBConnection dbCon = new DBConnection();
cMySQLCommands oMySQLCommand = new cMySQLCommands();
MySqlDataReader reader;
oMySQLCommand.addFields("pod_date");
oMySQLCommand.addFields("pod_itemcd");
oMySQLCommand.addFields("item_mst.itm_desc");
oMySQLCommand.addFields("pod_qty");
oMySQLCommand.addFields("pod_untms");
oMySQLCommand.addFields("pod_untcst");
oMySQLCommand.addFields("pod_amt");
oMySQLCommand.addFields("pod_itemno");
oMySQLCommand.addFields("pod_dcount");
oMySQLCommand.addFields("pod_netamt");
oMySQLCommand.addFields("pod_detl");
oMySQLCommand.addFields("pod_rrstat");
oMySQLCommand.addFields("pod_balanc");
oMySQLCommand._tblName = "spo_line";
oMySQLCommand._innerTableName = "item_mst";
oMySQLCommand._innerLeftOn = "spo_line.pod_itemcd";
oMySQLCommand._innerRightOn = "item_mst.itm_code";
oMySQLCommand._condition = "spo_line.pod_no = " + _pohno;
reader = oMySQLCommand.innerSelectQueryWhere();
if (reader.HasRows)
{
while (reader.Read())
{
cPOItemsList.Add(new cPurchaseOrderItem
{
_poddate = reader.GetString(0),
_itemCode = reader.GetString(1),
_description = reader.GetString(2),
_quantity = reader.GetString(3),
_uom = reader.GetString(4),
_unitcost = reader.GetString(5),
_amount = reader.GetString(6),
_itemno = reader.GetString(7),
_discount = reader.GetString(8),
_netamount = reader.GetString(9),
_detail = reader.GetString(10),
_rrstat = reader.GetString(11),
_balance = reader.GetString(12)
});
}
}
return(cPOItemsList);
}
public void editDetails(List <cSupplierPerCost> cSupplierCostList, string selQuoteSupplier)
{
cMySQLCommands cMySQLComDel = new cMySQLCommands();
cMySQLCommands cMySQLCom = new cMySQLCommands();
cMySQLCom._tblName = "quote_line";
cMySQLCom.addFields("quote_no");
cMySQLCom.addFields("itm_code");
cMySQLCom.addFields("itm_qty");
cMySQLCom.addFields("itm_uom");
cMySQLCom.addFields("itm_cost");
cMySQLCom.addFields("itm_disc");
cMySQLCom.addFields("itm_freight");
cMySQLCom.addFields("itm_vat");
cMySQLCom.addFields("itm_net");
cMySQLCom.addFields("sup_code");
cMySQLCom.addFields("quote_loccd");
cMySQLCom.addFields("selected");
if (cSupplierCostList.Count > 0)
{
foreach (cSupplierPerCost cSupPerCost in cSupplierCostList)
{
cMySQLComDel._fields = "";
cMySQLComDel._tblName = "quote_line";
cMySQLComDel._condition = "quote_no = '" + _quoteno + "' and quote_loccd = '" + _locCode
+ "' and sup_code = '" + cSupPerCost._supplierCode + "' and itm_code ='" + cSupPerCost._itmCode + "'";
cMySQLComDel.deleteQuery();
cMySQLCom._values = "";
cMySQLCom.addValues(_quoteno);
cMySQLCom.addValues(cSupPerCost._itmCode);
cMySQLCom.addValues(Convert.ToString(cSupPerCost._quantity));
cMySQLCom.addValues(cSupPerCost._uom);
cMySQLCom.addValues(Convert.ToString(cSupPerCost._unitCost));
cMySQLCom.addValues(Convert.ToString(cSupPerCost._discount));
cMySQLCom.addValues(Convert.ToString(cSupPerCost._freight));
cMySQLCom.addValues(Convert.ToString(cSupPerCost._vat));
cMySQLCom.addValues(Convert.ToString(cSupPerCost._netTotal).Replace(",", ""));
cMySQLCom.addValues(Convert.ToString(cSupPerCost._supplierCode));
cMySQLCom.addValues(_locCode);
if (cSupPerCost._supplierCode == selQuoteSupplier)
{
cMySQLCom.addValues("True");
}
else
{
cMySQLCom.addValues("False");
}
cMySQLCom.insertQuery();
}
}
}
//Used to add entry in ERS Currency table .dbf file in system
public void createERSCurrency(List <cERequisitionCur> eRequisitionCurList)
{
//for each value in listed currencies
foreach (cERequisitionCur oERequisitionCur in eRequisitionCurList)
{
//intialized variables
List <setDBFValues> dbfColumnList = new List <setDBFValues>();
cMySQLCommands cInsertERSQuery = new cMySQLCommands();
cInsertERSQuery._tblName = "ers_currency";
cInsertERSQuery._values = "";
//get ers number +1
_eno = (Convert.ToDouble(cInsertERSQuery.getDBFSequenceNo("ERS")) + 1).ToString();
//currency columns
//selected value is only 1 per entry list
cInsertERSQuery.addFields("ers_no");
cInsertERSQuery.addFields("cur_code");
cInsertERSQuery.addFields("cur_name");
cInsertERSQuery.addFields("cur_val");
cInsertERSQuery.addFields("selected");
//ers currency entry per list will be added based on value
cInsertERSQuery.addValues(_eno);
cInsertERSQuery.addValues(oERequisitionCur._rscCode);
cInsertERSQuery.addValues(oERequisitionCur._rscName);
cInsertERSQuery.addValues(oERequisitionCur._rscValue);
cInsertERSQuery.addValues(oERequisitionCur._rscSelected);
//commented of uninsert ers_line
// cInsertERSQuery.insertQuery();
//set datatypes for dbf Column
dbfColumnList.Add(new setDBFValues {
valueName = _ersno, valueType = "NUMERIC"
});
dbfColumnList.Add(new setDBFValues {
valueName = oERequisitionCur._rscCode, valueType = "STRING"
});
dbfColumnList.Add(new setDBFValues {
valueName = oERequisitionCur._rscName, valueType = "STRING"
});
dbfColumnList.Add(new setDBFValues {
valueName = oERequisitionCur._rscValue, valueType = "NUMERIC"
});
dbfColumnList.Add(new setDBFValues {
valueName = oERequisitionCur._rscSelected, valueType = "BOOL"
});
cInsertERSQuery.insertDBFQuery(dbfColumnList);
// cInsertERSQuery.closeDBFAll();}
}
}
//Used to increment PO from sequence .dbf table
public void incrementPO()
{
cMySQLCommands oMySQLSetSequence = new cMySQLCommands();
oMySQLSetSequence.setDBFSequenceNo("SPO", _pono);
oMySQLSetSequence._tblName = "sequence";
oMySQLSetSequence._fields = "sequence.seq_num";
oMySQLSetSequence._values = _pono;
oMySQLSetSequence._condition = ("sequence.seq_code = 'SPO'");
oMySQLSetSequence.updateQuery();
}
//Used to increment ERS from sequence .dbf table
public void incrementERS()
{
cMySQLCommands oMySQLSetSequence = new cMySQLCommands();
oMySQLSetSequence.setDBFSequenceNo("ERS", _ersno);
oMySQLSetSequence._tblName = "sequence";
oMySQLSetSequence._fields = "sequence.seq_num";
oMySQLSetSequence._values = _ersno;
oMySQLSetSequence._condition = ("sequence.seq_code = 'ERS'");
oMySQLSetSequence.updateQuery();
}
public void incrementQTN()
{
cMySQLCommands oMySQLSetSequence = new cMySQLCommands();
oMySQLSetSequence.setDBFSequenceNo("QTN", _quoteno);
oMySQLSetSequence._tblName = "sequence";
oMySQLSetSequence._fields = "sequence.seq_num";
oMySQLSetSequence._values = _quoteno;
oMySQLSetSequence._condition = ("sequence.seq_code = 'QTN'");
oMySQLSetSequence.updateQuery();
}
//updates ers tagging
public void setUntagged()
{
cMySQLCommands cMySQLCom = new cMySQLCommands();
cMySQLCom._values = "";
cMySQLCom._tblName = "ers_tagged";
cMySQLCom.addFields("tag_status");
cMySQLCom.addValues(_rstStat);
cMySQLCom._condition = "rst_no = '" + _rstNo + "' and rst_loccd = '" + _rstLocCd + "'";
cMySQLCom.updateQuery();
}
public int getQuoteNo()
{
//changed for per location #
int newSequenceNo = 0;
cMySQLCommands cMySQLCom = new cMySQLCommands();
string curnum = "";
//cMySQLCom._tblName = "quote_tran";
//cMySQLCom._idName = "quote_no";
curnum = cMySQLCom.getDBFSequenceNo("QTN");
newSequenceNo = Convert.ToInt32(curnum);//Convert.ToInt32(cMySQLCom.getSequenceNo());
//System.Diagnostics.Trace.WriteLine(newSequenceNo);
return(newSequenceNo);
}
public List <cSupplierPerCost> getitemSupplierCost()
{
cMySQLCommands cMySQLCom = new cMySQLCommands();
MySqlDataReader reader;
cMySQLCom.addFields("quote_line.sup_code");
cMySQLCom.addFields("quote_line.itm_code");
cMySQLCom.addFields("item_mst.itm_desc");
cMySQLCom.addFields("item_mst.itm_specs");
cMySQLCom.addFields("quote_line.itm_qty");
cMySQLCom.addFields("quote_line.itm_uom");
cMySQLCom.addFields("quote_line.itm_cost");
cMySQLCom.addFields("quote_line.itm_disc");
cMySQLCom.addFields("quote_line.itm_freight");
cMySQLCom.addFields("quote_line.itm_vat");
cMySQLCom.addFields("quote_line.itm_net");
cMySQLCom._tblName = "quote_line";
cMySQLCom._innerTableName = "item_mst";
cMySQLCom._innerLeftOn = "quote_line.itm_code";
cMySQLCom._innerRightOn = "item_mst.itm_code";
cMySQLCom._condition = " quote_line.quote_no = '" + _quoteno + "' and quote_line.quote_loccd = '" + _locCode + "'";
reader = cMySQLCom.innerSelectQueryWhere();
if (reader.HasRows)
{
while (reader.Read())
{
cSupplierItemPerCostList.Add(new cSupplierPerCost
{
_supplierCode = reader.GetString(0),
_itmCode = reader.GetString(1),
_description = reader.GetString(2),
_details = reader.GetString(3),
_quantity = reader.GetDouble(4),
_uom = reader.GetString(5),
_unitCost = reader.GetDouble(6),
_discount = reader.GetDouble(7),
_freight = reader.GetDouble(8),
_vat = reader.GetDouble(9),
_netTotal = reader.GetDouble(10),
});
}
}
return(cSupplierItemPerCostList);
}
public void setStatus()
{
cMySQLCommands cMySQLCom = new cMySQLCommands();
cMySQLCom._values = "";
cMySQLCom._tblName = "quote_tran";
cMySQLCom.addFields("quote_stat");
cMySQLCom.addValues(_status);
cMySQLCom._condition = " quote_no = '" + _quoteno + "' and quote_loccd = '" + _locCode + "'";
cMySQLCom.updateQuery();
}
public void getSERSHeader(string selSERSNo)
{
DBConnection dbCon = new DBConnection();
cLocation oLocation = new cLocation();
cCompany oCompany = new cCompany();
cMySQLCommands oMySQLCommand = new cMySQLCommands();
MySqlDataReader reader;
oMySQLCommand.addFields("sers_tran.rsh_dreq");
oMySQLCommand.addFields("sers_tran.rsh_dneed");
oMySQLCommand.addFields("sers_tran.rsh_loccd");
oMySQLCommand.addFields("sers_tran.rsh_depcd");
oMySQLCommand.addFields("sers_tran.rsh_dstamp");
oMySQLCommand.addFields("sers_tran.rsh_stat");
oMySQLCommand.addFields("usertab.usr_name");
oMySQLCommand.addFields("sers_tran.rsh_rem");
oMySQLCommand.addFields("sers_tran.rsh_type");
oMySQLCommand.addFields("sers_tran.rsh_apprby");
oMySQLCommand._tblName = "sers_tran";
oMySQLCommand._innerTableName = "usertab";
oMySQLCommand._innerLeftOn = "sers_tran.rsh_uid";
oMySQLCommand._innerRightOn = "usertab.usr_login";
oMySQLCommand._condition = "sers_tran.rsh_no = '" + selSERSNo + "'";
reader = oMySQLCommand.innerSelectQueryWhere();
if (reader.HasRows)
{
while (reader.Read())
{
_dateRequested = reader.GetString(0);
_dateNeeded = reader.GetString(1);
_loccode = reader.GetString(2);
_deptcode = reader.GetString(3);
_datestamp = reader.GetString(4);
_status = reader.GetString(5);
_uid = reader.GetString(6);
_remarks = reader.GetString(7);
_sersType = reader.GetString(8);
//_noOfCopies = reader.GetString(25);
_approvedBy = reader.GetString(9);
}
}
////getLocation();
//getCompany();
}
public void changePassword()
{
string newPasswordEncrypt;
MD5Sample oMD5 = new MD5Sample();
oMD5._source = _password;
newPasswordEncrypt = oMD5.GetMd5Hash();
cMySQLCommands cMySQLChangePassword = new cMySQLCommands();
cMySQLChangePassword._tblName = "usertab";
cMySQLChangePassword._fields = "usertab.usr_pass";
cMySQLChangePassword._values = "'" + newPasswordEncrypt + "'";
cMySQLChangePassword._condition = ("usertab.usr_login = '******'");
cMySQLChangePassword.updateQuery();
}
public void addEventEntry()
{
cLocation oLocation = new cLocation();
oLocation._code = _locCode;
oLocation.setLocationDetails();
cMySQLCommands oMySQLCommands = new cMySQLCommands();
oMySQLCommands._tblName = "eventlog";
oMySQLCommands.addFields("eventtime");
oMySQLCommands.addFields("eventname");
oMySQLCommands._values = "";
oMySQLCommands.addValues(_logEventDateTime);
oMySQLCommands.addValues(oLocation._name.TrimEnd() + " has " + _logEventCount + "entries of " + _logEventName);
oMySQLCommands.insertQuery();
}
//a module that provides location name based on location code
public void getLocation()
{
cMySQLCommands oMySQLCommand = new cMySQLCommands();
MySqlDataReader reader;
oMySQLCommand._fields = "location.loc_name";
oMySQLCommand._tblName = "location";
oMySQLCommand._condition = "location.loc_code = '" + _location + "'";
reader = oMySQLCommand.selectQueryWhere();
if (reader.HasRows)
{
while (reader.Read())
{
_locationName = reader.GetString(0);
}
}
}
//a module that provides company name based on company code
public void getCompany()
{
cMySQLCommands oMySQLCommand = new cMySQLCommands();
MySqlDataReader reader;
oMySQLCommand._fields = "company.com_name";
oMySQLCommand._tblName = "company";
oMySQLCommand._condition = "company.com_code = '" + _department + "'";
reader = oMySQLCommand.selectQueryWhere();
if (reader.HasRows)
{
while (reader.Read())
{
_departmentName = reader.GetString(0);
}
}
}
public void deptNametoDeptCode()
{
cMySQLCommands osetDeptDetails = new cMySQLCommands();
MySqlDataReader reader;
osetDeptDetails._fields = "";
osetDeptDetails._tblName = "company";
osetDeptDetails._condition = "company.com_name='" + _name + "'";
reader = osetDeptDetails.selectQueryWhere();
if (reader.HasRows)
{
while (reader.Read())
{
_code = reader.GetString(1);
}
}
}
