public Agent(int iRepNo)
{
if (iRepNo == -1)
{
_sCompany = "All Agents";
_iRepNo = -1;
_sAgentCode = "All Agents";
}
else
{
_iRepNo = iRepNo;
_ds = DataLink.Select("select * from Agents where RepNo = " + iRepNo, DataLinkCon.bpss);
if (_ds.Tables.Count > 0)
{
IEnumerable <DataRow> rows = _ds.Tables[0].AsEnumerable();
_sAgentCode = rows.Select(r => r["AgentCode"].ToString()).First();
_sCompany = rows.Select(r => r["Company"].ToString()).First();
_sAddressCity = rows.Select(r => r["AddressCity"].ToString()).First();
_sAddressState = rows.Select(r => r["AddressState"].ToString()).First();
_sAddressStreet = rows.Select(r => r["AddressStreet"].ToString()).First();
_sAddressZip = rows.Select(r => r["AddressZip"].ToString()).First();
_sCompanyEMail = rows.Select(r => r["CompanyEmail"].ToString()).First();
_sDefaultContactName = rows.Select(r => r["DefaultContactName"].ToString()).First();
_sPhone = rows.Select(r => r["Phone"].ToString()).First();
}
}
}
static public List <StockInventoryItem> GetAllItems()
{
_ssSQL = "select CatalogNumber from Stock";
_sds = DataLink.Select(_ssSQL, DataLinkCon.mgmuser);
return(_sds.Tables[0].AsEnumerable().Select(r => new StockInventoryItem(r["CatalogNumber"].ToString(),
InventoryDescType.CatalogNumber)).Cast <StockInventoryItem>().ToList());
}
static public List <string> GetAltNumber(string sWindings, string sStockVoltageDisplay, string sKVA)
{
_ssSQL = "select s.AltNumber from Stock s join StockVoltages sv on s.Configuration = sv.StockVoltage where s.Windings = '" +
sWindings + "' and s.KVA = " + sKVA + " and sv.StockVoltageDisplay = '" + sStockVoltageDisplay + "'";
_sds = DataLink.Select(_ssSQL, DataLinkCon.mgmuser);
return(_sds.Tables[0].AsEnumerable().Select(r => r["AltNumber"].ToString()).ToList());
}
static public string GetCategory(string sStockVoltageDisplay, string sWindings)
{
if (sStockVoltageDisplay == "ALL")
{
return("ALL");
}
_sds = DataLink.Select("select VoltageCategory from StockVoltages where StockVoltageDisplay = '" + sStockVoltageDisplay + "' and Windings = '" + sWindings + "'",
DataLinkCon.mgmuser);
return(_sds.Tables[0].AsEnumerable().Select(r => r["VoltageCategory"].ToString()).First());
}
static public List <StockVoltages> GetAllItems()
{
List <StockVoltages> retLst;
_ssSQL = "select * from StockVoltages";
_sds = DataLink.Select(_ssSQL, DataLinkCon.mgmuser);
retLst = _sds.Tables[0].AsEnumerable().Select(r => new StockVoltages(r["StockVoltageDisplay"].ToString(),
StockVoltagesType.StockVoltageDisplay)).Cast <StockVoltages>().ToList();
return(retLst);
}
public StockVoltages(string sDesc, StockVoltagesType svt)
{
if (svt == StockVoltagesType.StockVoltageDisplay)
{
_sSQL = "select * from StockVoltages where StockVoltageDisplay = '" + sDesc + "'";
}
_ds = DataLink.Select(_sSQL, DataLinkCon.mgmuser);
_sStockVoltage = _ds.Tables[0].AsEnumerable().Select(r => r["StockVoltage"].ToString()).First();
_sStockVoltageDisplay = _ds.Tables[0].AsEnumerable().Select(r => r["StockVoltageDisplay"].ToString()).First();
_sVoltageCategory = _ds.Tables[0].AsEnumerable().Select(r => r["VoltageCategory"].ToString()).First();
_sWindings = _ds.Tables[0].AsEnumerable().Select(r => r["Windings"].ToString()).First();
}
static public int GetAgentNoFromRepID(int iRepID)
{
int iRetVal = -1;
DataSet dsAgentNo;
dsAgentNo = DataLink.Select("select MGMAgentNo from Rep where RepID = " + iRepID, DataLinkCon.mgmuser);
if (dsAgentNo.Tables.Count > 0)
{
if (dsAgentNo.Tables[0].Rows.Count > 0)
{
iRetVal = Convert.ToInt32(dsAgentNo.Tables[0].Rows[0]["MGMAgentNo"]);
}
}
return(iRetVal);
}
static public int GetQuoteEmailID(int iQuoteID)
{
int iQuoteEmailID = -1;
DataSet dsQuote = DataLink.Select("select max(QuoteEmailID) as QuoteEmailID from QuoteEmails where QuoteID = " + iQuoteID, DataLinkCon.mgmuser);
if (dsQuote.Tables.Count > 0)
{
if (dsQuote.Tables[0].Rows.Count > 0)
{
if (!DBNull.Value.Equals(dsQuote.Tables[0].Rows[0]["QuoteEmailID"]))
{
iQuoteEmailID = Convert.ToInt32(dsQuote.Tables[0].Rows[0]["QuoteEmailID"]);
}
}
}
return(iQuoteEmailID);
}
public static int GetMGMAgentNo(string sRepName)
{
int iRetValue = -1;
DataSet ds = DataLink.Select("select MGMAgentNo from Rep where Display_Name = '" + sRepName + "'", DataLinkCon.mgmuser);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
iRetValue = ds.Tables[0].AsEnumerable().Select(r => Convert.ToInt32(r["MGMAgentNo"])).First();
}
}
}
return(iRetValue);
}
public StockInventoryItem(string sDesc, InventoryDescType descType)
{
if (descType == InventoryDescType.AltNumber)
{
_sSQL = "select s.CatalogNumber,s.AltNumber,s.Height,s.Width,s.Depth,s.PrimaryVoltageDW,s.SecondaryVoltageDW,s.Hertz,s.Temperature,s.Enclosure," +
"s.PrimaryVoltage,s.SecondaryVoltage,s.TP1,s.SoundLevel,s.KVA,s.Weight,s.Windings,s.Configuration,sv.StockVoltageDisplay,sv.VoltageCategory " +
"from Stock s join StockVoltages sv on " +
"s.Configuration = sv.StockVoltage and s.Windings = sv.Windings where AltNumber = '" + sDesc + "'";
}
if (descType == InventoryDescType.CatalogNumber)
{
_sSQL = "select s.CatalogNumber,s.AltNumber,s.Height,s.Width,s.Depth,s.PrimaryVoltageDW,s.SecondaryVoltageDW,s.Hertz,s.Temperature,s.Enclosure," +
"s.PrimaryVoltage,s.SecondaryVoltage,s.TP1,s.SoundLevel,s.KVA,s.Weight,s.Windings,s.Configuration,sv.StockVoltageDisplay,sv.VoltageCategory " +
"from Stock s join StockVoltages sv on " +
"s.Configuration = sv.StockVoltage and s.Windings = sv.Windings where CatalogNumber = '" + sDesc + "'";
}
_ds = DataLink.Select(_sSQL, DataLinkCon.mgmuser);
_sCatalogNumber = _ds.Tables[0].AsEnumerable().Select(r => r["CatalogNumber"].ToString()).First();
_sAltNumber = _ds.Tables[0].AsEnumerable().Select(r => r["AltNumber"].ToString()).First();
_dHeight = _ds.Tables[0].AsEnumerable().Select(r => Convert.ToDecimal(r["Height"])).First();
_dWidth = _ds.Tables[0].AsEnumerable().Select(r => Convert.ToDecimal(r["Width"])).First();
_dDepth = _ds.Tables[0].AsEnumerable().Select(r => Convert.ToDecimal(r["Depth"])).First();
_sPrimaryVoltageDW = _ds.Tables[0].AsEnumerable().Select(r => r["PrimaryVoltageDW"].ToString()).First();
_sSecondaryVoltageDW = _ds.Tables[0].AsEnumerable().Select(r => r["SecondaryVoltageDW"].ToString()).First();
_iHertz = _ds.Tables[0].AsEnumerable().Select(r => Convert.ToInt32(r["Hertz"])).First();
_iTemperature = _ds.Tables[0].AsEnumerable().Select(r => Convert.ToInt32(r["Temperature"])).First();
_sEnclosure = _ds.Tables[0].AsEnumerable().Select(r => r["Enclosure"].ToString()).First();
_sPrimaryVoltage = _ds.Tables[0].AsEnumerable().Select(r => r["PrimaryVoltage"].ToString()).First();
_sSecondaryVoltage = _ds.Tables[0].AsEnumerable().Select(r => r["SecondaryVoltage"].ToString()).First();
_sTP1 = _ds.Tables[0].AsEnumerable().Select(r => r["TP1"].ToString()).First();
_sSoundLevel = _ds.Tables[0].AsEnumerable().Select(r => r["SoundLevel"].ToString()).First();
_dKVA = _ds.Tables[0].AsEnumerable().Select(r => Convert.ToDouble(r["KVA"])).First();
_iWeight = _ds.Tables[0].AsEnumerable().Select(r => Convert.ToInt32(r["Weight"])).First();
_sWindings = _ds.Tables[0].AsEnumerable().Select(r => r["Windings"].ToString()).First();
_sConfiguration = _ds.Tables[0].AsEnumerable().Select(r => r["Configuration"].ToString()).First();
_sStockVoltageDisplay = _ds.Tables[0].AsEnumerable().Select(r => r["StockVoltageDisplay"].ToString()).First();
_sVoltageCat = _ds.Tables[0].AsEnumerable().Select(r => r["VoltageCategory"].ToString()).First();
_bUseSelectString = false;
}
public static string GetAgentCode(int iMGMAgentNo, string sDisplayName)
{
int iRepID = -1;
string sAgentCode = "";
DataSet ds = DataLink.Select("select RepID from Rep where MGMAgentNo = " +
iMGMAgentNo + " and Display_Name = '" + sDisplayName + "'", DataLinkCon.mgmuser);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
iRepID = ds.Tables[0].AsEnumerable().Select(r => Convert.ToInt32(r["RepID"])).First();
}
}
}
if (iRepID != -1)
{
ds = DataLink.Select("select AgentCode from Agents where RepIDWeb = " + iRepID, DataLinkCon.bpss);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
sAgentCode = ds.Tables[0].AsEnumerable().Select(r => r["AgentCode"].ToString()).First();
}
}
}
}
return(sAgentCode);
}