public string PoEntrySubDelete(PoEntrySub objPoEntrySub) { string strMsg; OracleCommand objOracleCommand = new OracleCommand("pro_delete_po_sub"); objOracleCommand.CommandType = CommandType.StoredProcedure; objOracleCommand.Parameters.Add("p_tran_id", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntrySub.TranId) ? objPoEntrySub.TranId : null; objOracleCommand.Parameters.Add("p_style_no", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntrySub.StyleNo) ? objPoEntrySub.StyleNo : null; objOracleCommand.Parameters.Add("p_season_year", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntrySub.SeasoneYear) ? objPoEntrySub.SeasoneYear : null; objOracleCommand.Parameters.Add("p_season_id", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntrySub.SeasoneId) ? objPoEntrySub.SeasoneId : null; objOracleCommand.Parameters.Add("p_head_office_id", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntrySub.HeadOfficeId) ? objPoEntrySub.HeadOfficeId : null; objOracleCommand.Parameters.Add("p_branch_office_id", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntrySub.BranchOfficeId) ? objPoEntrySub.BranchOfficeId : null; objOracleCommand.Parameters.Add("P_MESSAGE", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; using (OracleConnection strConn = GetConnection()) { try { objOracleCommand.Connection = strConn; strConn.Open(); trans = strConn.BeginTransaction(); objOracleCommand.ExecuteNonQuery(); trans.Commit(); strConn.Close(); strMsg = objOracleCommand.Parameters["P_MESSAGE"].Value.ToString(); } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { strConn.Close(); } } return(strMsg); }
public List <PoEntrySub> GetPoSubData(string seasonId, string seasonYear, string styleNumber, string headOfficeId, string branchOfficeId) { List <PoEntrySub> objPoEntrySubModel = new List <PoEntrySub>(); var sql = "SELECT " + "PO_NO," + "STYLE_NO," + "SEASON_ID," + "SEASON_YEAR," + "COLOR_ID," + "FABRIC_TYPE_ID," + "FABRIC_CODE," + "COLOR_WAY_NO_ID, " + "COLOR_WAY_NAME, " + "SIZE_ID," + "SIZE_VALUE," + "CREATE_BY," + "CREATE_DATE," + "UPDATE_BY," + "UPDATE_DATE," + "HEAD_OFFICE_ID," + "BRANCH_OFFICE_ID," + "TRAN_ID " + " FROM VEW_PO_SUB where SEASON_ID = '" + seasonId.Trim() + "' AND SEASON_YEAR = '" + seasonYear.Trim() + "' AND STYLE_NO = '" + styleNumber.Trim() + "' AND HEAD_OFFICE_ID = '" + headOfficeId + "' AND BRANCH_OFFICE_ID = '" + branchOfficeId + "' "; OracleCommand objCommand = new OracleCommand(sql); OracleDataReader objDataReader; using (OracleConnection strConn = GetConnection()) { objCommand.Connection = strConn; strConn.Open(); objDataReader = objCommand.ExecuteReader(); try { while (objDataReader.Read()) { PoEntrySub model = new PoEntrySub(); model.PoNumber = objDataReader.GetValue(0).ToString(); model.StyleNo = objDataReader.GetValue(1).ToString(); model.SeasoneId = objDataReader.GetValue(2).ToString(); model.SeasoneYear = objDataReader.GetValue(3).ToString(); model.ColorWayNumber = objDataReader.GetValue(7).ToString(); model.ColorWayName = objDataReader.GetValue(8).ToString(); model.SizeId = objDataReader.GetValue(9).ToString(); model.SizeValue = objDataReader.GetValue(10).ToString(); model.TranId = objDataReader.GetValue(17).ToString(); objPoEntrySubModel.Add(model); } } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { strConn.Close(); } } return(objPoEntrySubModel); }