public void setCRUD(string sKeyAttr, XmlDocument xDoc)
{
if (xDoc == null)
{
return;
}
XmlNodeList xNodeList = xDoc.SelectNodes("//appConfig/cruds/crud");
if (xNodeList == null)
{
return;
}
foreach (XmlNode xNode in xNodeList)
{
string sKey = sKeyAttr + xNode.getXmlAttributeValue("name");
string sTableName = xNode.getXmlAttributeValue("tableName");
string sViewName = xNode.getXmlAttributeValue("viewName");
string sPrimaryKeyField = xNode.getXmlAttributeValue("primaryKey");
bool isIdentity = xNode.getXmlAttributeValue("isIdentity") == "true" ? true : false;
//
if (!clnCRUDs.ContainsKey(sKey))
{
var oCRUD = new NTier.CRUD.clsCRUD(_adapter, sTableName, sViewName, sPrimaryKeyField, isIdentity);
clnCRUDs.Add(sKey, oCRUD);
}
//return oCRUD;
}
}
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 clsAPIResponse call(clsCmd cmd)
{
var oCRUD = new NTier.CRUD.clsCRUD(_appService.getAdapter(), Table, Table, idField, isIdentity);
var oResult = oCRUD.save(cmd);
return(new clsAPIResponse()
{
message = oResult.Message
});
}
public clsAPIResponse save(clsCmd cmd)
{
var oCRUD = new NTier.CRUD.clsCRUD(_appService.getAdapter(), name, name, autoIncrementField, true);
var oResult = oCRUD.save(cmd);
return(new clsAPIResponse()
{
message = oResult.Message, result = oResult.Obj
});
}
public NTier.CRUD.clsCRUD getCRUD(string sCRUDName)
{
XmlNode xNode = xDoc.SelectSingleNode("//appConfig/cruds/crud[@name='" + sCRUDName + "']");
string sTableName = xNode.getXmlAttributeValue("tableName");
string sViewName = xNode.getXmlAttributeValue("viewName");
string sPrimaryKeyField = xNode.getXmlAttributeValue("primaryKey");
bool isIdentity = xNode.getXmlAttributeValue("isIdentity") == "true" ? true : false;
//
var oCRUD = new NTier.CRUD.clsCRUD(_adapter, sTableName, sViewName, sPrimaryKeyField, isIdentity);
return(oCRUD);
}
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(""));
}
public override clsAPIResponse call(clsCmd cmd)
{
var oCRUD = new NTier.CRUD.clsCRUD(_appService.getAdapter(), Table, Table, idField, isIdentity);
try
{
oCRUD.delete(cmd);
return(new clsAPIResponse()
{
message = ""
});
}
catch (Exception ex)
{
return(new clsAPIResponse()
{
message = ex.Message
});
}
}
public clsAPIResponse delete(clsCmd cmd)
{
var response = validation_delete(cmd);
if (response.isValid == false)
{
return(response);
}
var oCRUD = new NTier.CRUD.clsCRUD(_appService.getAdapter(), name, name, autoIncrementField, true);
try
{
oCRUD.delete(cmd);
return(clsAPIResponse.ok());
}
catch (Exception ex)
{
return(new clsAPIResponse()
{
message = ex.Message
});
}
}
public clsMsg upload_bhavdata_old(clsCmd cmd)
{
if (cmd.Files.Count == 0)
{
return(g.msg("Please select csv file"));
}
///////////////////////////////////////////////////////
var oFile = cmd.Files[0];
string sTmp = System.IO.Path.GetTempFileName();
System.IO.File.WriteAllBytes(sTmp, oFile.Data);
///////////////////////////////////////////////////////
DataTable tStockMaster = oBLLStock.getStockMaster();
NTier.CRUD.clsCRUD oCRUD_DailyPrice = _tier.getCRUD("trDaily_Price");
DataTable t = g.readCSV(sTmp);
foreach (DataColumn col in t.Columns)
{
col.ColumnName = col.ColumnName.Trim();
}
foreach (DataRow r in t.Rows)
{
var cmd2 = new clsCmd();
cmd2.AddValues(r);
int iDaily_PriceID = 0;
int iStockID = 0;
string sDate1 = "";
DataRow[] rowsStock = tStockMaster.Select(string.Format(" symbol ='{0}' and series = '{1}' ", r["symbol"].ToString().Trim(), r["series"].ToString().Trim()));
if (rowsStock.Length > 0)
{
iStockID = g.parseInt(rowsStock[0]["id"]);
sDate1 = r["date1"].ToString().Trim();
iDaily_PriceID = oBLLStock.getDaily_PriceID(iStockID, sDate1);
cmd2.setValue("mStockID", iStockID);
cmd2.setValue("id", iDaily_PriceID);
var msg = oCRUD_DailyPrice.save(cmd2);
if (msg.Validated == false)
{
Console.WriteLine("");
}
}
}
System.IO.File.Delete(sTmp);
return(g.msg());
}
