protected void btnInsert_Click(object sender, EventArgs e)
{
var strFPath = String.Empty;
var strExt = String.Empty;
if (XMLUpload.HasFile)
{
strFPath = Server.MapPath("~/Import/") + XMLUpload.FileName;
strExt = Path.GetExtension(XMLUpload.FileName);
XMLUpload.SaveAs(strFPath);
}
var lstColumns = new List <string>();
var strTableName = drpSystemEntity.SelectedValue; // table name
if (!string.IsNullOrEmpty(strFPath) && strExt.ToLower() == ".xml")
{
var lstErrors = new List <string>();
var doc = new XmlDocument();
doc.Load(strFPath); // read xml file
var documentElement = doc.DocumentElement;
if (documentElement != null)
{
//iterate through elements
foreach (XmlElement el in documentElement)
{
strTableName = el.Name;
var strSQL = String.Empty; // sql string
foreach (XmlElement xmlChildVal in el.ChildNodes) // to add parameters to the sql string with values
{
if (string.IsNullOrEmpty(strSQL))
{
strSQL = "@" + xmlChildVal.Name + " = '" + xmlChildVal.InnerText + "'";
}
else
{
strSQL += ", @" + xmlChildVal.Name + " = '" + xmlChildVal.InnerText + "'";
}
}
strSQL += ", @auditid = " + SessionVariables.RequestProfile.AuditId; // add aduit id
strSQL = strTableName + "Insert " + strSQL; // add procedure name
//Response.Write(strSQL + "</br>");
try
{
DBDML.RunSQL(strTableName + ".Insert", strSQL, "Default"); // execute sql query
}
catch (Exception ex)
{
lstErrors.Add("SQL: " + strSQL + ", Exception: " + ex.Message);
}
}
foreach (var strError in lstErrors)
{
Response.Write(strError + "<br/>");
}
}
}
else
{
throw new Exception("InValid file format (only .xml accepted)");
}
}
public static void Update(CreditContractDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("CreditContract.Update", sql, DataStoreKey);
}
public static void Update(FileTypeDataModel data, RequestProfile requestProfile)
{
var sql = CreateOrUpdate(data, requestProfile, "Update");
DBDML.RunSQL("FileType.Update", sql, DataStoreKey);
}
public static void Update(PortfolioTypeDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("PortfolioType.Update", sql, DataStoreKey);
}
public static void Update(MenuDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Update");
DBDML.RunSQL("Menu.Update", sql, DataStoreKey);
}
public static void Update(HelpPageContextDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("HelpPageContext.Update", sql, DataStoreKey);
}
public static void Update(DBComponentNameDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("DBComponentName.Update", sql, DataStoreKey);
}
public static void Update(SearchKeyDetailDataModel data, RequestProfile requestProfile)
{
var sql = CreateOrUpdate(data, requestProfile, "Update");
DBDML.RunSQL("SearchKeyDetail.Update", sql, DataStoreKey);
}
public static void Update(RetrievalMethodDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("RetrievalMethod.Update", sql, DataStoreKey);
}
public static void Update(SampleNonStdEntity2DataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("SampleNonStdEntity2.Update", sql, DataStoreKey);
}
public static void Update(MarketCapitalizationCategoryDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("MarketCapitalizationCategory.Update", sql, DataStoreKey);
}
public static void Create(ThemeDetailDataModel data, RequestProfile requestProfile)
{
var sql = CreateOrUpdate(data, requestProfile, "Create");
DBDML.RunSQL("ThemeDetail.Insert", sql, DataStoreKey);
}
public static void Update(CommissionSplitDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("CommissionSplit.Update", sql, DataStoreKey);
}
public static void Update(PerformanceParametersDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("PerformanceParameters.Update", sql, DataStoreKey);
}
public static void Update(ClassInstanceDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("ClassInstance.Update", sql, DataStoreKey);
}
public static void Update(ReleaseIssueTypeDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Update");
DBDML.RunSQL("ReleaseIssueType.Update", sql, DataStoreKey);
}
public static void Update(IssuerDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("Issuer.Update", sql, DataStoreKey);
}
public static void Update(CreditDefaultSwapIndexDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("CreditDefaultSwapIndex.Update", sql, DataStoreKey);
}
public static void Update(ChartOfAccountsDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("ChartOfAccounts.Update", sql, DataStoreKey);
}
//public static List<ReleaseLogStatusDataModel> GetEntityDetails(ReleaseLogStatusDataModel data, RequestProfile requestProfile)
//{
// var sql = "EXEC dbo.ReleaseLogStatusSearch " +
// " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
// ", " + ToSQLParameter(data, ReleaseLogStatusDataModel.DataColumns.ApplicationId) +
// ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ReturnAuditInfo, BaseDataManager.ReturnAuditInfoOnDetails) +
// ", " + ToSQLParameter(data, ReleaseLogStatusDataModel.DataColumns.ReleaseLogStatusId) +
// ", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.Name);
// var result = new List<ReleaseLogStatusDataModel>();
// using (var reader = new DBDataReader("Get Details", sql, DataStoreKey))
// {
// var dbReader = reader.DBReader;
// while (dbReader.Read())
// {
// var dataItem = new ReleaseLogStatusDataModel();
// dataItem.ReleaseLogStatusId = (int)dbReader[ReleaseLogStatusDataModel.DataColumns.ReleaseLogStatusId];
// dataItem.ApplicationId = (int)dbReader[ReleaseLogStatusDataModel.DataColumns.ApplicationId];
// dataItem.Application = (string)dbReader[ReleaseLogStatusDataModel.DataColumns.Application];
// SetStandardInfo(dataItem, dbReader);
// SetBaseInfo(dataItem, dbReader);
// result.Add(dataItem);
// }
// }
// return result;
//}
#endregion GetDetails
#region Create
public static void Create(ReleaseLogStatusDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Create");
DBDML.RunSQL("ReleaseLogStatus.Insert", sql, DataStoreKey);
}
public static void Update(UserLoginStatusDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Update");
DBDML.RunSQL("UserLoginStatus.Update", sql, DataStoreKey);
}
public static void Update(StrategyGroupDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("StrategyGroup.Update", sql, DataStoreKey);
}
//public static List<QuestionDataModel> GetEntityDetails(QuestionDataModel data, int auditId)
//{
// var sql = "EXEC dbo.QuestionSearch " +
// " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, auditId) +
// ", " + ToSQLParameter(data, QuestionDataModel.DataColumns.QuestionId);
// var result = new List<QuestionDataModel>();
// using (var reader = new DBDataReader("Get Details", sql, DataStoreKey))
// {
// var dbReader = reader.DBReader;
// while (dbReader.Read())
// {
// var dataItem = new QuestionDataModel();
// dataItem.QuestionId = (int?)dbReader[QuestionDataModel.DataColumns.QuestionId];
// dataItem.QuestionPhrase = dbReader[QuestionDataModel.DataColumns.QuestionPhrase].ToString();
// dataItem.Category = dbReader[QuestionDataModel.DataColumns.Category].ToString();
// dataItem.QuestionCategoryId = (int?)dbReader[QuestionDataModel.DataColumns.QuestionCategoryId];
// dataItem.SortOrder = (int?)dbReader[QuestionDataModel.DataColumns.SortOrder];
// SetBaseInfo(dataItem, dbReader);
// result.Add(dataItem);
// }
// }
// return result;
//}
#endregion GetDetails
#region Create
public static void Create(QuestionDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Create");
DBDML.RunSQL("Question.Insert", sql, DataStoreKey);
}
public static void Update(TabChildStructureDataModel data, RequestProfile requestProfile)
{
var sql = CreateOrUpdate(data, requestProfile, "Update");
DBDML.RunSQL("TabChildStructure.Update", sql, DataStoreKey);
}
public static void Update(PriceScheduleDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("PriceSchedule.Update", sql, DataStoreKey);
}
public static void Update(ApplicationUserTitleDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("ApplicationUserTitle.Update", sql, DataStoreKey);
}
public static void Update(NotificationPublisherDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("NotificationPublisher.Update", sql, DataStoreKey);
}
public static void Update(ReportCategoryDataModel data, RequestProfile requestProfile)
{
var sql = CreateOrUpdate(data, requestProfile, "Update");
DBDML.RunSQL("ReportCategory.Update", sql, DataStoreKey);
}
public static void Update(MonumentDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("Monument.Update", sql, DataStoreKey);
}
public static void Create(CountryDataModel data, RequestProfile requestProfile)
{
var sql = CreateOrUpdate(data, requestProfile, "Create");
DBDML.RunSQL("Country.Insert", sql, DataStoreKey);
}
