public static void Insert(Model.Archive.ArchiveTab archiveTab)
{
Model.Archive.ArchiveDataClassesDataContext dc = Model.Archive.ArchiveDataClassesDataContext.GetNewInstance();
dc.Connection.Open();
dc.Transaction = dc.Connection.BeginTransaction();
try
{
archiveTab.Index = dc.ArchiveTabs.Count() == 0 ? 1 : (dc.ArchiveTabs.Select(t => t.Index).Max() + 1);
dc.ArchiveTabs.InsertOnSubmit(archiveTab);
dc.SubmitChanges();
dc.Transaction.Commit();
dc.Connection.Close();
SqlHelper.CreateTableForArchiveTab(dc, archiveTab);
archiveTab.Exist = true;
dc.SubmitChanges();
if (archiveTab.TypeCode == (int)Enums.TabTypes.Dossier)
{
Setting.User.ThisProgram.AddLog(Setting.User.UserOparatesPlaceNames.گروه_اطلاعاتی_پرونده, Setting.User.UserOparatesNames.ثبت, null, "ثبت گروه اطلاعاتی '" + archiveTab.Title + "' در بایگانی '" + dc.GetArchive().Title + "'");
}
else
{
Setting.User.ThisProgram.AddLog(Setting.User.UserOparatesPlaceNames.گروه_اطلاعاتی_سند, Setting.User.UserOparatesNames.ثبت, null, "ثبت گروه اطلاعاتی '" + archiveTab.Title + "' در بایگانی '" + dc.GetArchive().Title + "'");
}
}
catch (Exception ex)
{
dc.Transaction.Rollback();
dc.Connection.Close();
throw new Exception("خطا در ثبت اطلاعات" + "\r\n\r\n" + ex.Message);
}
}
internal static void InsertOrUpdate(Model.Archive.Info info, Model.Archive.ArchiveDataClassesDataContext dc)
{
try
{
if (info == null)
{
return;
}
var query = dc.Infos.Where(t => t.PersonnelNumber == info.PersonnelNumber);
if (query.Count() == 1)
{
var originalInfo = query.Single();
Model.Archive.Info.Copy(originalInfo, info);
dc.SubmitChanges();
}
else
{
dc.Infos.InsertOnSubmit(info);
dc.SubmitChanges();
}
}
catch (Exception ex)
{
throw new Exception("خطا در ثبت اطلاعات" + "\r\n\r\n" + ex.Message);
}
}
internal static void DeleteField(int archiveFieldID)
{
Model.Archive.ArchiveDataClassesDataContext dc = new Model.Archive.ArchiveDataClassesDataContext(Setting.Sql.ThisProgram.ArchiveConnection.ConnectionString);
dc.Connection.Open();
dc.Transaction = dc.Connection.BeginTransaction();
try
{
Model.Archive.ArchiveField originalArchiveField = dc.ArchiveFields.Where(t => t.ID == archiveFieldID).Single();
string originalLabel = originalArchiveField.Label;
string originalTabTitle = originalArchiveField.ArchiveTab.Title;
if (originalArchiveField.IDParent.HasValue)
{
originalArchiveField.IDParent = null;
dc.SubmitChanges();
foreach (var item in dc.ArchiveSubGroupFields.Where(t => t.ArchiveFieldID == originalArchiveField.ID))
{
item.IDParent = null;
}
dc.SubmitChanges();
}
else
{
SqlHelper.DeleteArchiveField(dc, originalArchiveField);
dc.ArchiveSubGroupFields.DeleteAllOnSubmit(originalArchiveField.ArchiveSubGroupFields);
dc.SubmitChanges();
dc.CounterFieldSettings.DeleteAllOnSubmit(originalArchiveField.CounterFieldSettings);
dc.SubmitChanges();
dc.ArchiveFields.DeleteOnSubmit(originalArchiveField);
dc.SubmitChanges();
try
{
Setting.User.ThisProgram.AddLog(Setting.User.UserOparatesPlaceNames.بایگانی, Setting.User.UserOparatesNames.حذف, null, "حذف فیلد '" + originalLabel + "' در گروه اطلاعاتی '" + originalTabTitle + "' در بایگانی '" + dc.GetArchive().Title + "'");
}
catch
{
throw new Exception("خطا در ذخیره عملکرد کاربر جاری");
}
}
dc.Transaction.Commit();
dc.Connection.Close();
}
catch
{
dc.Transaction.Rollback();
dc.Connection.Close();
throw;
}
finally
{
if (dc.Connection.State == System.Data.ConnectionState.Open)
{
dc.Connection.Close();
}
}
}
internal static int AddField(Field field, int archiveTabID)
{
Model.Archive.ArchiveDataClassesDataContext dc = new Model.Archive.ArchiveDataClassesDataContext(Setting.Sql.ThisProgram.ArchiveConnection.ConnectionString);
dc.Connection.Open();
dc.Transaction = dc.Connection.BeginTransaction();
try
{
Model.Archive.ArchiveTab archiveTab = dc.ArchiveTabs.Where(t => t.ID == archiveTabID).Single();
if (ArchiveFieldController.FieldNameAlreadyExist(dc, archiveTabID, field.Label))
{
throw new Exception(string.Format("فیلد '{0}' در گروه اطلاعاتی '{1}' وجود دارد. لطفا نام دیگری انتخاب کنید", field.Label, archiveTab.Title));
}
if (archiveTab.Exist == false)
{
SqlHelper.CreateTableForArchiveTab(dc, archiveTab);
archiveTab.Exist = true;
dc.SubmitChanges();
}
int index = 1;
if (archiveTab.ArchiveFields.Count > 0)
{
index = archiveTab.ArchiveFields.Max(t => t.Index) + 1;
}
Model.Archive.ArchiveField archiveField = Model.Archive.ArchiveField.GetNewInstance(archiveTab.ID, field.Label, field.FieldName, field.FieldTypeCode, field.StatusCode, field.BoxTypeCode, field.AutoComplete, field.MinLength, field.MaxLength, field.MinValue, field.MaxValue, field.DefaultValue, null, index);
dc.ArchiveFields.InsertOnSubmit(archiveField);
dc.SubmitChanges();
SqlHelper.CreateArchiveField(dc, archiveField);
try
{
Setting.User.ThisProgram.AddLog(Setting.User.UserOparatesPlaceNames.بایگانی, Setting.User.UserOparatesNames.ثبت, null, "افزودن فیلد '" + archiveField.Label + "' به گروه اطلاعاتی '" + archiveField.ArchiveTab.Title + "' در بایگانی '" + dc.GetArchive().Title + "'");
}
catch
{
throw new Exception("خطا در ذخیره عملکرد کاربر جاری");
}
dc.Transaction.Commit();
dc.Connection.Close();
return(archiveField.ID);
}
catch
{
dc.Transaction.Rollback();
dc.Connection.Close();
throw;
}
finally
{
if (dc.Connection.State == System.Data.ConnectionState.Open)
{
dc.Connection.Close();
}
}
}
private static void DeleteReport(Model.Archive.ArchiveDataClassesDataContext dc, int reportID)
{
dc.DisplayFields.DeleteAllOnSubmit(dc.DisplayFields.Where(t => t.ReportID == reportID));
dc.SubmitChanges();
foreach (Model.Archive.ReportDetail item in dc.ReportDetails.Where(t => t.ReportID == reportID && t.ParentID == null))
{
DeleteReportDetails(dc, item);
dc.ReportDetails.DeleteOnSubmit(item);
dc.SubmitChanges();
}
dc.Reports.DeleteOnSubmit(dc.Reports.Where(t => t.ID == reportID).Single());
dc.SubmitChanges();
}
internal static void DeleteSubGroupField(int id)
{
Model.Archive.ArchiveDataClassesDataContext dc = Model.Archive.ArchiveDataClassesDataContext.GetNewInstance();
dc.Connection.Open();
dc.Transaction = dc.Connection.BeginTransaction();
try
{
Model.Archive.ArchiveSubGroupField archiveSubGroupField = dc.ArchiveSubGroupFields.Where(t => t.ID == id).Single();
string originalLabel = archiveSubGroupField.Label;
string originalArchiveFieldLabel = archiveSubGroupField.ArchiveField.Label;
string originalArchiveTabTitle = archiveSubGroupField.ArchiveField.ArchiveTab.Title;
if (archiveSubGroupField.IDParent.HasValue)
{
archiveSubGroupField.IDParent = null;
dc.SubmitChanges();
}
else
{
SqlHelper.DeleteGroupField(dc, archiveSubGroupField);
dc.ArchiveSubGroupFields.DeleteOnSubmit(archiveSubGroupField);
dc.SubmitChanges();
try
{
Setting.User.ThisProgram.AddLog(Setting.User.UserOparatesPlaceNames.بایگانی, Setting.User.UserOparatesNames.حذف, null, "حذف فیلد '" + originalLabel + "' در فیلد '" + originalArchiveFieldLabel + "' در گروه اطلاعاتی '" + originalArchiveTabTitle + "' در بایگانی '" + dc.GetArchive().Title + "'");
}
catch
{
throw new Exception("خطا در ذخیره عملکرد کاربر جاری");
}
}
dc.Transaction.Commit();
dc.Connection.Close();
}
catch
{
dc.Transaction.Rollback();
dc.Connection.Close();
throw;
}
finally
{
if (dc.Connection.State == System.Data.ConnectionState.Open)
{
dc.Connection.Close();
}
}
}
public static void Insert(Model.Archive.Info info)
{
if (info == null)
{
return;
}
Model.Archive.ArchiveDataClassesDataContext dc = Model.Archive.ArchiveDataClassesDataContext.GetNewInstance();
dc.Connection.Open();
dc.Transaction = dc.Connection.BeginTransaction();
try
{
dc.Infos.InsertOnSubmit(info);
dc.SubmitChanges();
dc.Transaction.Commit();
}
catch (Exception ex)
{
dc.Transaction.Rollback();
throw new Exception("خطا در ثبت اطلاعات" + "\r\n\r\n" + ex.Message);
}
finally
{
dc.Connection.Close();
}
}
public static void AddArchiveTabToArchive(Model.Common.ArchiveGroupTab archiveGroupTab, Model.Common.ArchiveCommonDataClassesDataContext dc, Model.Archive.ArchiveDataClassesDataContext archiveDC)
{
if (archiveDC.ArchiveTabs.Where(t => t.TypeCode == archiveGroupTab.TypeCode && t.Title == archiveGroupTab.Title && t.Deleted == false).Count() > 0)
{
throw new Exception(" گروه اطلاعاتی '" + archiveGroupTab.Title + "' در بایگانی '" + dc.Archives.Where(t => t.Name == archiveDC.Connection.Database).Select(t => t.Title).Single() + "' وجود دارد لطفا نام دیگری را انتخاب کنید ");
}
Model.Archive.ArchiveTab archiveTab = Model.Archive.ArchiveTab.GetNewInstance(archiveGroupTab.TypeCode, 0, null, archiveGroupTab.Title, true, false, archiveGroupTab.ID, false);
Controller.Archive.ArchiveTabController.Insert(archiveTab, archiveDC);
archiveDC.SubmitChanges();
SqlHelper.CreateTableForArchiveTab(archiveDC, archiveTab);
foreach (Model.Common.ArchiveGroupField field in Controller.Common.ArchiveGroupTabController.GetArchiveGroupFields(dc, archiveGroupTab.ID, archiveGroupTab.ArchiveGroupID))
{
Controller.Archive.ArchiveFieldController.AddField(archiveDC, field);
foreach (Model.Common.ArchiveGroupSubGroupField subField in Controller.Common.ArchiveGroupFieldController.GetArchiveGroupSubGroupFields(dc, field.ID))
{
Controller.Archive.ArchiveSubGroupFieldController.AddSubGroupField(archiveDC, subField);
}
}
if (archiveGroupTab.TypeCode == (int)Enums.TabTypes.Dossier)
{
Setting.User.ThisProgram.AddLog(dc, Setting.User.UserOparatesPlaceNames.گروه_اطلاعاتی_پرونده, Setting.User.UserOparatesNames.ثبت, null, "ثبت گروه اطلاعاتی '" + archiveTab.Title + "' در بایگانی '" + archiveDC.GetArchive().Title + "'");
}
else
{
Setting.User.ThisProgram.AddLog(dc, Setting.User.UserOparatesPlaceNames.گروه_اطلاعاتی_سند, Setting.User.UserOparatesNames.ثبت, null, "ثبت گروه اطلاعاتی '" + archiveTab.Title + "' در بایگانی '" + archiveDC.GetArchive().Title + "'");
}
}
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 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 void SetDisplayField(int archiveFieldID, bool value, Enums.DisplayFieldCodes code)
{
Model.Archive.ArchiveDataClassesDataContext dc = Model.Archive.ArchiveDataClassesDataContext.GetNewInstance();
if (value)
{
if (dc.DisplayFields.Where(t => t.ArchiveFieldID == archiveFieldID && t.Code == (int)code).Count() == 0)
{
dc.DisplayFields.InsertOnSubmit(Model.Archive.DisplayField.GetNewInstance((int)code, null, archiveFieldID));
dc.SubmitChanges();
}
}
else
{
dc.DisplayFields.DeleteAllOnSubmit(dc.DisplayFields.Where(t => t.ArchiveFieldID == archiveFieldID && t.Code == (int)code));
dc.SubmitChanges();
}
}
internal static void SetCounterFieldProperties(Model.Archive.ArchiveDataClassesDataContext dc, int archiveFieldID, int fixedValueType, string fixedValue, string separator)
{
if (dc.CounterFieldSettings.Where(t => t.ArchiveFieldID == archiveFieldID).Count() > 0)
{
Model.Archive.CounterFieldSetting obj = dc.CounterFieldSettings.Where(t => t.ArchiveFieldID == archiveFieldID).Single();
obj.FixedValueType = fixedValueType;
obj.FixedValue = fixedValue;
obj.Separator = separator;
dc.SubmitChanges();
}
else
{
Model.Archive.CounterFieldSetting obj = Model.Archive.CounterFieldSetting.GetNewInstance(archiveFieldID, fixedValueType, fixedValue, separator);
dc.CounterFieldSettings.InsertOnSubmit(obj);
dc.SubmitChanges();
}
}
internal static void DeleteField(Model.Archive.ArchiveDataClassesDataContext dc, Model.Common.ArchiveGroupField archiveGroupField)
{
Model.Archive.ArchiveField originalArchiveField = dc.ArchiveFields.Where(t => t.IDParent == archiveGroupField.ID).Single();
string originalLabel = originalArchiveField.Label;
string originalTabTitle = originalArchiveField.ArchiveTab.Title;
if (originalArchiveField.IDParent.HasValue)
{
originalArchiveField.IDParent = null;
dc.SubmitChanges();
foreach (var item in dc.ArchiveSubGroupFields.Where(t => t.ArchiveFieldID == originalArchiveField.ID))
{
item.IDParent = null;
}
dc.SubmitChanges();
Model.Common.CounterFieldSetting archiveGroupFieldCounterSetting = Controller.Common.ArchiveGroupFieldController.GetCounterFieldProperties(archiveGroupField.ID);
if (archiveGroupFieldCounterSetting != null)
{
Controller.Archive.ArchiveFieldController.SetCounterFieldProperties(dc, originalArchiveField.ID, archiveGroupFieldCounterSetting.FixedValueType, archiveGroupFieldCounterSetting.FixedValue, archiveGroupFieldCounterSetting.Separator);
}
}
else
{
SqlHelper.DeleteArchiveField(dc, originalArchiveField);
dc.ArchiveSubGroupFields.DeleteAllOnSubmit(originalArchiveField.ArchiveSubGroupFields);
dc.SubmitChanges();
dc.CounterFieldSettings.DeleteAllOnSubmit(originalArchiveField.CounterFieldSettings);
dc.SubmitChanges();
dc.ArchiveFields.DeleteOnSubmit(originalArchiveField);
dc.SubmitChanges();
try
{
Setting.User.ThisProgram.AddLog(Setting.User.UserOparatesPlaceNames.بایگانی, Setting.User.UserOparatesNames.حذف, null, "حذف فیلد '" + originalLabel + "' در گروه اطلاعاتی '" + originalTabTitle + "' در بایگانی '" + 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();
}
private static void AddDetailToDetail(Model.Archive.ArchiveDataClassesDataContext dc, Model.Archive.ReportDetail reportDetail, SearchField searchField)
{
Model.Archive.ReportDetail newReportDetail = Model.Archive.ReportDetail.GetNewInstance(null, searchField.Field.ID, (int)searchField.Relation, searchField.Method.Code, searchField.Value, reportDetail.ID);
dc.ReportDetails.InsertOnSubmit(newReportDetail);
dc.SubmitChanges();
foreach (var item in searchField.SearchFields)
{
AddDetailToDetail(dc, newReportDetail, item);
}
}
internal static void UpdateSubGroupFieldsIndex(Dictionary <int, int> list)
{
Model.Archive.ArchiveDataClassesDataContext dc = new Model.Archive.ArchiveDataClassesDataContext(Setting.Sql.ThisProgram.ArchiveConnection.ConnectionString);
foreach (var id in list.Keys)
{
var item = dc.ArchiveSubGroupFields.Where(t => t.ID == id).Single();
item.Index = list[id];
}
dc.SubmitChanges();
}
private static void DeleteReportDetails(Model.Archive.ArchiveDataClassesDataContext dc, Model.Archive.ReportDetail reportDetail)
{
foreach (var item in dc.ReportDetails.Where(t => t.ParentID == reportDetail.ID))
{
DeleteReportDetails(dc, item);
dc.ReportDetails.DeleteOnSubmit(item);
dc.SubmitChanges();
}
}
internal static void Update(Model.Archive.ArchiveDataClassesDataContext dc, Model.Archive.Document document)
{
try
{
Model.Archive.Document.Copy(dc.Documents.Where(t => t.ID == document.ID).Single(), document);
dc.SubmitChanges();
}
catch (Exception ex)
{
throw new Exception("خطا در ثبت اطلاعات" + "\r\n\r\n" + ex.Message);
}
}
public static void Update(Model.Archive.Dossier dossier, Model.Archive.ArchiveDataClassesDataContext dc)
{
try
{
Model.Archive.Dossier.Copy(dc.Dossiers.Where(t => t.PersonnelNumber == dossier.PersonnelNumber).Single(), dossier);
dc.SubmitChanges();
}
catch (Exception ex)
{
throw new Exception("خطا در بروزرسانی اطلاعات" + "\r\n\r\n" + ex.Message);
}
}
public static void Insret(Model.Archive.Dossier dossier, Model.Archive.ArchiveDataClassesDataContext dc)
{
try
{
dc.Dossiers.InsertOnSubmit(dossier);
dc.SubmitChanges();
}
catch (Exception ex)
{
throw new Exception("خطا در ثبت اطلاعات" + "\r\n\r\n" + ex.Message);
}
}
internal static void Update(List <Model.Archive.ContactView> contactViewList, string personnelNumber, Model.Archive.ArchiveDataClassesDataContext dc)
{
dc.Contacts.DeleteAllOnSubmit(dc.Contacts.Where(t => t.PersonnelNumber == personnelNumber));
dc.SubmitChanges();
List <Model.Archive.Contact> contactList = new List <Model.Archive.Contact>();
foreach (var item in contactViewList)
{
contactList.Add(Model.Archive.Contact.GetNewInstance(item.PersonnelNumber, item.CallTypeID, item.Number, item.Comment));
}
Insert(contactList, dc);
}
internal static void Update(List <Model.Archive.AddressView> addressViewList, string personnelNumber, Model.Archive.ArchiveDataClassesDataContext dc)
{
dc.Addresses.DeleteAllOnSubmit(dc.Addresses.Where(t => t.PersonnelNumber == personnelNumber));
dc.SubmitChanges();
List <Model.Archive.Address> addressList = new List <Model.Archive.Address>();
foreach (var item in addressViewList)
{
addressList.Add(Model.Archive.Address.GetNewInstance(item.PersonnelNumber, item.AddressTypeID, item.ProvinceID, item.Township, item.MetropolitanAreaID, item.Street, item.Alley, item.PostalCode));
}
Insert(addressList, dc);
}
public static void Insert(List <Model.Archive.Contact> contact, Model.Archive.ArchiveDataClassesDataContext dcArchive)
{
try
{
dcArchive.Contacts.InsertAllOnSubmit(contact);
dcArchive.SubmitChanges();
}
catch (Exception ex)
{
throw new Exception("خطا در ثبت اطلاعات" + "\r\n\r\n" + ex.Message);
}
}
internal static void Delete(Model.Archive.ArchiveDataClassesDataContext dc, int id)
{
Model.Archive.Document doc = dc.Documents.Where(t => t.ID == id).Single();
Model.Archive.Dossier dossier = dc.Dossiers.Where(t => t.PersonnelNumber == doc.PersonnelNumber).Single();
int childCount = dc.Documents.Where(t => t.ParentDocumentID == id).Count();
if (childCount > 0)
{
throw new Exception("تعداد " + childCount.ToString() + " سند به عنوان ضمیمه به سند شماره " + doc.Index + " افزوده شده است" + "\r\n" + "برای حذف سند شماره " + doc.Index + " ابتدا باید سندهای ضمیمه را حذف کنید");
}
dc.Documents.DeleteOnSubmit(doc);
dc.SubmitChanges();
if (Setting.Archive.ThisProgram.LoadedArchiveSettings.UseDatabase)
{
try
{
Model.ArchiveDocument.DocumentDataClassesDataContext documentsDc = Model.ArchiveDocument.DocumentDataClassesDataContext.GetNewInstance(dossier.FilesPathOrDatabaseName);
documentsDc.Documents.DeleteAllOnSubmit(documentsDc.Documents.Where(t => t.ArchiveDocumentID == id));
documentsDc.SubmitChanges();
}
catch (Exception ex)
{
throw new Exception("خطا در حذف فایل سند شماره " + doc.Index + "\r\n" + ex.Message);
}
}
else
{
Njit.Common.SystemUtility sysUtil;
try
{
sysUtil = Njit.Program.Options.GetSystemUtility(dc.Connection as SqlConnection, Setting.Program.ThisProgram.NetworkName, Setting.Program.ThisProgram.NetworkPort);
}
catch (Exception ex)
{
throw new Exception("خطا در اتصال به سرور" + "\r\n" + ex.Message);
}
if (sysUtil.FileExists(Path.Combine(dossier.FilesPathOrDatabaseName, doc.FileName)))
{
try
{
//sysUtil.DeleteFile(Path.Combine(dossier.FilesPathOrDatabaseName, doc.FileName));
}
catch (Exception ex)
{
throw new Exception("خطا در حذف فایل سند شماره " + doc.Index + "\r\n" + ex.Message);
}
}
}
}
internal static void UpdateField(int originalArchiveFieldID, Field field)
{
Model.Archive.ArchiveDataClassesDataContext dc = new Model.Archive.ArchiveDataClassesDataContext(Setting.Sql.ThisProgram.ArchiveConnection.ConnectionString);
dc.Connection.Open();
dc.Transaction = dc.Connection.BeginTransaction();
try
{
Model.Archive.ArchiveField originalArchiveField = dc.ArchiveFields.Where(t => t.ID == originalArchiveFieldID).Single();
string originalLabel = originalArchiveField.Label;
string originalTabTitle = originalArchiveField.ArchiveTab.Title;
int originalBoxTypeCode = originalArchiveField.BoxTypeCode;
string originalDefaultValue = originalArchiveField.DefaultValue;
if (ArchiveFieldController.FieldNameAlreadyExist(dc, originalArchiveField.ArchiveTabID, field.Label, originalArchiveFieldID))
{
throw new Exception(string.Format("فیلد '{0}' در گروه اطلاعاتی '{1}' وجود دارد. لطفا نام دیگری انتخاب کنید", field.Label, originalArchiveField.ArchiveTab.Title));
}
Model.Archive.ArchiveField archiveField = Model.Archive.ArchiveField.GetNewInstance(originalArchiveField.ID, originalArchiveField.ArchiveTabID, field.Label, originalArchiveField.FieldName, field.FieldTypeCode, field.StatusCode, field.BoxTypeCode, field.AutoComplete, field.MinLength, field.MaxLength, field.MinValue, field.MaxValue, field.DefaultValue, originalArchiveField.IDParent, originalArchiveField.Index);
Model.Archive.ArchiveField.Copy(originalArchiveField, archiveField);
dc.SubmitChanges();
SqlHelper.UpdateArchiveField(dc, originalArchiveField, (Enums.BoxTypes)originalBoxTypeCode, originalDefaultValue);
try
{
Setting.User.ThisProgram.AddLog(Setting.User.UserOparatesPlaceNames.بایگانی, Setting.User.UserOparatesNames.ویرایش, null, "ویرایش فیلد '" + originalLabel + "' در گروه اطلاعاتی '" + originalTabTitle + "' در بایگانی '" + dc.GetArchive().Title + "'");
}
catch
{
throw new Exception("خطا در ذخیره عملکرد کاربر جاری");
}
dc.Transaction.Commit();
dc.Connection.Close();
}
catch
{
dc.Transaction.Rollback();
dc.Connection.Close();
throw;
}
finally
{
if (dc.Connection.State == System.Data.ConnectionState.Open)
{
dc.Connection.Close();
}
}
}
public static void Insert(Model.Archive.Info info, Model.Archive.ArchiveDataClassesDataContext dc)
{
try
{
if (info == null)
{
return;
}
dc.Infos.InsertOnSubmit(info);
dc.SubmitChanges();
}
catch (Exception ex)
{
throw new Exception("خطا در ثبت اطلاعات" + "\r\n\r\n" + ex.Message);
}
}
internal static void UnReturnLending(Model.Archive.ArchiveDataClassesDataContext dc, int lendingID)
{
var lending = dc.Lendings.Where(t => t.ID == lendingID).Single();
lending.ReturnDate = null;
lending.ReturnTime = null;
lending.RealDurationDay = null;
lending.RealDurationHour = null;
dc.SubmitChanges();
try
{
Setting.User.ThisProgram.AddLog(Setting.User.UserOparatesPlaceNames.بازگشت_امانت, Setting.User.UserOparatesNames.حذف, null, "لغو بازگشت امانت پرونده با " + Setting.Archive.ThisProgram.LoadedArchiveSettings.PersonnelNumber_Label + " " + lending.PersonnelNumber);
}
catch
{
throw new Exception("خطا در ذخیره عملکرد کاربر جاری");
}
}
public static void Insert(List <Model.Archive.Contact> contact)
{
Model.Archive.ArchiveDataClassesDataContext dc = Model.Archive.ArchiveDataClassesDataContext.GetNewInstance();
dc.Connection.Open();
dc.Transaction = dc.Connection.BeginTransaction();
try
{
dc.Contacts.InsertAllOnSubmit(contact);
dc.SubmitChanges();
dc.Transaction.Commit();
}
catch (Exception ex)
{
dc.Transaction.Rollback();
throw new Exception("خطا در ثبت اطلاعات" + "\r\n\r\n" + ex.Message);
}
finally
{
dc.Connection.Close();
}
}
public static void DeleteAll(string personnelNumber)
{
Model.Archive.ArchiveDataClassesDataContext dc = Model.Archive.ArchiveDataClassesDataContext.GetNewInstance();
dc.Connection.Open();
dc.Transaction = dc.Connection.BeginTransaction();
try
{
dc.Contacts.DeleteAllOnSubmit(dc.Contacts.Where(t => t.PersonnelNumber == personnelNumber));
dc.SubmitChanges();
dc.Transaction.Commit();
}
catch (Exception ex)
{
dc.Transaction.Rollback();
throw new Exception("خطا در ثبت اطلاعات" + "\r\n\r\n" + ex.Message);
}
finally
{
dc.Connection.Close();
}
}
public static void Update(Model.Archive.ArchiveDataClassesDataContext dc, Model.Archive.ArchiveTab archiveTab)
{
try
{
var originalArchiveTab = dc.ArchiveTabs.Where(t => t.ID == archiveTab.ID).Single();
int originalTypeCode = originalArchiveTab.TypeCode;
string originalTitle = originalArchiveTab.Title;
Model.Archive.ArchiveTab.Copy(originalArchiveTab, archiveTab);
dc.SubmitChanges();
if (originalTypeCode == (int)Enums.TabTypes.Dossier)
{
Setting.User.ThisProgram.AddLog(Setting.User.UserOparatesPlaceNames.گروه_اطلاعاتی_پرونده, Setting.User.UserOparatesNames.ویرایش, null, "تغییر نام گروه اطلاعاتی '" + originalTitle + "' به '" + archiveTab.Title + "'");
}
else
{
Setting.User.ThisProgram.AddLog(Setting.User.UserOparatesPlaceNames.گروه_اطلاعاتی_سند, Setting.User.UserOparatesNames.ویرایش, null, "تغییر نام گروه اطلاعاتی '" + originalTitle + "' به '" + archiveTab.Title + "'");
}
}
catch (Exception ex)
{
throw new Exception("خطا در بروزرسانی اطلاعات" + "\r\n\r\n" + ex.Message);
}
}
