public IHttpActionResult commentAddition(dynamic data) { try { //string value = token_gen.Authorize_aesdecrpty(data); string value = JsonConvert.SerializeObject(data); commentAddition rootobj = JsonConvert.DeserializeObject <commentAddition>(value); return(Ok(Internalhel.commentAddition(rootobj))); } catch (Exception ex) { CatchData.Status = "Failure"; CatchData.Reason = ex.Message; return(Ok(CatchData)); } }
public dynamic commentAddition(commentAddition obj) { dynamic objupdate = new ExpandoObject(); try { if (commentAdditionHelper(obj)) { objupdate.Status = 200; objupdate.Reason = "Your Record Updated Successfully"; } else { objupdate.Status = 400; objupdate.Reason = "Data Not Submitted Please Try Again"; } } catch (Exception ex) { objupdate.Status = 500; objupdate.Reason = ex.Message; } return(objupdate); }
public bool commentAdditionHelper(commentAddition obj) { OracleTransaction transaction; OracleCommand cmd = new OracleCommand(); try { string error_log = "{ 'IP_ADDRESS' : '" + HttpContext.Current.Request.UserHostAddress + "','DELETTION_TIME' : '" + DateTime.Now.ToString() + "' , 'DATA' : '" + JsonConvert.SerializeObject(obj) + "' }"; string log_path = HttpContext.Current.Server.MapPath("comment addition"); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(log_path, error_log)); ConnectionHelper _conHe = new ConnectionHelper(); OracleConnection con = new OracleConnection(_conHe.Congsws); if (con.State == ConnectionState.Closed) { con.Open(); } // Start a local transaction transaction = con.BeginTransaction(IsolationLevel.ReadCommitted); try { cmd = con.CreateCommand(); // Assign transaction object for a pending local transaction cmd.Transaction = transaction; cmd.CommandText = @"update gsws_report_issues set comp_status=:issue_status where report_id=:report_id"; cmd.Parameters.Add(":issue_status", OracleDbType.Varchar2).Value = obj.issue_status; cmd.Parameters.Add(":report_id", OracleDbType.Varchar2).Value = obj.report_id; cmd.CommandType = CommandType.Text; int i = cmd.ExecuteNonQuery(); cmd = con.CreateCommand(); obj.comment_id = obj.report_id + DateTime.Now.ToString("yyyyMMddhhmmss"); obj.image_path = GetImagePath(obj.image, "IssuesComment", obj.report_id); cmd.CommandText = @"insert into gsws_report_issues_cmts(REPORT_ID,COMMENTS,COMMENT_ID,LOGIN_USER,MSG_FLAG,IMAGE_PATH)values(:REPORT_ID,:COMMENTS,:COMMENT_ID,:LOGIN_USER,:MSG_FLAG,:IMAGE_PATH)"; cmd.Parameters.Add(":REPORT_ID", OracleDbType.Varchar2).Value = obj.report_id; cmd.Parameters.Add(":COMMENTS", OracleDbType.Varchar2, 2000).Value = obj.comment; cmd.Parameters.Add(":COMMENT_ID", OracleDbType.Varchar2).Value = obj.comment_id; cmd.Parameters.Add(":LOGIN_USER", OracleDbType.Varchar2).Value = obj.username; cmd.Parameters.Add(":MSG_FLAG", OracleDbType.Varchar2).Value = obj.message_flag ? 0 : 1; cmd.Parameters.Add(":IMAGE_PATH", OracleDbType.Varchar2).Value = obj.image_path; cmd.CommandType = CommandType.Text; i += cmd.ExecuteNonQuery(); transaction.Commit(); cmd.Dispose(); if (con.State == ConnectionState.Open) { con.Close(); con.Dispose(); } if (i > 1) { return(true); } else { return(false); } } catch (Exception ex) { transaction.Rollback(); if (con != null) { if (con.State == ConnectionState.Open) { con.Close(); con.Dispose(); } } if (cmd != null) { cmd.Dispose(); } throw ex; } } catch (Exception ex) { throw ex; } }