public int Check_Rule_Engine_CVT_UT(long request_id, long response_id, List <Yet2Start_College> lst) { int Value = 0; try { Get_Data_Utility objGet = new Get_Data_Utility(); foreach (var obj in lst) { int cvt = 0; int ut = 0; string college = obj.college.Trim(); string degree = obj.degree.Trim(); sbyte active = 1; List <tbl_college_details> lstResponse = new List <tbl_college_details>(); lstResponse = objGet.Get_College_Details(request_id, response_id, college, degree); foreach (var cd in lstResponse) { long cdid = cd.id; string fieldsource = cd.field_source.Trim(); if (cd.field_source.ToLower() == "cvt") { cvt = 1; } else if (cd.field_source.ToLower() == "ut") { ut = 1; } if (cvt > 0 & ut > 0) { using (fadv_touchlessEntities entit = new fadv_touchlessEntities()) { List <tbl_college_details> processData = entit.tbl_college_details.Where(x => x.field_source == "UT" && x.reqid == request_id && x.resid == response_id && x.college == college && x.degree == degree).ToList <tbl_college_details>(); foreach (var uddt in processData) { tbl_college_details updatedata = entit.tbl_college_details.Where(x => x.id == uddt.id).First(); updatedata.active = 9; entit.SaveChanges(); } } } } } Value = 1; } catch (Exception ex) { Value = 0; throw ex; } return(Value); }
public int Add_Response_Json(long request_id, long response_id, List <Yet2Start_College> lst) { int Value = 0; try { if (lst.Count > 0) { tbl_college_details tbl = new tbl_college_details(); List <tbl_college_details> lstResponse = new List <tbl_college_details>(); foreach (var obj in lst) { string college = obj.college.Trim(); string degree = obj.degree.Trim(); sbyte active = 1; tbl = new tbl_college_details(); tbl.college = college.Trim(); tbl.degree = degree.Trim(); tbl.field_source = obj.field_source.Trim(); tbl.reqid = request_id; tbl.resid = response_id; tbl.active = active; lstResponse.Add(tbl); } using (fadv_touchlessEntities entit = new fadv_touchlessEntities()) { entit.tbl_college_details.AddRange(lstResponse); entit.SaveChanges(); } // Check for Check_Rule_Engine_CVT_UT // Check_Rule_Engine_CVT_UT_New(request_id, response_id, lst); //Check_Rule_Engine_CVT_UT(request_id, response_id, lst); } Value = 1; } catch (Exception ex) { Value = 0; throw ex; } return(Value); }