public List <Models.MOC_Model.New_MOC_Model> Get_MocRecordfilter(Models.MOC_Model.New_MOC_Model obj) { string queryString = "Sp_getMocRecord"; try { List <Models.MOC_Model.New_MOC_Model> returnModel = new List <Models.MOC_Model.New_MOC_Model>(); OracleConnection connection = new OracleConnection(); connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings[""].ConnectionString; OracleCommand commed4 = new OracleCommand(queryString, connection); OracleDataAdapter adpter4 = new OracleDataAdapter(commed4); commed4.CommandType = CommandType.StoredProcedure; commed4.Parameters.Add("p_cursor", OracleType.Cursor).Direction = ParameterDirection.Output; commed4.Parameters.Add(new OracleParameter("p_flag", OracleType.Int32, 10)).Value = 4; commed4.Parameters.Add(new OracleParameter("p_fromdate", OracleType.VarChar, 20)).Value = obj.Periodicity_date_from; commed4.Parameters.Add(new OracleParameter("p_todate", OracleType.VarChar, 20)).Value = obj.Periodicity_date_To; DataSet ds = new DataSet(); adpter4.Fill(ds); if (ds != null && ds.Tables != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { returnModel.Add(new Models.MOC_Model.New_MOC_Model() { MOC_Number = Convert.ToString(dr["MOC_Number"]), Station = Convert.ToString(dr["Station"]), Department = Convert.ToString(dr["Department"]), Type_of_Change = Convert.ToString(dr["Type_of_Change"]), Description = Convert.ToString(dr["Description"]), Periodicity_date_from = Convert.ToString(dr["Periodicity_date_from"]), Periodicity_date_To = Convert.ToString(dr["Periodicity_date_To"]), Status = Convert.ToString(dr["Status"]), Remark = Convert.ToString(dr["Remark"]), } ); } return(returnModel); } } } catch (Exception ex) { throw ex; //return null; } return(null); }
public int SAVE_NEWMOC(Models.MOC_Model.New_MOC_Model obj, string fileName) { OracleConnection connection = new OracleConnection(); connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings[""].ConnectionString; try { var querystr1 = "SP_MOC_INS"; using (OracleCommand command1 = new OracleCommand(querystr1, connection)) { command1.Connection.Open(); command1.CommandType = CommandType.StoredProcedure; command1.Parameters.Add(new OracleParameter("p_Description", OracleType.VarChar, 200)).Value = obj.Description; command1.Parameters.Add(new OracleParameter("p_Station", OracleType.VarChar, 200)).Value = obj.Station; command1.Parameters.Add(new OracleParameter("p_Type_of_Change", OracleType.VarChar, 100)).Value = obj.Type_of_Change; command1.Parameters.Add(new OracleParameter("p_Department", OracleType.VarChar, 1000)).Value = obj.Department; command1.Parameters.Add(new OracleParameter("p_Identified_Tagno", OracleType.VarChar, 50)).Value = obj.Identified_Tagno; command1.Parameters.Add(new OracleParameter("p_Circuit", OracleType.VarChar, 50)).Value = obj.Circuit; command1.Parameters.Add(new OracleParameter("p_Reasons_Change", OracleType.VarChar, 1000)).Value = obj.Reasons_Change; command1.Parameters.Add(new OracleParameter("p_Impact_Change", OracleType.VarChar, 200)).Value = obj.Impact_Change; command1.Parameters.Add(new OracleParameter("p_Change_Proposed", OracleType.VarChar, 200)).Value = obj.Change_Proposed; command1.Parameters.Add(new OracleParameter("p_Hazards_Identified", OracleType.VarChar, 100)).Value = obj.Hazards_Identified; command1.Parameters.Add(new OracleParameter("p_Arrang_mitigation", OracleType.VarChar, 1000)).Value = obj.Arrang_mitigation; command1.Parameters.Add(new OracleParameter("p_Revised_Drawings", OracleType.VarChar, 400)).Value = fileName; command1.Parameters.Add(new OracleParameter("p_Periodicity_date_from", OracleType.VarChar, 50)).Value = obj.Periodicity_date_from; command1.Parameters.Add(new OracleParameter("p_Periodicity_time_from", OracleType.VarChar, 1000)).Value = obj.Periodicity_time_from; command1.Parameters.Add(new OracleParameter("p_Periodicity_date_To", OracleType.VarChar, 50)).Value = obj.Periodicity_date_To; command1.Parameters.Add(new OracleParameter("p_Periodicity_time_To", OracleType.VarChar, 1000)).Value = obj.Periodicity_time_To; command1.Parameters.Add(new OracleParameter("p_CreateBy", OracleType.VarChar, 50)).Value = obj.CreateBy; command1.Parameters.Add(new OracleParameter("P_Remark", OracleType.VarChar, 200)).Value = obj.Remark; command1.Parameters.Add(new OracleParameter("P_flag", OracleType.Int32, 200)).Value = 1; command1.ExecuteNonQuery(); command1.Connection.Close(); } return(1); } catch (Exception e) { return(-1); } finally { //conn.Close(); //cmd.Connection = null; //cmd.Parameters.Clear(); //cmd.Dispose(); //trans.Dispose(); } }