//Hardware Issues Compnent Loading public dynamic Loadhwcomponent(Assetmodel oj) { dynamic obj = new ExpandoObject(); try { DataTable dt = Loadhwcomponent_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 = GetException(ex.Message); return(obj); } return(obj); }
//Save Hardware Issues public dynamic SaveHardwareIssue(Assetmodel root) { dynamic obj = new ExpandoObject(); try { DataTable dt = SaveHardwareIssueSpHelper(root); if (dt != null && dt.Rows.Count > 0 && (dt.Rows[0]["REASON"] ?? "").ToString().Contains("Asset Hardware Issue Registered Successfully with UID")) { obj.Status = "Success"; obj.Reason = "Data Inserted Successfully.Your Token ID is " + " " + (dt.Rows[0]["REASON"] ?? "").ToString().Replace("Asset Hardware Issue Registered Successfully with UID:", ""); } else { obj.Status = "Failure"; obj.Reason = dt.Rows[0]["REASON"].ToString(); } } catch (Exception ex) { obj.Status = "Failure"; obj.Reason = GetException(ex.Message); } return(obj); }
public IHttpActionResult SaveHardwareIssue(dynamic data) { try { string value = token_gen.Authorize_aesdecrpty(data); string mappath = HttpContext.Current.Server.MapPath("HardwareIssueSubmitLogs"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log(mappath, value)); Assetmodel rootobj = JsonConvert.DeserializeObject <Assetmodel>(value); //var validresult.Status = "Success";//_valid.CheckSaveAssetTracking(rootobj); //if (validresult.Status == "Success") //{ return(Ok(heahel.SaveHardwareIssue(rootobj))); //} //else //{ // CatchData.Status = "Failure"; // CatchData.Reason = validresult.Reason; // return Ok(CatchData); //} } catch (Exception ex) { CatchData.Status = "Failure"; CatchData.Reason = ServicesHelper.ThirdpartyMessage; return(Ok(CatchData)); } }
//Hardware Issue Compnent Loading public DataTable Loadhwcomponent_helper(Assetmodel oj) { try { cmd = new OracleCommand(); cmd.InitialLONGFetchSize = 1000; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GSWS_HARDWARE_ISSUES"; cmd.Parameters.Add("P_TYPE", OracleDbType.Varchar2, 12).Value = oj.TYPE; cmd.Parameters.Add("P_COMPONENT_ID", OracleDbType.Varchar2, 12).Value = oj.COMPONENTID; cmd.Parameters.Add("P_CUR", OracleDbType.RefCursor).Direction = ParameterDirection.Output; DataTable dtstatus = GetgswsDataAdapter(cmd); if (dtstatus != null && dtstatus.Rows.Count > 0) { return(dtstatus); } else { return(null); } } catch (Exception ex) { string mappath = HttpContext.Current.Server.MapPath("DataLoadingExceptionLogs"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, "Error From LoadDistricts:" + ex.Message.ToString())); throw ex; } }
//Reports public DataTable LoadRptDistrictSPData(Assetmodel oj) { try { cmd = new OracleCommand(); cmd.InitialLONGFetchSize = 1000; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GSWS_ASSETS_CNT_REPORT"; cmd.Parameters.Add("ftype", OracleDbType.Varchar2, 12).Value = oj.TYPE; cmd.Parameters.Add("fdist_id", OracleDbType.Varchar2, 12).Value = oj.DISTRICT; cmd.Parameters.Add("fmandal_id", OracleDbType.Varchar2, 12).Value = oj.MANDAL; cmd.Parameters.Add("fsec_id", OracleDbType.Varchar2, 12).Value = oj.SECRATARIAT; cmd.Parameters.Add("p_cur", OracleDbType.RefCursor).Direction = ParameterDirection.Output; DataTable dtstatus = GetgswsDataAdapter(cmd); if (dtstatus != null && dtstatus.Rows.Count > 0) { return(dtstatus); } else { return(null); } } catch (Exception ex) { string mappath = HttpContext.Current.Server.MapPath("SeccDataLoadingExceptionLogs"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, "Error From LoadDistricts:" + ex.Message.ToString())); throw ex; } }
public IHttpActionResult Loadhwcomponent(dynamic data) { try { string value = token_gen.Authorize_aesdecrpty(data); //string value = JsonConvert.SerializeObject(data); Assetmodel rootobj = JsonConvert.DeserializeObject <Assetmodel>(value); return(Ok(heahel.Loadhwcomponent(rootobj))); } catch (Exception ex) { CatchData.Status = "Failure"; CatchData.Reason = ServicesHelper.ThirdpartyMessage; return(Ok(CatchData)); } }
//Save Hardware Issue public dynamic SaveHardwareIssueSpHelper(Assetmodel oj) { try { //int k = 0; cmd = new OracleCommand(); cmd.InitialLONGFetchSize = 1000; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GSWS_IN_HARDWARE_ISSUES"; cmd.Parameters.Add("P_TYPE", OracleDbType.Varchar2, 12).Value = "1"; cmd.Parameters.Add("P_DISTRICT", OracleDbType.Varchar2, 12).Value = oj.DISTRICT; cmd.Parameters.Add("P_MANDAL", OracleDbType.Varchar2, 12).Value = oj.MANDAL; cmd.Parameters.Add("P_SECRETARIAT", OracleDbType.Varchar2, 12).Value = oj.SECRATARIAT; cmd.Parameters.Add("P_COMPONENT_NAME", OracleDbType.Varchar2, 200).Value = oj.HWCOMPONENT; cmd.Parameters.Add("P_ISSUE_NAME", OracleDbType.Varchar2, 200).Value = oj.HWISSUE; cmd.Parameters.Add("P_REMARKS", OracleDbType.Varchar2, 200).Value = oj.REMARKS; cmd.Parameters.Add("P_IMAGE_URL", OracleDbType.Varchar2, 500).Value = oj.IMAGEURL; cmd.Parameters.Add("P_IP_ADDRESS", OracleDbType.Varchar2, 150).Value = GetIPAddress(); cmd.Parameters.Add("P_ENTRY_BY", OracleDbType.Varchar2, 120).Value = oj.USERNAME; cmd.Parameters.Add("P_SOURCE", OracleDbType.Varchar2, 12).Value = oj.SOURCE; cmd.Parameters.Add("p_cur", OracleDbType.RefCursor).Direction = ParameterDirection.Output; DataTable dtstatus = GetgswsDataAdapter(cmd); if (dtstatus != null && dtstatus.Rows.Count > 0) { return(dtstatus); } else { return(null); } } catch (Exception ex) { string mappath = HttpContext.Current.Server.MapPath("HardwareIssuesExceptionLogs"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, "Error From Submit Data:" + ex.Message.ToString())); throw ex; } }