public dynamic SaveReOpenTicket_Helper(FeedBackReport obj) { dynamic objupdate = new ExpandoObject(); try { string Status = SaveReOpenTicket_Helper_SP(obj); if (Status == "Success") { objupdate.Status = "100"; objupdate.Reason = "Token Re-open Successfully."; } else { objupdate.Status = "102"; objupdate.Reason = "Data Not Submitted Please Try Again"; } } catch (Exception ex) { objupdate.Status = "102"; objupdate.Reason = ex.Message; } return(objupdate); }
public dynamic PostFeedbackdata(FeedBackReport obj) { dynamic objupdate = new ExpandoObject(); try { obj.REPORTID = obj.SECRETRIATID + DateTime.Now.ToString("ddMMyyHHmmssfff"); string Status = SaveFeedbackReport(obj); if (Status == "Success") { objupdate.Status = "100"; objupdate.Reason = "Your Record Updated Successfully!Your Token ID is" + " " + obj.REPORTID; } else { objupdate.Status = "102"; objupdate.Reason = "Data Not Submitted Please Try Again"; } } catch (Exception ex) { objupdate.Status = "102"; objupdate.Reason = ex.Message; } return(objupdate); }
public String SaveReOpenTicket_Helper_SP(FeedBackReport obj) { try { //obj.REPORTID = obj.SECRETRIATID + DateTime.Now.ToString("ddMMyyHHmmssfff"); cmd = new OracleCommand(); cmd.CommandText = @"update GSWS_REPORT_ISSUES set REOPEN_DATE=sysdate, REOPEN_BY = :USER_NAME,REOPEN_REASONS=:REMARKS,comp_status=:comp_status where REPORT_ID= :REPORT_ID"; cmd.Parameters.Add(":USER_NAME", OracleDbType.Varchar2, 50).Value = obj.USER; cmd.Parameters.Add(":REMARKS", OracleDbType.Varchar2, 500).Value = obj.REMARKS; cmd.Parameters.Add(":comp_status", OracleDbType.Varchar2, 50).Value = obj.SOURCE; cmd.Parameters.Add(":REPORT_ID", OracleDbType.Varchar2, 50).Value = obj.REPORTID; int k = getProdgswsExecuteNonQuery(cmd); if (k > 0) { return("Success"); } else { return("Failure"); } } catch (Exception ex) { string mappath = HttpContext.Current.Server.MapPath("SaveReOpenTicketExceptionLogs"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, "Error GSWS_REPORT_ISSUES :" + ex.Message.ToString())); throw ex; } }
public IHttpActionResult SaveReOpenTicket(dynamic data) { string value = token_gen.Authorize_aesdecrpty(data); try { //string value = JsonConvert.SerializeObject(data); string mappath = HttpContext.Current.Server.MapPath("SaveReOpenTicketLogs"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log(mappath, value)); FeedBackReport rootobj = JsonConvert.DeserializeObject <FeedBackReport>(value); return(Ok(Internalhel.SaveReOpenTicket_Helper(rootobj))); } catch (Exception ex) { CatchData.Status = "Failure"; CatchData.Reason = "Error Occured While Save Data."; return(Ok(CatchData)); } }
public String SaveFeedbackReport(FeedBackReport obj) { try { //obj.REPORTID = obj.SECRETRIATID + DateTime.Now.ToString("ddMMyyHHmmssfff"); cmd = new OracleCommand(); cmd.CommandText = @"INSERT INTO GSWS_REPORT_ISSUES(SD_ID,HOD_ID,URL_ID,USER_NAME,REMARKS,IMAGE1_URL,IMAGE2_URL,IMAGE3_URL,DISTRICT_CODE,MANDAL_CODE,SEC_CODE,REPORT_ID,SUBJECT,SUBSUBJECT,SOURCE) values(:SD_ID,:HOD_ID,:URL_ID,:USER_NAME,:REMARKS,:IMAGE1_URL,:IMAGE2_URL,:IMAGE3_URL,:DISTRICT_CODE,:MANDAL_CODE,:SEC_CODE,:REPORT_ID,:SUBJECT,:SUBSUBJECT,:SOURCE)"; cmd.Parameters.Add(":SD_ID", OracleDbType.Varchar2, 50).Value = obj.DEPTID; cmd.Parameters.Add(":HOD_ID", OracleDbType.Varchar2, 50).Value = obj.HODID; cmd.Parameters.Add(":URL_ID", OracleDbType.Varchar2, 500).Value = obj.URL_ID; cmd.Parameters.Add(":USER_NAME", OracleDbType.Varchar2, 50).Value = obj.USER; cmd.Parameters.Add(":REMARKS", OracleDbType.Varchar2, 500).Value = obj.REMARKS; cmd.Parameters.Add(":IMAGE1_URL", OracleDbType.Varchar2, 500).Value = obj.IMAGE1URL; cmd.Parameters.Add(":IMAGE2_URL", OracleDbType.Varchar2, 500).Value = obj.IMAGE2URL; cmd.Parameters.Add(":IMAGE3_URL", OracleDbType.Varchar2, 500).Value = obj.IMAGE3URL; cmd.Parameters.Add(":DISTRICT_CODE", OracleDbType.Varchar2, 50).Value = obj.DISTRICTID; cmd.Parameters.Add(":MANDAL_CODE", OracleDbType.Varchar2, 50).Value = obj.MANDALID; cmd.Parameters.Add(":SEC_CODE", OracleDbType.Varchar2, 50).Value = obj.SECRETRIATID; cmd.Parameters.Add(":REPORT_ID", OracleDbType.Varchar2, 50).Value = obj.REPORTID; cmd.Parameters.Add(":SUBJECT", OracleDbType.Varchar2, 50).Value = obj.SUBJECT; cmd.Parameters.Add(":SUBSUBJECT", OracleDbType.Varchar2, 50).Value = obj.SUBSUBJECT; cmd.Parameters.Add(":SOURCE", OracleDbType.Varchar2, 50).Value = obj.SOURCE; int k = getgswsExecuteNonQuery(cmd); if (k > 0) { return("Success"); } else { return("Failure"); } } catch (Exception ex) { string mappath = HttpContext.Current.Server.MapPath("ExceptionLogs"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, "Error UpdateUserManualURL :" + ex.Message.ToString())); throw ex; } }