public bool IsValueAlreadyExist(string tableName, string fieldName, string originalvalue, string currentValue, BTSS.Common.Core.Operation operation) { try { return datasource.IsValueAlreadyExist(tableName, fieldName, originalvalue, currentValue, operation); } catch (Exception) { throw; } }
public static bool IsValueAlreadyExist(string connectionString, BTSS.Common.Core.DataProvider provider, string tableName, string fieldName, string originalvalue, string currentValue, BTSS.Common.Core.Operation operation) { try { Data.Common common = new BTSS.Data.Common(connectionString, provider); return common.IsValueAlreadyExist(tableName, fieldName, originalvalue, currentValue, operation); } catch (Exception) { throw; } }
public static bool IsCodeExist(string originalValue, string currentValue, string table, string field, BTSS.Common.Core.Operation operation) { try { BTSSContext ctx = new BTSSContext(BTSS.Common.Core.ConnectionString); return ctx.IsCodeExist(originalValue, currentValue, table, field, operation.ToString()).FirstOrDefault().IsExist.Value; } catch (Exception) { throw; } }
public object GetValue(BTSS.Common.Core.Preferences preferences) { try { var row = from s in ctx.Preferences where s.Tag == preferences.ToString() select new { s.Value }; if (row.Count() > 0 ) return row.FirstOrDefault().Value; else return ""; } catch (Exception) { throw; } }
private void userControlButtonsMain_OnButtonClick(EventArgs e, ref bool isOk, BTSS.Common.UserControls.UserControlButtonsMain.ButtonClick button, Bitmap icon) { try { switch (button) { case BTSS.Common.UserControls.UserControlButtonsMain.ButtonClick.New: isOk = New(icon); break; case BTSS.Common.UserControls.UserControlButtonsMain.ButtonClick.Edit: isOk = Edit(icon); break; case BTSS.Common.UserControls.UserControlButtonsMain.ButtonClick.View: isOk = View(icon); break; case BTSS.Common.UserControls.UserControlButtonsMain.ButtonClick.Delete: isOk = Delete(); break; case BTSS.Common.UserControls.UserControlButtonsMain.ButtonClick.Refresh: RefreshListing(); break; case BTSS.Common.UserControls.UserControlButtonsMain.ButtonClick.Close: OnCloseControl(_tabPage); break; } } catch (Exception) { throw; } }
private void userControlButtonsSave_OnButtonClick(EventArgs e, ref bool isOk, BTSS.Common.UserControls.UserControlButtonsSave.ButtonClick button) { try { switch (button) { case BTSS.Common.UserControls.UserControlButtonsSave.ButtonClick.Save: if (Save()) { if (Operation == BTSS.Common.Core.Operation.UPDATE) DialogResult = DialogResult.OK; } break; case BTSS.Common.UserControls.UserControlButtonsSave.ButtonClick.Cancel: DialogResult = DialogResult.Cancel; break; } } catch (Exception) { throw; } }
private string SaveSQL(BTSS.Logic.Projects.Module module) { string sql = ""; switch (module.Operation) { case BTSS.Common.Core.Operation.INSERT: module.Id = datasource.GetNextCode("set_module", "mod_id", "001"); sql = "INSERT INTO set_module (mod_id,mod_name,mod_desc)VALUES('" + module.Id + "','" + module.Name + "','" + module.Desc + "') "; break; case BTSS.Common.Core.Operation.UPDATE: sql = "UPDATE set_module SET mod_name = '" + module.Name + "', mod_desc = '" + module.Desc + "' WHERE mod_id = '" + module.Id + "' "; break; case BTSS.Common.Core.Operation.DELETE: sql = "DELETE FROM set_module WHERE mod_id = '" + module.Id + "' "; break; } if (provider == BTSS.Common.Core.DataProvider.SQL) { if (module.Operation != BTSS.Common.Core.Operation.DELETE) { if (module.Table.GetChanges() != null) { foreach (DataRow r in module.Table.GetChanges(DataRowState.Modified).Rows) { sql = sql + "\n" + "EXEC SaveModuleTableMap '" + r.Field<int?>("Id") + "','" + module.Id + "','" + r.Field<string>("table_name") + "'"; } } } } return sql; }
public Audit(string connectionString, BTSS.Common.Core.DataProvider provider) { audit = new BTSS.Data.Projects.Audit(connectionString,provider); }
public void Save(BTSS.Logic.Projects.Module module) { try { datasource.ExecuteScalar(SaveSQL(module)); } catch (Exception) { throw; } }
public Module(string connectionString, BTSS.Common.Core.DataProvider provider) { this.provider = provider; datasource = new BTSS.Data.Datasource(connectionString, provider); }
public Common(string connectionString, BTSS.Common.Core.DataProvider provider) { datasource = new Datasource(connectionString, provider); }
public Group(string connectionString, BTSS.Common.Core.DataProvider provider) { group = new BTSS.Data.Projects.Group(connectionString,provider); }
public Module(string connectionString, BTSS.Common.Core.DataProvider provider) { module = new BTSS.Data.Projects.Module(connectionString, provider); }
public GetAccessRightsResult GetAccessRights(string userId, BTSS.Common.Core.Module module) { try { return ctx.GetAccessRights(userId, module.ToString()).ToList<GetAccessRightsResult>().FirstOrDefault(); } catch (Exception) { throw; } }
public User(string connectionString, BTSS.Common.Core.DataProvider provider) { user = new BTSS.Data.Projects.User(connectionString, provider); }