public override clsMsg getData(clsCmd cmd)
{
var obj = new NTier.Request.clsGetDataView(_adapter);
if (this.func.isEmpty() == false)
{
NTier.Request.iRequest iCmd = AppDomain.CurrentDomain.CreateInstance(this.assemblyName, this.classPath).Unwrap() as iRequest;
iCmd.setTier(this._tier);
object[] objParams = new object[] { cmd };
var m = iCmd.GetType().GetMethod(this.func);
clsMsg msg = (clsMsg)m.Invoke(iCmd, objParams);
return(msg);
}
else
{
NTier.Request.iGetData iCmd = AppDomain.CurrentDomain.CreateInstance(this.assemblyName, this.classPath).Unwrap() as iGetData;
iCmd.setTier(this._tier);
return(iCmd.getData(cmd));
}
return(g.msg("", obj.getData(cmd)));
}
public clsMsg upload_bhavdata_row(clsCmd cmd)
{
int iDaily_PriceID = 0;
string sDate1 = "";
string sSymbol = "";
string sSeries = "";
sSymbol = cmd.getStringValue("symbol").Trim();
sSeries = cmd.getStringValue("series").Trim();
//DataRow[] rowsStock = getStockMaster().Select(string.Format(" symbol ='{0}' and series = '{1}' ", sSymbol, sSeries));
NTier.CRUD.clsCRUD oCRUD_DailyPrice = _tier.getCRUD("tmp_bhavdata");
// iStockID = g.parseInt(rowsStock[0]["id"]);
sDate1 = cmd.getStringValue("date1").Trim();
// iDaily_PriceID = oBLLStock.getDaily_PriceID(iStockID, sDate1);
//cmd.setValue("mStockID", iStockID);
cmd.setValue("id", 0);
clsMsg msg = oCRUD_DailyPrice.save(cmd);
return(msg);
}
public override clsMsg getFileData(clsCmd cmd)
{
NTier.Request.iRequest oReq = _Assembly.createInstance(this.assemblyName, this.classPath) as iRequest;
oReq.setTier(this._tier);
object[] objParams = new object[] { cmd };
var m = oReq.GetType().GetMethod(this.func);
clsMsg msg = (clsMsg)m.Invoke(oReq, objParams);
return(msg);
}
private void sendDummyData(string data)
{
clsMsg tempMsg = new clsMsg
{
CLIENT_IP = clsCommon.Instance.ServerIP,
Port = clsCommon.Instance.SERVER_PORT,
S_DATA = data
};
QueueManager.Instance.SetTransmit(tempMsg);
}
public clsMsg getFileData(clsCmd cmd
, iBussinessTier oTier)
{
NTier.Request.iRequest oReq = _oAssembly.createInstance(this.AssemblyName, this.classPath) as iRequest;
oReq.setTier(oTier);
object[] objParams = new object[] { cmd };
var m = oReq.GetType().GetMethod(this.functionName);
clsMsg msg = (clsMsg)m.Invoke(oReq, objParams);
return(msg);
}
private void btnLogin_Click(object sender, EventArgs e)
{
var cmd = new clsCmd();
cmd.setValue("userid", txtUserID.Text);
cmd.setValue("pwd", txtPwd.Text);
var msg = _Tier.exec("login", cmd);
if (msg.Validated)
{
result = msg;
this.Close();
}
else
{
ui.warn(msg.Message);
}
}
public clsMsg upload_bhavdata_row(clsCmd cmd)
{
int iDaily_PriceID = 0;
int iStockID = 0;
string sDate1 = "";
string sSymbol = "";
string sSeries = "";
sSymbol = cmd.getStringValue("symbol").Trim();
sSeries = cmd.getStringValue("series").Trim();
DataRow[] rowsStock = getStockMaster().Select(string.Format(" symbol ='{0}' and series = '{1}' ", sSymbol, sSeries));
NTier.CRUD.clsCRUD oCRUD_DailyPrice = _tier.getCRUD("trDaily_Price");
if (rowsStock.Length > 0)
{
iStockID = g.parseInt(rowsStock[0]["id"]);
sDate1 = cmd.getStringValue("date1").Trim();
iDaily_PriceID = oBLLStock.getDaily_PriceID(iStockID, sDate1);
cmd.setValue("mStockID", iStockID);
cmd.setValue("id", iDaily_PriceID);
clsMsg msg = oCRUD_DailyPrice.save(cmd);
return(msg);
}
else
{
if (sSeries.ToUpper().Trim() == "EQ")
{
string sMsg = string.Format("Stock Master not found for Series : {0} And Symbol : {1}", sSeries, sSymbol);
return(g.msg(sMsg));
}
}
return(g.msg(""));
}
/*
* private clsMsg getRequest_fork(string sRequestPath, clsCmd cmd)
* {
* var oRequestPath = new requestPath(sRequestPath);
*
*
* var sPath = getPath(oRequestPath.getPath());
*
* if (!System.IO.File.Exists(sPath))
* return g.msg("Request path not found !");
*
* ///////////////////////////////////////////////
* string sRequestType = "";
* iRequest request = null;
*
* var xDoc = getXmlDoc(oRequestPath.getPath());
*
* var xNodeType = xDoc.SelectSingleNode("//request");
*
* var attr = xNodeType.Attributes["type"];
* if (attr != null)
* sRequestType = attr.Value;
*
* switch (sRequestType)
* {
* case "getData":
* var node = xDoc.SelectSingleNode("//request/dt[@name='" + oRequestPath.getQueryString("name") + "']/view");
* //request = getRequest(node);
* break;
* }
*
* return request.getRequest(cmd);
* }
*/
//private iGetData getRequest(XmlNode node)
//{
// var myRequest = new NTier.CRUD.clsReadSimple();
// myRequest.viewName = node.InnerText;
// return myRequest;
//}
public clsMsg getData(string sPath, clsCmd cmd)
{
XmlNode xNode = xDoc.SelectSingleNode("//appConfig/requestData[@type='getData']/dt[@name='" + sPath + "']");
if (xNode.getXmlAttributeValue("type") == "view")
{
string sViewName = xNode.getXmlText("view");
var obj = new NTier.Request.clsGetDataView(_adapter);
obj.viewName = sViewName;
obj.OrderBy = xNode.getXmlText("orderby");
return(g.msg("", obj.getData(cmd)));
}
else if (xNode.getXmlAttributeValue("type") == "other")
{
string sAssemblyName = xNode.getXmlAttributeValue("assemblyName");
string sClassPath = xNode.getXmlAttributeValue("classPath");
string sFunc = xNode.getXmlAttributeValue("func");
NTier.Request.iGetData iCmd = AppDomain.CurrentDomain.CreateInstance(sAssemblyName, sClassPath).Unwrap() as iGetData;
iCmd.setTier(this);
if (!sFunc.isEmpty())
{
object[] objParams = new object[] { cmd };
var m = iCmd.GetType().GetMethod(sFunc);
clsMsg msg = (clsMsg)m.Invoke(iCmd, objParams);
return(msg);
}
else
{
return(iCmd.getData(cmd));
}
}
return(g.msg(""));
}
private void frmLogin_Load(object sender, EventArgs e)
{
result = g.msg("You are unable to logged in !");
}
public clsMsg exec(string sPath, clsCmd cmd)
{
XmlNode xNode = xDoc.SelectSingleNode("//appConfig/requestData[@type='cmd']/cmd[@name='" + sPath + "']");
if (xNode == null)
{
throw new Exception("Command path " + sPath + " not found !");
}
string sCmdType = xNode.getXmlAttributeValue("type");
if (sCmdType != "json")
{
var msg = validate(xNode, cmd);
if (msg.Validated == false)
{
return(msg);
}
}
//Validation
if (xNode != null)
{
//Declaration
//string sCmdType = xNode.getXmlAttributeValue("type");
string sCRUDName = xNode.getXmlAttributeValue("crudName");
var oCRUD = getCRUD(sCRUDName);
if (sCmdType == "save")
{
try
{
return(oCRUD.save(cmd));
}
catch (Exception ex)
{
return(g.msg_exception(ex));
}
}
else if (sCmdType == "delete")
{
try
{
oCRUD.delete(cmd);
return(g.msg(""));
}
catch (Exception ex)
{
return(g.msg_exception(ex));
}
}
else if (sCmdType == "other")
{
string sAssemblyName = xNode.getXmlAttributeValue("assemblyName");
string sClassPath = xNode.getXmlAttributeValue("classPath");
string sFunc = xNode.getXmlAttributeValue("func");
//NTier.Request.iCommand iCmd = AppDomain.CurrentDomain.CreateInstance(sAssemblyName, sClassPath).Unwrap() as iCommand;
NTier.Request.iCommand iCmd = oAssembly.createInstance(sAssemblyName, sClassPath) as iCommand;
iCmd.setTier(this);
if (!sFunc.isEmpty())
{
object[] objParams = new object[] { cmd };
var m = iCmd.GetType().GetMethod(sFunc);
clsMsg msg = (clsMsg)m.Invoke(iCmd, objParams);
return(msg);
}
else
{
return(iCmd.exec(cmd));
}
}
else if (sCmdType == "cmd")
{
string q = xNode.getXmlText("sql");
cmd.SQL = q;
try
{
_adapter.exec(cmd);
return(g.msg(""));
}
catch (Exception ex)
{
return(g.msg_exception(ex));
}
}
else if (sCmdType == "json")
{
DataTable t = Newtonsoft.Json.JsonConvert.DeserializeObject <DataTable>(cmd.getStringValue("data"));
//validation start
int i = 0;
foreach (DataRow r in t.Rows)
{
i++;
var cmd2 = new clsCmd();
cmd2.AddValues(r);
var msg = validate(xNode, cmd2);
if (msg.Validated == false)
{
msg.Message = string.Format(" Row Number : {0} : {1} ", i, msg.Message);
return(msg);
}
}
//updation start
i = 0;
foreach (DataRow r in t.Rows)
{
i++;
var cmd2 = new clsCmd();
cmd2.AddValues(r);
string q = xNode.getXmlText("sql");
cmd2.SQL = q;
try
{
_adapter.exec(cmd2);
return(g.msg(""));
}
catch (Exception ex)
{
var msg = g.msg_exception(ex);
msg.Message = string.Format(" Row Number : {0} : {1} ", i, msg.Message);
}
}
}
}
return(g.msg("Path not found !"));
}
