public object creatReq(fieldInfo rn, List<tendencyInfo> rgr) { Results<string> result = new Results<string>(); try { HelperData h = new HelperData(); // db.Connection.Open(); // using (db.Transaction = db.Connection.BeginTransaction()) rn.deleted = false; int t = h.AddFieldInfo(rn); if (t != 0) { bool s = h.AddTendency(rgr, t); if (s) { // db.Transaction.Commit(); result.IsSuccessfull = true; } } else { result.Message = "خطا!نام رشته وارد شده قبلا در سیستم ثبت شده است"; } } catch (Exception error) { // db.Transaction.Rollback(); result.IsSuccessfull = false; result.Message = error.Message; } return result; }
public int AddFieldInfo(fieldInfo fi) { HelperSearch h = new HelperSearch(); try { if (h.checkUniqField(fi.fieldName)==1) { db.fieldInfos.InsertOnSubmit(fi); db.SubmitChanges(); return fi.fieldCode; } else { return 0; } } catch (Exception error) { return 0; } }
public int EditFieldInfo(fieldInfo rn) { try { var v = from i in db.fieldInfos where i.fieldCode == rn.fieldCode select i; fieldInfo newPost = v.FirstOrDefault(); if (newPost != null) { newPost.fieldCode = rn.fieldCode; newPost.fieldName = rn.fieldName; // newPost.dateInsert = rn.dateInsert; newPost.deleted = false; db.SubmitChanges(); return 1; } return 0;//not found } catch (Exception error) { return -1; } }
partial void DeletefieldInfo(fieldInfo instance);
partial void UpdatefieldInfo(fieldInfo instance);
partial void InsertfieldInfo(fieldInfo instance);
public object UpdateReqField(fieldInfo rn, List<tendencyInfo> rgr, int fieldCode) { Results<string> result = new Results<string>(); try { HelperData h = new HelperData(); int t = h.EditFieldInfo(rn); if (t == 1) { int a = h.EditTendency(fieldCode, rgr); if (a == 1) { result.IsSuccessfull = true; } } } catch (Exception error) { result.IsSuccessfull = false; result.Message = error.Message; } return result; }
public static string UpdateReqField(fieldInfo rn, List<tendencyInfo> rgr, int fieldCode) { manageBLL mb = new manageBLL(); return JsonConvert.SerializeObject(mb.UpdateReqField(rn, rgr, fieldCode)); }
public static string creatReq(fieldInfo rn,List<tendencyInfo> rgr) { manageBLL mb = new manageBLL(); return JsonConvert.SerializeObject(mb.creatReq(rn, rgr)); }