/// <summary>
/// formon található autocomplete controlok query-je
/// </summary>
/// <param name="ID_form">form id-ja</param>
/// <param name="search">kereső érték</param>
/// <returns>List<AutocompleteItem></returns>
public List<AutocompleteItem> GetAutocompleteItemsById(int ID_formField, string search)
{
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
var query = (from ac in srvcont.DataContext.sp_frmAutocomplete(ID_formField, search)
select new AutocompleteItem
{
ValueMember = ac.ValueMember,
DisplayMember = ac.DisplayMember
}).ToList();
return query;
}
/// <summary>
/// mentéskor tbl_frmFormTransaction táblában kezdő értékek invalidálása
/// </summary>
/// <param name="ID_Created_By">user id</param>
/// <param name="myForm">CustomForm példány</param>
private void InvalidateFormTransactionRows(int ID_Created_By, ref CustomForm myForm)
{
if (myForm.Status == FormStatus.AccesDenied)
{
return;
}
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
string guid = myForm.FormHeader.EditGuid;
var stat_cancel_id = srvcont.DataContext.tbl_frmTransactionStatus.FirstOrDefault(f => f.TransactionStatus == Constants.TRANSACTION_STATUS.CANCELED).ID;
try
{
myForm.Status = FormStatus.ProcedureInProgress;
foreach (var item in myForm.Data)
{
var trRow = srvcont.DataContext.tbl_frmFormTransaction.FirstOrDefault(f => f.ID_frmFormTransactionHeader == guid && f.ID_frmFormField == item.fieldid && f.OBSOLATE == false && f.CREATED_BY == ID_Created_By);
if (trRow != null)
{
trRow.OBSOLATE = true;
trRow.ID_frmTransactionStatus = stat_cancel_id;
}
}
srvcont.DataContext.SaveChanges();
myForm.Status = FormStatus.ProcedureReady;
}
catch (Exception ex)
{
HelperClasses.ExceptionHandler.LogException(ex, srvcont, "InvalidateFormTransactionRow");
myForm.Status = FormStatus.ProcedureFailed;
myForm.FormHeader.IsReadOnly = true;
myForm.StatusMessage = "Invalidating FormTransactionRow failed!";
}
}
/// <summary>
/// mentéskor tbl_frmFormTransaction táblába új értékek beszúrása
/// </summary>
/// <param name="ID_Created_By">user id</param>
/// <param name="myForm">CustomForm példány</param>
private void InsertFormTransactionRows(int ID_Created_By, ref CustomForm myForm)
{
if (myForm.Status == FormStatus.AccesDenied)
{
return;
}
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
string guid = myForm.FormHeader.EditGuid;
int table_fieldid = myForm.FormHeader.ID_TableField;
var stat_open_id = srvcont.DataContext.tbl_frmTransactionStatus.FirstOrDefault(f => f.TransactionStatus == Constants.TRANSACTION_STATUS.OPEN).ID;
var expire = srvcont.DataContext.tbl_frmFormTransactionHeader.FirstOrDefault(f => f.ID == guid && f.ID_genTableField == table_fieldid && f.CREATED_BY == ID_Created_By).VALID_TO;
try
{
myForm.Status = FormStatus.ProcedureInProgress;
foreach (var item in myForm.Data)
{
Entities.tbl_frmFormTransaction nRow = new Entities.tbl_frmFormTransaction();
nRow.ID_frmFormTransactionHeader = myForm.FormHeader.EditGuid;
nRow.ID_frmTransactionStatus = stat_open_id;
nRow.ID_frmFormField = (int)item.fieldid;
nRow.Value = item.id;
nRow.TS_CREATE = DateTime.Now;
nRow.CREATED_BY = ID_Created_By;
nRow.VALID_FROM = DateTime.Now;
nRow.VALID_TO = expire;
srvcont.DataContext.tbl_frmFormTransaction.AddObject(nRow);
}
srvcont.DataContext.SaveChanges();
myForm.Status = FormStatus.ProcedureReady;
}
catch (Exception ex)
{
HelperClasses.ExceptionHandler.LogException(ex, srvcont, "InsertFormTransactionRow");
myForm.Status = FormStatus.ProcedureFailed;
myForm.FormHeader.IsReadOnly = true;
myForm.StatusMessage = "Inserting FormTransactionRow failed!";
}
}
/// <summary>
/// form sor definíciójának lekérdezése
/// </summary>
/// <param name="ID_Form">form ID-ja</param>
/// <returns>List<FormField></returns>
private List<FormField> GetFormRowDefinitionByFormId(int ID_Form)
{
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
var row_definition = (from row in srvcont.DataContext.tbl_frmFormField.Where(w1 =>
w1.OBSOLATE == false && w1.ID_frmForm == ID_Form).OrderBy(o => o.Position)
select new FormField
{
Row = row.Row ?? 1,
FieldId = row.ID_genTableField,
FieldName = row.tbl_genTableField.FieldReport,
Description = row.Label
}).ToList();
return row_definition;
}
/// <summary>
/// form fej adatainak lekérdezése, CustomForm példány létrehozása
/// </summary>
/// <param name="ID_Form">form ID-ja</param>
/// <returns>CustomForm</returns>
private CustomFormHeader GetFormHeaderByFormId(int ID_Form)
{
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
var MyFormHeader = (from row in srvcont.DataContext.tbl_frmForm.Where(w1 => w1.OBSOLATE == false
&& w1.ID == ID_Form)
select new CustomFormHeader
{
FormID = row.ID,
FormName = row.Form,
ID_TableField = (int)row.ID_genTableField,
IsReadOnly = true, //megnyitáskor minden form readonly
GetURL = row.RoutineURL_Get,
GetRoutine = row.Routine_Get,
SetURL = row.RoutineURL_Set,
SetRoutine = row.Routine_Set
}).FirstOrDefault();
return MyFormHeader;
}
/// <summary>
/// Form választó felépítéséhez frmFormGroup és frmForm táblák lekérdezése
/// </summary>
/// <param name="ID_hrStaff">kérést indító user ID</param>
/// <returns>List<FormGroup></returns>
public List<FormGroup> GetFormList(int ID_hrStaff)
{
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
List<FormGroup> myForms = new List<FormGroup>();
var formgroups = srvcont.DataContext.tbl_frmFormGroup.Where(w => w.OBSOLATE == false);
Validator validator = new Validator();
foreach (var formgroup in formgroups)
{
if (validator.HasRoleForViewFormGroup(ID_hrStaff, formgroup.FormGroup))
{
FormGroup fg = new FormGroup();
fg.text = formgroup.FormGroup;
fg.children = (from r in srvcont.DataContext.tbl_frmForm.Where(w => w.ID_frmFormGroup == formgroup.ID).OrderBy(o => o.Form)
select new Form
{
id = r.ID,
text = r.Form
}).ToList();
myForms.Add(fg);
}
}
return myForms;
}
/// <summary>
/// adott mező értéke megfelel-e required és Regex alapján történő validálásnak
/// </summary>
/// <param name="ID_TableField"></param>
/// <param name="value"></param>
/// <returns></returns>
private bool ValueIsValid(int ID_FormField, string value)
{
bool isValid = false;
bool reqOK = false;
bool regOK = false;
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
var field = srvcont.DataContext.tbl_frmFormField.FirstOrDefault(f => f.ID == ID_FormField);
if (field != null)
{
bool isRequired = (bool)field.Required;
string Regex = field.tbl_genTableField.ID_genRegex == null ? "" : field.tbl_genTableField.tbl_genRegex.Regex;
if (isRequired)
{
if (!string.IsNullOrEmpty(value))
{
reqOK = true;
}
else
{
reqOK = false;
}
}
else
{
reqOK = true;
}
if (!string.IsNullOrEmpty(Regex))
{
Regex regexp = new Regex(Regex);
regOK = regexp.IsMatch(value);
}
else
{
regOK = true;
}
}
//ha field nem létezik a táblában, akkor nem lehet valid
else
{
regOK = false;
reqOK = false;
}
if (regOK == true && reqOK == true)
{
isValid = true;
}
else
{
isValid = false;
}
return isValid;
}
/// <summary>
/// 1) edit guid létrehozása, kiválasztott rekord tárolása tbl_frmFormTransactionHeader táblában
/// </summary>
/// <param name="ID_Created_By">user id, aki a szerkesztést indítja</param>
/// <param name="myForm">CustomForm egy példánya</param>
/// <param name="blAddnew">új rekord felvétele/módosítás</param>
/// <returns>CustomForm</returns>
private CustomForm OpenEditGuid(int ID_Created_By, ref CustomForm myForm, bool blAddnew)
{
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
var header_item = new Entities.tbl_frmFormTransactionHeader();
if (myForm.Status == FormStatus.AccesDenied)
{
return myForm;
}
try
{
header_item.ID = Guid.NewGuid().ToString();
header_item.ID_frmForm = myForm.FormHeader.FormID;
header_item.NewItem = blAddnew;
header_item.ID_genTableField = myForm.FormHeader.ID_TableField;
header_item.KeyValue = myForm.FormHeader.KeyValue;
header_item.ID_frmTransactionStatus = srvcont.DataContext.tbl_frmTransactionStatus.FirstOrDefault(f => f.TransactionStatus == Constants.TRANSACTION_STATUS.OPEN).ID;
header_item.OBSOLATE = false;
header_item.CREATED_BY = ID_Created_By;
header_item.TS_CREATE = DateTime.Now;
header_item.VALID_FROM = DateTime.Now;
header_item.VALID_TO = myForm.FormHeader.EditGuidExpire;
srvcont.DataContext.tbl_frmFormTransactionHeader.AddObject(header_item);
srvcont.DataContext.SaveChanges();
myForm.FormHeader.EditGuid = header_item.ID;
myForm.Status = FormStatus.ProcedureInProgress;
}
catch (Exception ex)
{
HelperClasses.ExceptionHandler.LogException(ex, srvcont, "OpenEditGuid");
myForm.Status = FormStatus.ProcedureFailed;
myForm.StatusMessage = "Form header openening failed!";
myForm.FormHeader.IsReadOnly = true;
myForm.FormHeader.EditGuid = "";
}
return myForm;
}
/// <summary>
/// Cancel státusz állítása tbl_frmFormTransaction táblában
/// </summary>
/// <param name="ID_Created_By">user id</param>
/// <param name="myForm">CustomForm példány</param>
private void CancelFormTransactionRowsByUser(int ID_Created_By)
{
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
var stat_cancel_id = srvcont.DataContext.tbl_frmTransactionStatus.FirstOrDefault(f => f.TransactionStatus == Constants.TRANSACTION_STATUS.CANCELED).ID;
var stat_open_id = srvcont.DataContext.tbl_frmTransactionStatus.FirstOrDefault(f => f.TransactionStatus == Constants.TRANSACTION_STATUS.OPEN).ID;
try
{
var trRows = from row in srvcont.DataContext.tbl_frmFormTransaction.Where(w => w.CREATED_BY == ID_Created_By && w.ID_frmTransactionStatus == stat_open_id)
select row;
if (trRows != null && trRows.Count() > 0)
{
foreach (var trRow in trRows)
{
trRow.MODIFIED_BY = ID_Created_By;
trRow.OBSOLATE = true;
trRow.ID_frmTransactionStatus = stat_cancel_id;
}
srvcont.DataContext.SaveChanges();
}
}
catch (Exception ex)
{
HelperClasses.ExceptionHandler.LogException(ex, srvcont, "CancelFormTransactionRows");
}
}
/// <summary>
/// Cancel státusz állítása tbl_frmFormTransaction táblában
/// </summary>
/// <param name="ID_Created_By">user id</param>
/// <param name="myForm">CustomForm példány</param>
private void CancelFormTransactionRows(int ID_Created_By, ref CustomForm myForm)
{
if (myForm.Status == FormStatus.AccesDenied)
{
return;
}
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
string guid = myForm.FormHeader.EditGuid;
int table_fieldid = myForm.FormHeader.ID_TableField;
var stat_cancel_id = srvcont.DataContext.tbl_frmTransactionStatus.FirstOrDefault(f => f.TransactionStatus == Constants.TRANSACTION_STATUS.CANCELED).ID;
try
{
var trRows = from row in srvcont.DataContext.tbl_frmFormTransaction.Where(w => w.ID_frmFormTransactionHeader == guid && w.CREATED_BY == ID_Created_By)
select row;
foreach (var trRow in trRows)
{
trRow.MODIFIED_BY = ID_Created_By;
trRow.OBSOLATE = true;
trRow.ID_frmTransactionStatus = stat_cancel_id;
}
srvcont.DataContext.SaveChanges();
myForm.Status = FormStatus.ProcedureReady;
}
catch (Exception ex)
{
HelperClasses.ExceptionHandler.LogException(ex, srvcont, "CancelFormTransactionRows");
myForm.Status = FormStatus.ProcedureFailed;
myForm.FormHeader.IsReadOnly = true;
myForm.StatusMessage = "Cancelling FormTransactionRows failed!";
}
}
/// <summary>
/// form mentése
/// 0) ID_TrHeader, ID_Tablefield alapján annak ellenőrzése, hogy az adott editguid létezik-e
/// 1) ID_TrHeader, ID_FormField alapján tbl_frmFormTransaction tábla sorainak érvénytelenítése
/// 2) ID_TrHeader guid, ID_FormField, frm_keyValue alapján új sorok felvétele tbl_frmFormTransaction táblába
/// 3) értékekek validálása
/// 4) update sp futtatása
/// 5) mentés ellenőrzése
/// </summary>
/// <param name="ID_Created_By">user id</param>
/// <param name="json_arr">formheader</param>
/// <returns>CustomForm</returns>
public CustomForm SetFormData_Save(int ID_Created_By, string json_arr_header, string json_arr_data)
{
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
HelperClasses.Serializer srl = new HelperClasses.Serializer();
CustomForm myForm = new CustomForm();
myForm.FormHeader = srl.NTSoftJsonDeserialize<CustomFormHeader>(json_arr_header);
myForm.Data = srl.NTSoftJsonDeserialize<List<FormData>>(json_arr_data);
if (string.IsNullOrEmpty(myForm.FormHeader.EditGuid) || myForm.FormHeader.ID_TableField == 0 || ID_Created_By == 0)
{
myForm.Status = FormStatus.InvalidParameters;
myForm.StatusMessage = "Error in Formheader!";
myForm.FormHeader.IsReadOnly = true;
return myForm;
}
//0)
if (!EditGuidExist(myForm.FormHeader.EditGuid, myForm.FormHeader.ID_TableField, ID_Created_By))
{
myForm.Status = FormStatus.AccesDenied;
myForm.StatusMessage = "Your edit session is expired or does not exist!";
myForm.FormHeader.IsReadOnly = true;
return myForm;
}
//1)
InvalidateFormTransactionRows(ID_Created_By, ref myForm);
if (myForm.Status == FormStatus.ProcedureReady)
{
//2)
InsertFormTransactionRows(ID_Created_By, ref myForm);
}
//3 validálás
foreach (var item in myForm.Data)
{
if (!ValueIsValid((int)item.fieldid, item.id))
{
myForm.Status = FormStatus.InvalidParameters;
myForm.StatusMessage = "Form validation failed!";
return myForm;
}
}
if (myForm.Status == FormStatus.ProcedureReady)
{
var stat_save_id = srvcont.DataContext.tbl_frmTransactionStatus.FirstOrDefault(f => f.TransactionStatus == Constants.TRANSACTION_STATUS.SAVED).ID;
//4)
srvcont.DataContext.sp_frmSetData(myForm.FormHeader.EditGuid, stat_save_id);
//5)
if (IsDataSaved(myForm.FormHeader.EditGuid, myForm.FormHeader.ID_TableField, ID_Created_By))
{
myForm.Status = FormStatus.ProcedureReady;
}
else
{
myForm.Status = FormStatus.ProcedureFailed;
myForm.StatusMessage = "Error in form save routine!";
myForm.FormHeader.IsReadOnly = true;
return myForm;
}
}
//save sp meghívása
return myForm;
}
/// <summary>
/// rekord Cancel státusz állítása tbl_frmFormTransactionHeader, tbl_frmFormTransaction táblákban
/// </summary>
/// <param name="ID_Created_By"></param>
/// <param name="json_arr"></param>
/// <returns>CustomForm</returns>
public CustomForm SetFormData_Cancel(int ID_Created_By, string json_arr)
{
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
HelperClasses.Serializer srl = new HelperClasses.Serializer();
CustomForm myForm = new CustomForm();
myForm.FormHeader = srl.NTSoftJsonDeserialize<CustomFormHeader>(json_arr);
if (string.IsNullOrEmpty(myForm.FormHeader.EditGuid) || myForm.FormHeader.ID_TableField == 0 || ID_Created_By == 0)
{
myForm.Status = FormStatus.InvalidParameters;
myForm.StatusMessage = "Error in Formheader!";
myForm.FormHeader.IsReadOnly = true;
return myForm;
}
CancelFormTransactionHeader(ID_Created_By, ref myForm);
if (myForm.Status == FormStatus.ProcedureInProgress)
{
//2)
CancelFormTransactionRows(ID_Created_By, ref myForm);
}
return myForm;
}
/// <summary>
/// rekord Cancel státusz állítása tbl_frmFormTransactionHeader, tbl_frmFormTransaction táblákban
/// </summary>
/// <param name="ID_Created_By"></param>
public void SetFormData_Cancel(int ID_Created_By)
{
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
HelperClasses.Serializer srl = new HelperClasses.Serializer();
CancelFormTransactionHeaderByUser(ID_Created_By);
CancelFormTransactionRowsByUser(ID_Created_By);
}
/// <summary>
/// form szerkesztésének megkezdésekor:
/// 0) ID_TableField, KeyValue alapján annak ellenőrzése, hogy az adott rekord szerkeszthető-e
/// 1) edit guid létrehozása, kiválasztott rekord tárolása tbl_frmFormTransactionHeader táblában -> EditGuidOpen()
/// 2) formon szereplő kezdő értékek letárolása tbl_frmFormTransaction táblába
/// </summary>
/// <param name="ID_Form">annak a formnak az id-ja, amin a szerkesztés történik</param>
/// <param name="ID_Created_By">user id, aki a szerkesztést indítja</param>
/// <param name="frm_keyValue">formhoz tartozó tábla kulcs mezőjének értéke (szerkesztett rekord azonosítója)</param>
/// <returns>CustomForm</returns>
public CustomForm SetFormData_BeginEdit(int ID_Form, int ID_Created_By, string frm_keyValue, bool blAddNew)
{
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
CustomForm myForm = new CustomForm();
if (ID_Form == 0 || ID_Created_By == 0 || string.IsNullOrEmpty(frm_keyValue))
{
myForm.Status = FormStatus.InvalidParameters;
myForm.StatusMessage = "Form or item is not selected!";
return myForm;
}
//ha új elem felvétele, akkor keyValue + guid
myForm.FormHeader.KeyValue = blAddNew ? frm_keyValue + Guid.NewGuid().ToString() : frm_keyValue;
//ha új elem felvétele, akkor long expire
myForm.FormHeader.EditGuidExpire = blAddNew ? DateTime.Now.AddMinutes(ExpireMinutesLong) : DateTime.Now.AddMinutes(ExpireMinutes);
myForm.FormHeader.FormID = ID_Form;
myForm.FormHeader.ID_TableField = (int)srvcont.DataContext.tbl_frmForm.FirstOrDefault(f => f.ID == ID_Form).ID_genTableField;
//0)
int? lockedByUser = KeyValueLockedByUser(myForm.FormHeader.ID_TableField, myForm.FormHeader.KeyValue);
if(lockedByUser != null)
{
string winName = srvcont.DataContext.tbl_hrStaff.FirstOrDefault(f => f.ID == lockedByUser).Windows_user_name;
myForm.Status = FormStatus.AccesDenied;
myForm.StatusMessage = "Selected item is currently being modified by user: "******" ! Please try later!";
myForm.FormHeader.IsReadOnly = true;
return myForm;
}
//1)
OpenEditGuid(ID_Created_By, ref myForm, blAddNew);
if (myForm.Status == FormStatus.ProcedureInProgress)
{
//2)
OpenFormTransactionRows(ID_Created_By, ref myForm, blAddNew);
}
return myForm;
}
/// <summary>
/// ID_TrHeader, ID_TableField, ID_Created_By alapján ellenőrzés tbl_frmFormTransactionHeader táblában, hogy mentés után a státusz Saved-e
/// </summary>
/// <param name="ID_TrHeader"></param>
/// <param name="ID_TableField"></param>
/// <param name="ID_Created_By"></param>
/// <returns>bool</returns>
private bool IsDataSaved(string ID_TrHeader, int ID_TableField, int ID_Created_By)
{
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
bool isupdated = false;
bool headerOK = false;
bool rowsOK = false;
rowsOK = srvcont.DataContext.tbl_frmFormTransaction.Where(a =>
a.ID_frmFormTransactionHeader == ID_TrHeader &&
a.tbl_frmTransactionStatus.TransactionStatus != Constants.TRANSACTION_STATUS.CANCELED &&
a.CREATED_BY == ID_Created_By
&& a.OBSOLATE == false).All(b => b.tbl_frmTransactionStatus.TransactionStatus == Constants.TRANSACTION_STATUS.SAVED);
headerOK = srvcont.DataContext.tbl_frmFormTransactionHeader.Any(a => a.ID == ID_TrHeader && a.ID_genTableField == ID_TableField && a.tbl_frmTransactionStatus.TransactionStatus == Constants.TRANSACTION_STATUS.SAVED && a.CREATED_BY == ID_Created_By);
if (rowsOK == true && headerOK == true)
{
isupdated = true;
}
return isupdated;
}
/// <summary>
/// ID_TableField, frm_keyValue alapján ellenőrzés tbl_frmFormTransactionHeader táblában, hogy az adott rekord nem lockolt-e
/// másik user által
/// </summary>
/// <param name="ID_TableField">formhoz tartozó tábla kulcs mezőjének id-ja</param>
/// <param name="frm_keyValue">formhoz tartozó tábla kulcs mezőjének értéke (szerkesztett rekord azonosítója)</param>
/// <returns>int?</returns>
private int? KeyValueLockedByUser(int ID_TableField, string frm_keyValue)
{
/* Státusz | Lejárt | szerkeszthető más által
* Open nem nem
* Open igen igen
* Canceled igen/nem igen
* Saved igen/nem igen
*/
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
var lockedByUser = srvcont.DataContext.tbl_frmFormTransactionHeader.FirstOrDefault(a => a.ID_genTableField == ID_TableField && a.KeyValue == frm_keyValue && a.VALID_TO > DateTime.Now && a.tbl_frmTransactionStatus.TransactionStatus == Constants.TRANSACTION_STATUS.OPEN && a.OBSOLATE == false);
int? lockedByUserId = null;
if (lockedByUser != null)
{
lockedByUserId = srvcont.DataContext.tbl_hrStaff.FirstOrDefault(f => f.ID == lockedByUser.CREATED_BY).ID;
}
return lockedByUserId;
}
/// <summary>
/// ID_Trheader, ID_TableField, ID_Created_By alapján ellenőrzés tbl_frmFormTransactionHeader táblában, hogy a session él-e még
/// </summary>
/// <param name="ID_TrHeader">trHeader id</param>
/// <param name="ID_TableField">kulcsmező id-ja</param>
/// <param name="ID_Created_By">user id</param>
/// <returns>bool</returns>
private bool EditGuidExist(string ID_TrHeader, int ID_TableField, int ID_Created_By)
{
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
bool exist = false;
exist = srvcont.DataContext.tbl_frmFormTransactionHeader.Any(a => a.ID == ID_TrHeader && a.ID_genTableField == ID_TableField && a.VALID_TO > DateTime.Now && a.tbl_frmTransactionStatus.TransactionStatus == Constants.TRANSACTION_STATUS.OPEN && a.OBSOLATE == false && a.CREATED_BY == ID_Created_By);
return exist;
}
/// <summary>
/// szerkesztés megkezdésekor kezdő értékek letárolása tbl_frmFormTransaction táblában
/// </summary>
/// <param name="ID_Created_By">user id</param>
/// <param name="myForm">CustomForm példány</param>
/// <param name="blAddnew">új rekord felvétele/módosítás</param>
/// <returns>CustomForm</returns>
private CustomForm OpenFormTransactionRows(int ID_Created_By, ref CustomForm myForm, bool blAddnew)
{
if (myForm.Status == FormStatus.AccesDenied)
{
return myForm;
}
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
try
{
var form_data = GetFormDataByFormIdKeyValue(myForm.FormHeader.FormID, myForm.FormHeader.KeyValue, blAddnew);
if (form_data == null || form_data.Count == 0)
{
myForm.Status = FormStatus.InvalidParameters;
myForm.StatusMessage = "Selected item does not exist in the current table!";
return myForm;
}
myForm.Data = form_data;
var stat_open_id = srvcont.DataContext.tbl_frmTransactionStatus.FirstOrDefault(f => f.TransactionStatus == Constants.TRANSACTION_STATUS.OPEN).ID;
foreach (var row in form_data)
{
var transaction_item = new Entities.tbl_frmFormTransaction();
transaction_item.ID_frmFormTransactionHeader = myForm.FormHeader.EditGuid;
transaction_item.ID_frmFormField = (int)row.fieldid;
transaction_item.ID_frmTransactionStatus = stat_open_id;
transaction_item.Value = row.id;
transaction_item.TS_CREATE = DateTime.Now;
transaction_item.CREATED_BY = ID_Created_By;
transaction_item.VALID_FROM = DateTime.Now;
transaction_item.VALID_TO = myForm.FormHeader.EditGuidExpire;
srvcont.DataContext.tbl_frmFormTransaction.AddObject(transaction_item);
}
srvcont.DataContext.SaveChanges();
myForm.Status = FormStatus.ProcedureReady;
myForm.FormHeader.IsReadOnly = false;
}
catch (Exception ex)
{
HelperClasses.ExceptionHandler.LogException(ex, srvcont, "OpenFormTransactionRows");
myForm.Status = FormStatus.ProcedureFailed;
myForm.FormHeader.IsReadOnly = true;
myForm.StatusMessage = "Form rows openening failed!";
}
return myForm;
}
/// <summary>
/// form fieldek opcióinak lekérdezés
/// </summary>
/// <param name="ID_Form">form id-ja</param>
/// <returns>List<FieldOptions></returns>
private List<FieldOptions> GetFormFieldOptionsByFormId(int ID_Form)
{
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
var field_options = (from row in srvcont.DataContext.tbl_frmFormField.Where(w1 =>
w1.OBSOLATE == false && w1.ID_frmForm == ID_Form).OrderBy(o => o.Position)
select new FieldOptions
{
FieldType = row.Type,
Required = row.Required,
RefreshForm = row.refresh_form,
ReadOnly = row.readOnly,
AllowClear = row.allowClear,
Multiple = row.multiple,
RoutineUrl = row.RoutineURL,
Routine = row.Routine,
RoutineParameter = row.RoutineParameter,
ValueMember = "ValueMember",
DisplayMember = "DisplayMember",
Width = row.width,
MinimumResultForSearch = row.minimumResultForSearch,
MiniumInputLength = row.minimumInputLength,
PlaceHolder = row.placeholder,
Regex = row.tbl_genTableField.tbl_genRegex.Regex,
FieldInfo = row.FieldInfo,
LabelTop = row.LabelTop,
RowcssClass = row.row_cssClass,
FieldcssClass = row.field_cssClass
}).ToList();
return field_options;
}
/// <summary>
/// form-hoz tartozó mezők adatainak lekérdezése
/// </summary>
/// <param name="ID_Form">form id-ja</param>
/// <param name="KeyValue">form-hoz tartozó kulcsmező értéke</param>
/// <param name="blAddNew">flag adott formon új elem hozzáadása</param>
/// <returns>List<FormData></returns>
public List<FormData> GetFormDataByFormIdKeyValue(int ID_Form, string KeyValue, bool blAddNew)
{
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
var query = (from data in srvcont.DataContext.sp_frmGetData(ID_Form, KeyValue, blAddNew)
select new FormData
{
fieldid = data.ID_frmFormField,
id = data.ID,
text = data.Text
}).ToList();
return query;
}
/// <summary>
/// Form id alapján form group lekérdezése
/// </summary>
/// <param name="ID_hrStaff">kérést indító user ID</param>
/// <returns>List<FormGroup></returns>
public string GetFormGroupByFormId(int ID_Form)
{
ServiceConfig srvcont = new ServiceConfig(_serviceconfigparameters);
string formgroup = srvcont.DataContext.tbl_frmForm.FirstOrDefault(w => w.OBSOLATE == false && w.ID == ID_Form).ID_frmFormGroup == null ? "" :
srvcont.DataContext.tbl_frmForm.FirstOrDefault(w => w.OBSOLATE == false && w.ID == ID_Form).tbl_frmFormGroup.FormGroup;
return formgroup;
}
