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); }