public int Add_Request_Json_Detail(string message_id, string request_type, string json = "")
{
int Value = 0;
fadv_touchlessEntities entit = new fadv_touchlessEntities();
tbl_request_details tbl = new tbl_request_details();
List <tbl_request_details> lst = new List <tbl_request_details>();
try
{
tbl.messageid = message_id;
tbl.json_text = json;
tbl.request_type = request_type;
lst.Add(tbl);
entit.tbl_request_details.AddRange(lst);
entit.SaveChanges();
Value = 1;
}
catch (Exception ex)
{
Value = 0;
throw ex;
}
return(Value);
}
public int Insert_Json_in_requesStateInstanse(long RequestID, int sequence, string state, long userID, string comment, sbyte isCurrent, sbyte IsReview, sbyte PartitionKey)
{
int Value = 0;
fadv_touchlessEntities entit = new fadv_touchlessEntities();
tbl_request_state_instance tbl = new tbl_request_state_instance();
try
{
tbl.RequestID = RequestID;
tbl.Sequence = sequence;// 1;
tbl.StateID = state;// "REQ-0002";
tbl.UserID = userID;// 165;
tbl.Date_Created = DateTime.Now;
tbl.Comments = comment;// "Case Creation by Touchless";
tbl.Is_Current = isCurrent;// 1;
tbl.IS_Review = IsReview;
tbl.PartitionKey = PartitionKey;
entit.tbl_request_state_instance.Add(tbl);
entit.SaveChanges();
Value = 1;
}
catch (Exception ex)
{
Value = 0;
throw ex;
}
return Value;
}
//koushik code
public int Insert_Json_in_requestracker(string RequestID, string json = "")
{
int Value = 0;
fadv_touchlessEntities entit = new fadv_touchlessEntities();
tbl_request_tracker tbl = new tbl_request_tracker();
List <tbl_request_tracker> lst = new List <tbl_request_tracker>();
try
{
//tbl.RequestID = Convert.ToUInt32(RequestID);
tbl.Type = "";
tbl.Json_Data = json;
tbl.Operation_Date = DateTime.Now;
lst.Add(tbl);
entit.tbl_request_tracker.AddRange(lst);
entit.SaveChanges();
Value = 1;
}
catch (Exception ex)
{
Value = 0;
throw ex;
}
return(Value);
}
//koushik code
public int Insert_FilePathIndocument_upload(List<string> Files, long requestID)
{
int Value = 0;
fadv_touchlessEntities entit = new fadv_touchlessEntities();
tbl_document_upload tbl = new tbl_document_upload();
List<tbl_document_upload> lst = new List<tbl_document_upload>();
DML_Utility objDML = new DML_Utility();
try
{
foreach (var file in Files)
{
tbl = new tbl_document_upload();
tbl.Document_Path = file;
tbl.Date_Created = DateTime.Now;
tbl.Date_Modified = DateTime.Now;
tbl.PartitionKey = 0;
tbl.Requestid = requestID;
lst.Add(tbl);
}
entit.tbl_document_upload.AddRange(lst);
entit.SaveChanges();
Value = 1;
}
catch (Exception ex)
{
objDML.Add_Exception_Log(ex.Message, "Insert_FilePathIndocument_upload");
Value = 0;
throw ex;
}
return Value;
}
public int Insert_data_in_requests(string RequestID, List <tbl_yettostart_casecreation_data> list)
{
int Value = 0;
fadv_touchlessEntities entit = new fadv_touchlessEntities();
tbl_requests tbl = new tbl_requests();
List <tbl_requests> lst = new List <tbl_requests>();
sbyte Dateofbirth = 0;
int intRequestID = Convert.ToInt32(RequestID);
try
{
foreach (tbl_yettostart_casecreation_data item in list)
{
if (item.first_name != string.Empty)
{
Dateofbirth = 1;
}
tbl.RequestID = Convert.ToUInt32(intRequestID);
// tbl.ClientID = 0;
tbl.First_Name = item.first_name;
tbl.Last_Name = item.last_name;
tbl.Middle_Name = "";
tbl.Client_Ref_No = item.client_ref_no;
tbl.Case_Date = DateTime.Now;
tbl.Subject_Detail = "";
tbl.Subject_Type = "";
tbl.Is_Date_of_Birth = Dateofbirth;
tbl.Date_Of_Birth = Convert.ToDateTime(item.date_of_birth);
tbl.Type_Of_Check = ""; //Pre employment or Post employment or Both
tbl.Candidate_Authorization_Letter = ""; // Yes or No
tbl.Package_Type = ""; // Soft Copy or Hard copy
tbl.Srt_Data = "SRT";
tbl.Date_Created = DateTime.Now;
tbl.Date_Modified = DateTime.Now;
tbl.Is_Active = true;
// tbl.SBUID =0;
tbl.LOA_Submitted = "Yes";
tbl.BVF_Submitted = "Yes";
tbl.PartitionKey = 0;
tbl.JSON_Data = "";
lst.Add(tbl);
Value = 1;
intRequestID++;
}
entit.tbl_requests.AddRange(lst);
entit.SaveChanges();
}
catch (Exception ex)
{
Value = 0;
throw ex;
}
return(Value);
}
public int Add_Response_Json(long request_id, List <tbl_yettostart_casecreation_data> lst, string json = "")
{
int Value = 0;
try
{
if (lst.Count > 0)
{
using (fadv_touchlessEntities entit = new fadv_touchlessEntities())
{
entit.tbl_yettostart_casecreation_data.AddRange(lst);
entit.SaveChanges();
}
}
tbl_response_detail tbl = new tbl_response_detail();
List <tbl_response_detail> lstResponse = new List <tbl_response_detail>();
tbl.request_id = request_id; // Int64.Parse(request_id);
tbl.response_json = json;
tbl.status = 1;
lstResponse.Add(tbl);
using (fadv_touchlessEntities entit = new fadv_touchlessEntities())
{
entit.tbl_response_detail.AddRange(lstResponse);
entit.SaveChanges();
tbl_request_details processData = entit.tbl_request_details.Where(x => x.id == request_id).First();
processData.Status = 1;
entit.SaveChanges();
}
Value = 1;
}
catch (Exception ex)
{
Value = 0;
throw ex;
}
return(Value);
}
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);
}
public int updateYetTostart(long resId, long ExpresReqID)
{
int Value = 0;
try
{
fadv_touchlessEntities entit = new fadv_touchlessEntities();
tbl_yettostart_casecreation_data processData = entit.tbl_yettostart_casecreation_data.Where(x => x.queue_request_id == resId).First();
processData.ExpressRequestID = ExpresReqID;
entit.SaveChanges();
Value = 1;
}
catch (Exception ex)
{
Value = 0;
throw ex;
}
return Value;
}
public int Update_Response_Status(long resId)
{
int Value = 0;
try
{
using (fadv_touchlessEntities entities = new fadv_touchlessEntities())
{
tbl_response_detail processData = entities.tbl_response_detail.Where(x => x.id == resId).First();
processData.status = 2;
entities.SaveChanges();
}
Value = 1;
}
catch (Exception ex)
{
Value = 0;
throw ex;
}
return Value;
}
public List <tbl_input_request_data> Get_New_Request_Id_List(string ImportKey) //Get_FreshCase_YetToStart(string ImportKey)
{
List <tbl_initiation_tracker> lstObjMISData = new List <tbl_initiation_tracker>();
List <tbl_input_request_data> lstObj = new List <tbl_input_request_data>();
fadv_touchlessEntities entity = new fadv_touchlessEntities();
tbl_initiation_tracker tblMISData = new tbl_initiation_tracker();
lstObj = entity.tbl_input_request_data.SqlQuery("select * from tbl_input_request_data where ImportKey=" + ImportKey + " and Request_ID not in (select request_id from tbl_initiation_tracker)").ToList <tbl_input_request_data>();
foreach (var obj in lstObj)
{
long Id = long.Parse(obj.Id.ToString());
// Update Request Status
using (fadv_touchlessEntities entities = new fadv_touchlessEntities())
{
tbl_input_request_data processData = entities.tbl_input_request_data.Where(x => x.Id == Id).First();
processData.Active = 9;
entities.SaveChanges();
}
}
lstObj = entity.tbl_input_request_data.SqlQuery("select * from tbl_input_request_data where ImportKey=" + ImportKey + " and Active=9").ToList <tbl_input_request_data>();
foreach (var objInsert in lstObj)
{
tblMISData = new tbl_initiation_tracker();
//request_id, candidate_id, associate_id, bgv_type, name, account
tblMISData.request_id = objInsert.Request_ID;
tblMISData.candidate_id = objInsert.Candidate_ID;
tblMISData.associate_id = objInsert.Associate_Id;
tblMISData.bgv_type = objInsert.BGV_Type;
tblMISData.name = objInsert.Name;
tblMISData.account = objInsert.Account;
lstObjMISData.Add(tblMISData);
}
entity.tbl_initiation_tracker.AddRange(lstObjMISData);
entity.SaveChanges();
return(lstObj);
}
public int Add_Response_Json_FreshCase_Update(long request_id, long response_id, List<tbl_yettostart_casecreation_data> lst, string json = "")
{
int Value = 0;
try
{
if (lst.Count > 0)
{
using (fadv_touchlessEntities entit = new fadv_touchlessEntities())
{
entit.tbl_yettostart_casecreation_data.AddRange(lst);
entit.SaveChanges();
}
}
Value = 1;
}
catch (Exception ex)
{
Value = 0;
throw ex;
}
return Value;
}
public int Add_Response_Json(long request_id, string json = "", string message_id = "", string service_id = "")
{
int Value = 0;
fadv_touchlessEntities entit = new fadv_touchlessEntities();
tbl_response_detail tbl = new tbl_response_detail();
List <tbl_response_detail> lst = new List <tbl_response_detail>();
tbl_request_details tblReq = new tbl_request_details();
List <tbl_request_details> lstReq = new List <tbl_request_details>();
try
{
tbl.request_id = request_id; // Int64.Parse(request_id);
tbl.response_json = json;
tbl.message_id = message_id;
tbl.service_id = service_id;
tbl.status = 1;
lst.Add(tbl);
entit.tbl_response_detail.AddRange(lst);
entit.SaveChanges();
// Update Request Status
using (fadv_touchlessEntities entities = new fadv_touchlessEntities())
{
tbl_request_details processData = entities.tbl_request_details.Where(x => x.id == request_id).First();
processData.Status = 1;
entities.SaveChanges();
}
Value = 1;
}
catch (Exception ex)
{
Value = 0;
throw ex;
}
return(Value);
}
public int Add_Rows_Count_Data(string filepath, long rowcount)
{
int Value = 0;
fadv_touchlessEntities entit = new fadv_touchlessEntities();
tbl_mislog_count tbl = new tbl_mislog_count();
List <tbl_mislog_count> lst = new List <tbl_mislog_count>();
try
{
tbl.filePath = filepath;
tbl.rowscount = rowcount;
lst.Add(tbl);
entit.tbl_mislog_count.AddRange(lst);
entit.SaveChanges();
Value = 1;
}
catch (Exception ex)
{
Value = 0;
//throw ex;
}
return(Value);
}
public int Add_Exception_Log(string Exception, string FunctionName = "")
{
int Value = 0;
fadv_touchlessEntities entit = new fadv_touchlessEntities();
tbl_exception_log tbl = new tbl_exception_log();
List <tbl_exception_log> lst = new List <tbl_exception_log>();
try
{
tbl.exception_log = Exception;
tbl.function_name = FunctionName;
lst.Add(tbl);
entit.tbl_exception_log.AddRange(lst);
entit.SaveChanges();
Value = 1;
}
catch (Exception ex)
{
Value = 0;
throw ex;
}
return(Value);
}
public int Add_Response_Json(string message_id, string json = "")
{
int Value = 0;
fadv_touchlessEntities entit = new fadv_touchlessEntities();
tbl_response_detail tbl = new tbl_response_detail();
List <tbl_response_detail> lst = new List <tbl_response_detail>();
try
{
tbl.request_id = 1;
tbl.response_json = json;
lst.Add(tbl);
entit.tbl_response_detail.AddRange(lst);
entit.SaveChanges();
Value = 1;
}
catch (Exception ex)
{
Value = 0;
throw ex;
}
return(Value);
}
public int Insert_data_in_requests(ref string RequestID, List<tbl_yettostart_casecreation_data> list, string JsonDatRequests, string clientID, string SBUID)
{
int Value = 0;
fadv_touchlessEntities entit = new fadv_touchlessEntities();
Get_Data_Utility objGet = new Get_Data_Utility();
tbl_requests tbl = new tbl_requests();
//List<tbl_requests> lst = new List<tbl_requests>();
sbyte Dateofbirth = 0;
DML_Utility objDML = new DML_Utility();
List<tbl_requests> ListRequestID = objGet.Get_RequestID();
//objDML.Add_Exception_Log("Before", "");
decimal NewRequestID = ListRequestID[0].RequestID + 1;
RequestID = NewRequestID.ToString();
int intRequestID = Convert.ToInt32(RequestID);
try
{
//foreach (tbl_yettostart_casecreation_data item in list)
if (list.Count > 0)
{
tbl_yettostart_casecreation_data item = list[0];
if (item.first_name != string.Empty) Dateofbirth = 1;
tbl.RequestID = Convert.ToUInt32(intRequestID);
tbl.ClientID = Convert.ToInt32(clientID);
// tbl.ClientID = 0;
tbl.First_Name = item.first_name;
tbl.Last_Name = item.last_name;
tbl.Middle_Name = "";
tbl.Client_Ref_No = item.client_ref_no;
tbl.Case_Date = DateTime.Now;
tbl.Subject_Detail = "FADV";
tbl.Subject_Type = "Candidate";
tbl.Is_Date_of_Birth = Dateofbirth;
tbl.Date_Of_Birth = Convert.ToDateTime(item.date_of_birth);
tbl.Type_Of_Check = "Both";//Pre employment or Post employment or Both
tbl.Candidate_Authorization_Letter = "Yes";// Yes or No
tbl.Package_Type = "Soft Copy"; // Soft Copy or Hard copy
tbl.Srt_Data = "SRT";
tbl.Date_Created = DateTime.Now;
tbl.Date_Modified = DateTime.Now;
tbl.Is_Active = true;
// tbl.SBUID =0;
tbl.LOA_Submitted = "Yes";
tbl.BVF_Submitted = "Yes";
tbl.PartitionKey = 0;
tbl.JSON_Data = JsonDatRequests;
tbl.SBUID = Convert.ToInt64(SBUID);
//lst.Add(tbl);
Value = 1;
//intRequestID++;
entit.tbl_requests.Add(tbl);
entit.SaveChanges();
}
}
catch (Exception ex)
{
objDML.Add_Exception_Log(ex.Message, "Insert_data_in_requests");
objDML.Add_Exception_Log(ex.InnerException.Message, "Insert_data_in_requests");
Value = 0;
throw ex;
}
return Value;
}