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