internal static void AddSubGroupField(Model.Archive.ArchiveDataClassesDataContext dc, Model.Common.ArchiveGroupSubGroupField archiveGroupSubGroupField)
{
Model.Archive.ArchiveField archiveField = dc.ArchiveFields.Where(t => t.IDParent == archiveGroupSubGroupField.ArchiveGroupFieldID).Single();
int index = 1;
if (archiveField.ArchiveSubGroupFields.Count > 0)
{
index = (archiveField.ArchiveSubGroupFields.Max(t => t.Index) + 1);
}
if (FieldNameAlreadyExist(dc, archiveField.ID, archiveGroupSubGroupField.Label))
{
throw new Exception(string.Format("فیلد '{0}' در زیرگروه جدولی '{1}' وجود دارد. لطفا نام دیگری انتخاب کنید", archiveGroupSubGroupField.Label, archiveField.Label));
}
Model.Archive.ArchiveSubGroupField archiveSubGroupField = Model.Archive.ArchiveSubGroupField.GetNewInstance(archiveField.ID, archiveGroupSubGroupField.Label, null, archiveGroupSubGroupField.FieldTypeCode, archiveGroupSubGroupField.StatusCode, archiveGroupSubGroupField.BoxTypeCode, archiveGroupSubGroupField.AutoComplete, archiveGroupSubGroupField.MinLength, archiveGroupSubGroupField.MaxLength, archiveGroupSubGroupField.MinValue, archiveGroupSubGroupField.MaxValue, archiveGroupSubGroupField.DefaultValue, archiveGroupSubGroupField.ID, index);
dc.ArchiveSubGroupFields.InsertOnSubmit(archiveSubGroupField);
dc.SubmitChanges();
SqlHelper.CreateFieldForSubGroupField(dc, archiveSubGroupField);
try
{
Setting.User.ThisProgram.AddLog(Setting.User.UserOparatesPlaceNames.بایگانی, Setting.User.UserOparatesNames.ثبت, null, "افزودن فیلد '" + archiveSubGroupField.Label + "' به فیلد '" + archiveField.Label + "' در گروه اطلاعاتی '" + archiveField.ArchiveTab.Title + "' در بایگانی '" + dc.GetArchive().Title + "'");
}
catch
{
throw new Exception("خطا در ذخیره عملکرد کاربر جاری");
}
}
internal static void DeleteSubGroupField(Model.Archive.ArchiveDataClassesDataContext dc, Model.Common.ArchiveGroupSubGroupField archiveGroupSubGroupField)
{
Model.Archive.ArchiveSubGroupField archiveSubGroupField = dc.ArchiveSubGroupFields.Where(t => t.IDParent == archiveGroupSubGroupField.ID).Single();
string originalLabel = archiveSubGroupField.Label;
string originalArchiveFieldLabel = archiveSubGroupField.ArchiveField.Label;
string originalArchiveTabTitle = archiveSubGroupField.ArchiveField.ArchiveTab.Title;
archiveSubGroupField.IDParent = null;
dc.SubmitChanges();
}
internal static void UpdateSubGroupField(Model.Archive.ArchiveDataClassesDataContext dc, Model.Common.ArchiveGroupSubGroupField archiveGroupSubGroupField)
{
Model.Archive.ArchiveSubGroupField originalArchiveSubGroupField = dc.ArchiveSubGroupFields.Where(t => t.IDParent == archiveGroupSubGroupField.ID).Single();
string originalLabel = originalArchiveSubGroupField.Label;
int originalBoxTypeCode = originalArchiveSubGroupField.BoxTypeCode;
string originalDefaultValue = originalArchiveSubGroupField.DefaultValue;
if (FieldNameAlreadyExist(dc, originalArchiveSubGroupField.ArchiveFieldID, archiveGroupSubGroupField.Label, originalArchiveSubGroupField.ID))
{
throw new Exception(string.Format("فیلد '{0}' در زیرگروه جدولی '{1}' وجود دارد. لطفا نام دیگری انتخاب کنید", archiveGroupSubGroupField.Label, originalArchiveSubGroupField.ArchiveField.Label));
}
Model.Archive.ArchiveSubGroupField archiveSubGroupField = Model.Archive.ArchiveSubGroupField.GetNewInstance(originalArchiveSubGroupField.ID, originalArchiveSubGroupField.ArchiveField.ID, archiveGroupSubGroupField.Label, originalArchiveSubGroupField.FieldName, archiveGroupSubGroupField.FieldTypeCode, archiveGroupSubGroupField.StatusCode, archiveGroupSubGroupField.BoxTypeCode, archiveGroupSubGroupField.AutoComplete, archiveGroupSubGroupField.MinLength, archiveGroupSubGroupField.MaxLength, archiveGroupSubGroupField.MinValue, archiveGroupSubGroupField.MaxValue, archiveGroupSubGroupField.DefaultValue, originalArchiveSubGroupField.IDParent, originalArchiveSubGroupField.Index);
Model.Archive.ArchiveSubGroupField.Copy(originalArchiveSubGroupField, archiveSubGroupField);
dc.SubmitChanges();
SqlHelper.UpdateGroupField(dc, originalArchiveSubGroupField, (Enums.BoxTypes)originalBoxTypeCode, originalDefaultValue);
try
{
Setting.User.ThisProgram.AddLog(Setting.User.UserOparatesPlaceNames.بایگانی, Setting.User.UserOparatesNames.ویرایش, null, "ویرایش فیلد '" + originalLabel + "' در فیلد '" + originalArchiveSubGroupField.ArchiveField.Label + "' در گروه اطلاعاتی '" + originalArchiveSubGroupField.ArchiveField.ArchiveTab.Title + "' در بایگانی '" + dc.GetArchive().Title + "'");
}
catch
{
throw new Exception("خطا در ذخیره عملکرد کاربر جاری");
}
}
internal static int AddSubGroupField(Field field, int archiveGroupFieldID)
{
Model.Common.ArchiveCommonDataClassesDataContext commonDataContext = new Model.Common.ArchiveCommonDataClassesDataContext(Setting.Sql.ThisProgram.DatabaseConnection.ConnectionString);
List <Model.Archive.ArchiveDataClassesDataContext> archivesDataContext = new List <Model.Archive.ArchiveDataClassesDataContext>();
try
{
commonDataContext.Connection.Open();
commonDataContext.Transaction = commonDataContext.Connection.BeginTransaction();
Model.Common.ArchiveGroupField archiveGroupField = commonDataContext.ArchiveGroupFields.Where(t => t.ID == archiveGroupFieldID).Single();
IEnumerable <string> archivesConnections = Controller.Common.ArchiveGroupTabController.GetArchivesConnectionStrings(archiveGroupField.ArchiveGroupTabID);
foreach (string connectionString in archivesConnections)
{
Model.Archive.ArchiveDataClassesDataContext dcArchive = new Model.Archive.ArchiveDataClassesDataContext(connectionString);
dcArchive.Connection.Open();
dcArchive.Transaction = dcArchive.Connection.BeginTransaction();
archivesDataContext.Add(dcArchive);
}
CheckSubGroupFieldName(commonDataContext, archivesDataContext, field.Label, archiveGroupFieldID);
int index = 1;
if (archiveGroupField.ArchiveGroupSubGroupFields.Count > 0)
{
index = archiveGroupField.ArchiveGroupSubGroupFields.Max(t => t.Index) + 1;
}
Model.Common.ArchiveGroupSubGroupField archiveGroupSubGroupField = Model.Common.ArchiveGroupSubGroupField.GetNewInstance(archiveGroupFieldID, field.Label, field.FieldName, field.FieldTypeCode, field.StatusCode, field.BoxTypeCode, field.AutoComplete, field.MinLength, field.MaxLength, field.MinValue, field.MaxValue, field.DefaultValue, index);
commonDataContext.ArchiveGroupSubGroupFields.InsertOnSubmit(archiveGroupSubGroupField);
commonDataContext.SubmitChanges();
try
{
Setting.User.ThisProgram.AddLog(Setting.User.UserOparatesPlaceNames.گروه_بایگانی, Setting.User.UserOparatesNames.ثبت, null, "افزودن فیلد '" + archiveGroupSubGroupField.Label + "' به فیلد '" + archiveGroupField.Label + "' در گروه اطلاعاتی '" + archiveGroupField.ArchiveGroupTab.Title + "'");
}
catch
{
throw new Exception("خطا در ذخیره عملکرد کاربر جاری");
}
foreach (var dcArchive in archivesDataContext)
{
Controller.Archive.ArchiveSubGroupFieldController.AddSubGroupField(dcArchive, archiveGroupSubGroupField);
}
commonDataContext.Transaction.Commit();
foreach (var dcArchive in archivesDataContext)
{
dcArchive.Transaction.Commit();
}
return(archiveGroupSubGroupField.ID);
}
catch
{
commonDataContext.Transaction.Rollback();
foreach (var dcArchive in archivesDataContext)
{
dcArchive.Transaction.Rollback();
}
throw;
}
finally
{
foreach (var dcArchive in archivesDataContext)
{
if (dcArchive.Connection.State == System.Data.ConnectionState.Open)
{
dcArchive.Connection.Close();
}
}
if (commonDataContext.Connection.State == System.Data.ConnectionState.Open)
{
commonDataContext.Connection.Close();
}
}
}
internal static void UpdateSubGroupField(int originalArchiveGroupSubGroupFieldID, Field field)
{
Model.Common.ArchiveCommonDataClassesDataContext commonDataContext = new Model.Common.ArchiveCommonDataClassesDataContext(Setting.Sql.ThisProgram.DatabaseConnection.ConnectionString);
List <Model.Archive.ArchiveDataClassesDataContext> archivesDataContext = new List <Model.Archive.ArchiveDataClassesDataContext>();
try
{
commonDataContext.Connection.Open();
commonDataContext.Transaction = commonDataContext.Connection.BeginTransaction();
Model.Common.ArchiveGroupSubGroupField originalArchiveGroupSubGroupField = commonDataContext.ArchiveGroupSubGroupFields.Where(t => t.ID == originalArchiveGroupSubGroupFieldID).Single();
string originalLabel = originalArchiveGroupSubGroupField.Label;
string originalGroupFieldLabel = originalArchiveGroupSubGroupField.ArchiveGroupField.Label;
string originalGroupTabTitle = originalArchiveGroupSubGroupField.ArchiveGroupField.ArchiveGroupTab.Title;
IEnumerable <string> archivesConnections = Controller.Common.ArchiveGroupTabController.GetArchivesConnectionStrings(originalArchiveGroupSubGroupField.ArchiveGroupField.ArchiveGroupTabID);
foreach (string connectionString in archivesConnections)
{
Model.Archive.ArchiveDataClassesDataContext dcArchive = new Model.Archive.ArchiveDataClassesDataContext(connectionString);
dcArchive.Connection.Open();
dcArchive.Transaction = dcArchive.Connection.BeginTransaction();
archivesDataContext.Add(dcArchive);
}
CheckSubGroupFieldName(commonDataContext, archivesDataContext, field.Label, originalArchiveGroupSubGroupField.ArchiveGroupFieldID, originalArchiveGroupSubGroupField.ID);
Model.Common.ArchiveGroupSubGroupField archiveSubGroupField = Model.Common.ArchiveGroupSubGroupField.GetNewInstance(originalArchiveGroupSubGroupField.ArchiveGroupField.ID, field.Label, originalArchiveGroupSubGroupField.FieldName, field.FieldTypeCode, field.StatusCode, field.BoxTypeCode, field.AutoComplete, field.MinLength, field.MaxLength, field.MinValue, field.MaxValue, field.DefaultValue, originalArchiveGroupSubGroupField.Index);
Model.Common.ArchiveGroupSubGroupField.Copy(originalArchiveGroupSubGroupField, archiveSubGroupField);
commonDataContext.SubmitChanges();
try
{
Setting.User.ThisProgram.AddLog(Setting.User.UserOparatesPlaceNames.گروه_بایگانی, Setting.User.UserOparatesNames.ویرایش, null, "ویرایش فیلد '" + originalLabel + "' در فیلد '" + originalGroupFieldLabel + "' در گروه اطلاعاتی '" + originalGroupTabTitle + "'");
}
catch
{
throw new Exception("خطا در ذخیره عملکرد کاربر جاری");
}
foreach (var dcArchive in archivesDataContext)
{
Controller.Archive.ArchiveSubGroupFieldController.UpdateSubGroupField(dcArchive, originalArchiveGroupSubGroupField);
}
commonDataContext.Transaction.Commit();
foreach (var dcArchive in archivesDataContext)
{
dcArchive.Transaction.Commit();
}
}
catch
{
commonDataContext.Transaction.Rollback();
foreach (var dcArchive in archivesDataContext)
{
dcArchive.Transaction.Rollback();
}
throw;
}
finally
{
foreach (var dcArchive in archivesDataContext)
{
if (dcArchive.Connection.State == System.Data.ConnectionState.Open)
{
dcArchive.Connection.Close();
}
}
if (commonDataContext.Connection.State == System.Data.ConnectionState.Open)
{
commonDataContext.Connection.Close();
}
}
}
internal static void DeleteSubGroupField(int archiveGroupSubGroupFieldID)
{
Model.Common.ArchiveCommonDataClassesDataContext commonDataContext = new Model.Common.ArchiveCommonDataClassesDataContext(Setting.Sql.ThisProgram.DatabaseConnection.ConnectionString);
List <Model.Archive.ArchiveDataClassesDataContext> archivesDataContext = new List <Model.Archive.ArchiveDataClassesDataContext>();
try
{
commonDataContext.Connection.Open();
commonDataContext.Transaction = commonDataContext.Connection.BeginTransaction();
Model.Common.ArchiveGroupSubGroupField archiveGroupSubGroupField = commonDataContext.ArchiveGroupSubGroupFields.Where(t => t.ID == archiveGroupSubGroupFieldID).Single();
string originalLabel = archiveGroupSubGroupField.Label;
string originalGroupFieldLabel = archiveGroupSubGroupField.ArchiveGroupField.Label;
string originalGroupTabTitle = archiveGroupSubGroupField.ArchiveGroupField.ArchiveGroupTab.Title;
IEnumerable <string> archivesConnections = Controller.Common.ArchiveGroupTabController.GetArchivesConnectionStrings(archiveGroupSubGroupField.ArchiveGroupField.ArchiveGroupTabID);
foreach (string connectionString in archivesConnections)
{
Model.Archive.ArchiveDataClassesDataContext dcArchive = new Model.Archive.ArchiveDataClassesDataContext(connectionString);
dcArchive.Connection.Open();
dcArchive.Transaction = dcArchive.Connection.BeginTransaction();
archivesDataContext.Add(dcArchive);
}
foreach (var dcArchive in archivesDataContext)
{
Controller.Archive.ArchiveSubGroupFieldController.DeleteSubGroupField(dcArchive, archiveGroupSubGroupField);
}
commonDataContext.ArchiveGroupSubGroupFields.DeleteOnSubmit(archiveGroupSubGroupField);
commonDataContext.SubmitChanges();
try
{
Setting.User.ThisProgram.AddLog(Setting.User.UserOparatesPlaceNames.گروه_بایگانی, Setting.User.UserOparatesNames.حذف, null, "حذف فیلد '" + originalLabel + "' در فیلد '" + originalGroupFieldLabel + "' در گروه اطلاعاتی '" + originalGroupTabTitle + "'");
}
catch
{
throw new Exception("خطا در ذخیره عملکرد کاربر جاری");
}
commonDataContext.Transaction.Commit();
foreach (var dcArchive in archivesDataContext)
{
dcArchive.Transaction.Commit();
}
}
catch
{
commonDataContext.Transaction.Rollback();
foreach (var dcArchive in archivesDataContext)
{
dcArchive.Transaction.Rollback();
}
throw;
}
finally
{
foreach (var dcArchive in archivesDataContext)
{
if (dcArchive.Connection.State == System.Data.ConnectionState.Open)
{
dcArchive.Connection.Close();
}
}
if (commonDataContext.Connection.State == System.Data.ConnectionState.Open)
{
commonDataContext.Connection.Close();
}
}
}
