// Save Services Url's Data public dynamic SaveServices_helper(InternalURL root) { dynamic obj = new ExpandoObject(); try { Int32 UniuqeCode = GetUniqueCode(root); UniuqeCode = UniuqeCode + 1; root.URL_ID = root.SERVICE + (UniuqeCode < 9 ? ("0" + UniuqeCode.ToString()) : UniuqeCode.ToString()); DataTable data = SaveServices_data_helper(root); if (data != null) { obj.Status = "Success"; obj.Reason = "Data Inserted Successfully."; obj.Details = data; } else { obj.Status = "Failure"; obj.Reason = "No Data Found"; } } catch (Exception ex) { obj.Status = "Failure"; obj.Reason = ex.Message; } return(obj); }
public dynamic LoadDepartments(InternalURL oj) { dynamic obj = new ExpandoObject(); try { DataTable dt = LoadDepartments_helper(oj); if (dt != null && dt.Rows.Count > 0) { obj.Status = "Success"; obj.Reason = ""; obj.Details = dt; } else { obj.Status = "Failure"; obj.Reason = "No Data Found"; } } catch (Exception ex) { obj.Status = "Failure"; obj.Reason = ex.Message; return(obj); } return(obj); }
public IHttpActionResult SaveServicesURLData(dynamic data) { try { string value = JsonConvert.SerializeObject(data); InternalURL rootobj = JsonConvert.DeserializeObject <InternalURL>(value); var validresult = _valid.CheckServicesURL(rootobj); if (validresult.Status == "Success") { return(Ok(Internalhel.SaveServices_helper(rootobj))); } else { CatchData.Status = "Failure"; CatchData.Reason = validresult.Reason; return(Ok(CatchData)); } } catch (Exception ex) { CatchData.Status = "Failure"; CatchData.Reason = ex.Message; return(Ok(CatchData)); } }
// Get UniqueCode public Int32 GetUniqueCode(InternalURL obj) { Int32 Cnt = 0; try { var comd = new OracleCommand(); comd.InitialLONGFetchSize = 1000; comd.CommandType = CommandType.Text; comd.CommandText = "SELECT COUNT(*) AS COUNT FROM GSWS_URL_MASTER WHERE SD_ID=:SD_ID AND HOD_ID=:HOD_ID AND SCHEME_ID=:SCHEME_ID"; comd.Parameters.Add(":SD_ID", OracleDbType.Varchar2).Value = obj.DEPARTMENT; comd.Parameters.Add(":HOD_ID", OracleDbType.Varchar2).Value = obj.HOD; comd.Parameters.Add(":SCHEME_ID", OracleDbType.Varchar2).Value = obj.SERVICE; DataTable data = GetgswsDataAdapter(comd); if (data != null && data.Rows.Count > 0) { Cnt = Convert.ToInt32(data.Rows[0]["COUNT"]); } } catch (WebException wex) { string mappath = HttpContext.Current.Server.MapPath("ExceptionLogs"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, "Error Get Unique code based on url :" + wex.Message.ToString())); } return(Cnt); }
public DataTable LoadGeographicalData_helper(InternalURL oj) { try { cmd = new OracleCommand(); cmd.InitialLONGFetchSize = 1000; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GSWS_GET_SERVICE_DETAILS"; cmd.Parameters.Add("FTYPE", OracleDbType.Varchar2, 12).Value = oj.TYPE; cmd.Parameters.Add("FPS_CODE", OracleDbType.Varchar2, 12).Value = oj.DEPARTMENT; cmd.Parameters.Add("FGSWS_ID", OracleDbType.Varchar2, 12).Value = ""; cmd.Parameters.Add("FDIST_CODE", OracleDbType.Varchar2, 12).Value = oj.DISTRICT; cmd.Parameters.Add("FMAND_CODE", OracleDbType.Varchar2, 12).Value = oj.MANDAL; cmd.Parameters.Add("FVILL_CODE", OracleDbType.Varchar2, 12).Value = oj.PANCHAYAT; cmd.Parameters.Add("P_CUR", OracleDbType.RefCursor).Direction = ParameterDirection.Output; DataTable dtstatus = comhel.GetgswsDataAdapter(cmd); if (dtstatus != null && dtstatus.Rows.Count > 0) { return(dtstatus); } else { return(null); } } catch (Exception ex) { string mappath = HttpContext.Current.Server.MapPath("InternalURLExceptionLogs"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, "Error From LoadDepartments:" + ex.Message.ToString())); throw ex; } }
// save Services Url's public DataTable SaveServices_data_helper(InternalURL obj) { try { var comd = new OracleCommand(); comd.InitialLONGFetchSize = 1000; comd.CommandType = CommandType.StoredProcedure; comd.CommandText = "GSWS_IN_URL_MASTER"; comd.Parameters.Add("P_TYPE", OracleDbType.Varchar2).Value = obj.TYPE; comd.Parameters.Add("P_SD_ID", OracleDbType.Varchar2).Value = obj.DEPARTMENT; comd.Parameters.Add("P_HOD_ID", OracleDbType.Varchar2).Value = obj.HOD; comd.Parameters.Add("P_SCHEME_ID", OracleDbType.Varchar2).Value = obj.SERVICE; comd.Parameters.Add("P_TYPE_OF_REQUEST", OracleDbType.Varchar2).Value = obj.REQUESTTYPE; comd.Parameters.Add("P_URL_ID", OracleDbType.Varchar2).Value = obj.URL_ID; comd.Parameters.Add("P_URL", OracleDbType.Varchar2).Value = obj.URL; comd.Parameters.Add("P_URL_DESCRIPTION", OracleDbType.Varchar2).Value = obj.URLDESCRIPTION; comd.Parameters.Add("P_ACCESS_LEVEL", OracleDbType.Varchar2).Value = obj.ACCESSLEVEL; comd.Parameters.Add("P_DISTRICT_ID", OracleDbType.Varchar2).Value = obj.DISTRICT; comd.Parameters.Add("P_MANDAL_ID", OracleDbType.Varchar2).Value = obj.MANDAL; comd.Parameters.Add("P_GP_WARD_ID", OracleDbType.Varchar2).Value = obj.PANCHAYAT; comd.Parameters.Add("P_USER_NAME", OracleDbType.Varchar2).Value = obj.USERNAME; comd.Parameters.Add("P_PASSWORD", OracleDbType.Varchar2).Value = obj.PASSWORD; comd.Parameters.Add("P_ENCRYPT_PASSWORD", OracleDbType.Varchar2).Value = string.IsNullOrEmpty(obj.ENCRYPT_PASSWORD) ? null : CryptLib.getHashSha256(obj.ENCRYPT_PASSWORD, 31);; comd.Parameters.Add("P_TYPE_OF_SERVICE", OracleDbType.Varchar2).Value = obj.SERVICETYPE; comd.Parameters.Add("P_UR_FLAG", OracleDbType.Varchar2).Value = obj.RUFLAG; // comd.Parameters.Add("P_URL_DESC_TEL", OracleDbType.Varchar2).Value = obj.P_URL_DESC_TEL; comd.Parameters.Add("DESIGN_R", OracleDbType.Varchar2).Value = obj.RURALDESIGNATION; comd.Parameters.Add("DESIGN_U", OracleDbType.Varchar2).Value = obj.URBANDESIGNATION; comd.Parameters.Add("P_CUR", OracleDbType.RefCursor).Direction = ParameterDirection.Output; DataTable data = GetgswsDataAdapter(comd); if (data != null && data.Rows.Count > 0) { return(data); } else { return(null); } } catch (WebException wex) { string mappath = HttpContext.Current.Server.MapPath("ExceptionLogs"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, "Error Save Services URL data :" + wex.Message.ToString())); throw new Exception(wex.Message); } }
public IHttpActionResult LoadDepartments(dynamic data) { try { //string value = token_gen.Authorize_aesdecrpty(data); string value = JsonConvert.SerializeObject(data); InternalURL rootobj = JsonConvert.DeserializeObject <InternalURL>(value); return(Ok(Internalhel.LoadDepartments(rootobj))); } catch (Exception ex) { CatchData.Status = "Failure"; CatchData.Reason = ex.Message; return(Ok(CatchData)); } }