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