//Auto search pdf upload date public DataTable GetSelectionPdfAutoSearch(SelectionEntryModel objSelectionEntryModel) { DataTable dt = new DataTable(); string sql = ""; sql = "SELECT " + "TO_CHAR(UPLOAD_DATE, 'dd/mm/yyyy')UPLOAD_DATE " + "FROM VEW_SELECTION_FILE_UPLOAD WHERE HEAD_OFFICE_ID = '" + objSelectionEntryModel.HeadOfficeId + "' AND BRANCH_OFFICE_ID = '" + objSelectionEntryModel.BranchOfficeId + "' "; sql = sql + " ORDER BY UPLOAD_DATE DESC"; OracleCommand objCommand = new OracleCommand(sql); OracleDataAdapter objDataAdapter = new OracleDataAdapter(objCommand); using (OracleConnection strConn = GetConnection()) { try { objCommand.Connection = strConn; strConn.Open(); objDataAdapter.Fill(dt); dt.AcceptChanges(); } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { strConn.Close(); } } return(dt); }
//get country name to load insert table public string GetCountryNameById(SelectionEntryModel objSelectionEntryModel) { string vCountryName = ""; string sql = ""; sql = "SELECT " + " COUNTRY_NAME " + "FROM L_COUNTRY where head_office_id = '" + objSelectionEntryModel.HeadOfficeId.Trim() + "' and branch_office_id = '" + objSelectionEntryModel.BranchOfficeId.Trim() + "' and COUNTRY_ID = '" + objSelectionEntryModel.CountryId.Trim() + "' "; using (OracleConnection objConnection = GetConnection()) { OracleCommand objCommand = new OracleCommand(sql, objConnection); objConnection.Open(); OracleDataReader objReader = objCommand.ExecuteReader(); try { while (objReader.Read()) { vCountryName = objReader.GetString(0); } } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { objReader.Close(); objConnection.Close(); } } return(vCountryName); }
//Delete pdf file public string DeleteSelectionUploadFile(SelectionEntryModel objSelectionEntryModel) { string strMsg = ""; OracleTransaction objOracleTransaction = null; OracleCommand objOracleCommand = new OracleCommand("PRO_SELECTION_FILE_UPLOAD"); objOracleCommand.CommandType = CommandType.StoredProcedure; if (!string.IsNullOrEmpty(objSelectionEntryModel.GridTranId)) { objOracleCommand.Parameters.Add("P_TRAN_ID", OracleDbType.Varchar2, ParameterDirection.Input).Value = objSelectionEntryModel.GridTranId; } else { objOracleCommand.Parameters.Add("P_TRAN_ID", OracleDbType.Varchar2, ParameterDirection.Input).Value = null; } if (!string.IsNullOrEmpty(objSelectionEntryModel.UploadDate)) { objOracleCommand.Parameters.Add("UPLOAD_DATE", OracleDbType.Varchar2, ParameterDirection.Input).Value = objSelectionEntryModel.UploadDate; } else { objOracleCommand.Parameters.Add("UPLOAD_DATE", OracleDbType.Varchar2, ParameterDirection.Input).Value = null; } objOracleCommand.Parameters.Add("p_update_by", OracleDbType.Varchar2, 100, ParameterDirection.Input).Value = objSelectionEntryModel.UpdateBy; objOracleCommand.Parameters.Add("p_head_office_id", OracleDbType.Varchar2, 100, ParameterDirection.Input).Value = objSelectionEntryModel.HeadOfficeId; objOracleCommand.Parameters.Add("p_branch_office_id", OracleDbType.Varchar2, 100, ParameterDirection.Input).Value = objSelectionEntryModel.BranchOfficeId; 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); objOracleTransaction.Rollback(); } finally { strConn.Close(); } } return(strMsg); }
//Auto search selection entry public DataTable GetSelectionAutoSearch(SelectionEntryModel objSelectionEntryModel) { DataTable dt = new DataTable(); string sql = ""; sql = "SELECT " + "ROWNUM SL, " + "TO_CHAR(NVL(STYLE_NO, 'N/A'))STYLE_NO, " + "TO_CHAR(NVL(MODEL_NO, 'N/A'))MODEL_NO, " + "TO_CHAR(NVL(TOTAL_RECEIVED, '0'))TOTAL_RECEIVED, " + "TO_CHAR(NVL(COUNTRY_ID, '0'))COUNTRY_ID, " + "TO_CHAR(NVL(COUNTRY_NAME, 'N/A'))COUNTRY_NAME " + "FROM VEW_SELECTION_ENTRY_MAIN WHERE HEAD_OFFICE_ID = '" + objSelectionEntryModel.HeadOfficeId + "' AND BRANCH_OFFICE_ID = '" + objSelectionEntryModel.BranchOfficeId + "' "; if (!string.IsNullOrEmpty(objSelectionEntryModel.StyleNo)) { sql = sql + "and STYLE_NO = '" + objSelectionEntryModel.StyleNo + "'"; } if (!string.IsNullOrEmpty(objSelectionEntryModel.ModelNo)) { sql = sql + "and MODEL_NO = '" + objSelectionEntryModel.ModelNo + "'"; } if (!string.IsNullOrEmpty(objSelectionEntryModel.CountryName)) { sql = sql + "and COUNTRY_NAME = '" + objSelectionEntryModel.CountryName + "'"; } sql = sql + " ORDER BY SL"; OracleCommand objCommand = new OracleCommand(sql); OracleDataAdapter objDataAdapter = new OracleDataAdapter(objCommand); using (OracleConnection strConn = GetConnection()) { try { objCommand.Connection = strConn; strConn.Open(); objDataAdapter.Fill(dt); dt.AcceptChanges(); } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { strConn.Close(); } } return(dt); }
//Datewise Pdf record public DataTable DateWiseSelectionFileUpload(SelectionEntryModel objSelectionEntryModel) { DataTable dt = new DataTable(); string sql = ""; sql = "SELECT " + "rownum sl, " + "TO_CHAR (NVL (TRAN_ID,'0'))TRAN_ID, " + "TO_CHAR (NVL (FILE_NAME,'N/A'))FILE_NAME, " + "TO_CHAR(UPLOAD_DATE, 'dd/mm/yyyy')UPLOAD_DATE " + " FROM VEW_SELECTION_FILE_RECORD where head_office_id = '" + objSelectionEntryModel.HeadOfficeId + "' AND branch_office_id = '" + objSelectionEntryModel.BranchOfficeId + "' "; if (!string.IsNullOrEmpty(objSelectionEntryModel.UploadDate)) { sql = sql + " and UPLOAD_DATE = TO_DATE('" + objSelectionEntryModel.UploadDate + "','dd/mm/yyyy') "; } //if (!string.IsNullOrEmpty(objTechpackFileUploadModel.SearchBy)) //{ // sql = sql + "and (lower(SEASON_YEAR) like lower( '%" + objTechpackFileUploadModel.SearchBy + "%') or upper(SEASON_YEAR)like upper('%" + objTechpackFileUploadModel.SearchBy + "%') ) or (lower(STYLE_NO) like lower( '%" + objTechpackFileUploadModel.SearchBy + "%') or upper(STYLE_NO)like upper('%" + objTechpackFileUploadModel.SearchBy + "%') or (lower(BUYER_NAME) like lower( '%" + objTechpackFileUploadModel.SearchBy + "%') or upper(BUYER_NAME)like upper('%" + objTechpackFileUploadModel.SearchBy + "%') ) )"; //} sql = sql + " ORDER BY sl"; OracleCommand objCommand = new OracleCommand(sql); OracleDataAdapter objDataAdapter = new OracleDataAdapter(objCommand); using (OracleConnection strConn = GetConnection()) { try { objCommand.Connection = strConn; strConn.Open(); objDataAdapter.Fill(dt); dt.AcceptChanges(); } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { strConn.Close(); } } return(dt); }
//serach style no from purchase order public DataTable SearchStyleFromPO(SelectionEntryModel objSelectionEntryModel) { DataTable dt1 = new DataTable(); string sql = ""; sql = "SELECT " + "rownum sl, " + "TO_CHAR (NVL (STYLE_NO,'N/A'))STYLE_NO, " + "TO_CHAR (NVL (MODEL_NO,'N/A'))MODEL_NO, " + "TO_CHAR (NVL (SEASON_YEAR,'0'))SEASON_YEAR " + " FROM VEW_PURCHASE_ORDER_MERCHAN_SUB where head_office_id = '" + objSelectionEntryModel.HeadOfficeId + "' AND branch_office_id = '" + objSelectionEntryModel.BranchOfficeId + "' "; if (!string.IsNullOrEmpty(objSelectionEntryModel.CurrentYear)) { sql = sql + " and SEASON_YEAR = '" + objSelectionEntryModel.CurrentYear + "' "; } sql = sql + " ORDER BY sl"; OracleCommand objCommand = new OracleCommand(sql); OracleDataAdapter objDataAdapter = new OracleDataAdapter(objCommand); using (OracleConnection strConn = GetConnection()) { try { objCommand.Connection = strConn; strConn.Open(); objDataAdapter.Fill(dt1); dt1.AcceptChanges(); } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { strConn.Close(); } } return(dt1); }
//get pdf upload record public DataTable GetSelectionFileUploadRecord(SelectionEntryModel objSelectionEntryModel) { DataTable dt = new DataTable(); string sql = ""; sql = "SELECT " + "rownum sl, " + "TO_CHAR(UPLOAD_DATE, 'dd/mm/yyyy')UPLOAD_DATE, " + "TO_CHAR (NVL (NO_OF_FILE,'0'))NO_OF_FILE " + " FROM VEW_SELECTION_FILE_UPLOAD where head_office_id = '" + objSelectionEntryModel.HeadOfficeId + "' AND branch_office_id = '" + objSelectionEntryModel.BranchOfficeId + "' "; if (!string.IsNullOrEmpty(objSelectionEntryModel.UploadDate)) { sql = sql + " and UPLOAD_DATE = TO_DATE('" + objSelectionEntryModel.UploadDate + "','dd/mm/yyyy') "; } sql = sql + " ORDER BY sl"; OracleCommand objCommand = new OracleCommand(sql); OracleDataAdapter objDataAdapter = new OracleDataAdapter(objCommand); using (OracleConnection strConn = GetConnection()) { try { objCommand.Connection = strConn; strConn.Open(); objDataAdapter.Fill(dt); dt.AcceptChanges(); } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { strConn.Close(); } } return(dt); }
//PDF file View public SelectionEntryModel ViewPdfFile(SelectionEntryModel objSelectionEntryModel) { if (!string.IsNullOrEmpty(objSelectionEntryModel.UploadDate) && !string.IsNullOrEmpty(objSelectionEntryModel.GridTranId)) { using (OracleConnection strConn = GetConnection()) { using (OracleCommand cmd = new OracleCommand()) { cmd.CommandText = "SELECT FILE_SIZE,FILE_NAME FROM SELECTION_FILE_UPLOAD WHERE TRAN_ID ='" + objSelectionEntryModel.GridTranId + "' and UPLOAD_DATE =TO_DATE('" + objSelectionEntryModel.UploadDate + "','dd/mm/yyyy') "; cmd.Connection = strConn; strConn.Open(); using (OracleDataReader sdr = cmd.ExecuteReader()) { sdr.Read(); objSelectionEntryModel.bytes = (byte[])sdr["FILE_SIZE"]; objSelectionEntryModel.FileName = sdr["FILE_NAME"].ToString(); } strConn.Close(); } } } return(objSelectionEntryModel); }
//save data public string SaveSelectionEntrySave(SelectionEntryModel objSelectionEntryModel) { string strMsg = ""; int x = objSelectionEntryModel.ArrReceived.Count(); for (int i = 0; i < x; i++) { var arrayEUSS = ""; var arrayEUAW = ""; var arrayCountry = ""; var arrayTranId = objSelectionEntryModel.ArrTranId[i]; if (objSelectionEntryModel.ArrEUSS != null) { arrayEUSS = objSelectionEntryModel.ArrEUSS[i]; } if (objSelectionEntryModel.ArrEUAW != null) { arrayEUAW = objSelectionEntryModel.ArrEUAW[i]; } if (objSelectionEntryModel.ArrCountry != null) { arrayCountry = objSelectionEntryModel.ArrCountry[i]; } var arrayElasticity = objSelectionEntryModel.ArrElasticity[i]; var arraySupply = objSelectionEntryModel.ArrSupply[i]; var arrayReceived = objSelectionEntryModel.ArrReceived[i]; OracleTransaction objOracleTransaction = null; OracleCommand objOracleCommand = new OracleCommand("pro_selection_entry_save"); objOracleCommand.CommandType = CommandType.StoredProcedure; if (!string.IsNullOrEmpty(arrayTranId)) { objOracleCommand.Parameters.Add("P_TRAN_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = arrayTranId.Trim(); } else { objOracleCommand.Parameters.Add("P_TRAN_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (!string.IsNullOrEmpty(objSelectionEntryModel.StyleNo)) { objOracleCommand.Parameters.Add("P_STYLE_NO", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = objSelectionEntryModel.StyleNo.Trim(); } else { objOracleCommand.Parameters.Add("P_STYLE_NO", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (!string.IsNullOrEmpty(objSelectionEntryModel.ModelNo)) { objOracleCommand.Parameters.Add("P_MODEL_NO", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = objSelectionEntryModel.ModelNo.Trim(); } else { objOracleCommand.Parameters.Add("P_MODEL_NO", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (!string.IsNullOrEmpty(objSelectionEntryModel.TotalReceived)) { objOracleCommand.Parameters.Add("P_TOTAL_RECEIVED", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = objSelectionEntryModel.TotalReceived.Trim(); } else { objOracleCommand.Parameters.Add("P_TOTAL_RECEIVED", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (!string.IsNullOrEmpty(objSelectionEntryModel.CountryId)) { objOracleCommand.Parameters.Add("P_COUNTRY_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = objSelectionEntryModel.CountryId.Trim(); } else { objOracleCommand.Parameters.Add("P_COUNTRY_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (!string.IsNullOrEmpty(arrayEUSS)) { objOracleCommand.Parameters.Add("P_EUROPE_SS_QUANTITY", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = arrayEUSS.Trim(); } else { objOracleCommand.Parameters.Add("P_EUROPE_SS_QUANTITY", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (!string.IsNullOrEmpty(arrayEUAW)) { objOracleCommand.Parameters.Add("P_EUROPE_AW_QUANTITY", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = arrayEUAW.Trim(); } else { objOracleCommand.Parameters.Add("P_EUROPE_AW_QUANTITY", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (!string.IsNullOrEmpty(arrayCountry)) { objOracleCommand.Parameters.Add("P_COUNTRY_ORDER_QUANTITY", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = arrayCountry.Trim(); } else { objOracleCommand.Parameters.Add("P_COUNTRY_ORDER_QUANTITY", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (!string.IsNullOrEmpty(arrayElasticity)) { objOracleCommand.Parameters.Add("P_ELASTICITY", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = arrayElasticity.Trim(); } else { objOracleCommand.Parameters.Add("P_ELASTICITY", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (!string.IsNullOrEmpty(arraySupply)) { objOracleCommand.Parameters.Add("P_SUPPLY", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = arraySupply.Trim(); } else { objOracleCommand.Parameters.Add("P_SUPPLY", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (!string.IsNullOrEmpty(arrayReceived)) { objOracleCommand.Parameters.Add("P_COUNTRY_RECEIVED_QUANTITY", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = arrayReceived.Trim(); } else { objOracleCommand.Parameters.Add("P_COUNTRY_RECEIVED_QUANTITY", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } objOracleCommand.Parameters.Add("P_CREATE_BY", OracleDbType.Varchar2, ParameterDirection.Input).Value = objSelectionEntryModel.UpdateBy; objOracleCommand.Parameters.Add("p_update_by", OracleDbType.Varchar2, ParameterDirection.Input).Value = objSelectionEntryModel.UpdateBy; objOracleCommand.Parameters.Add("p_head_office_id", OracleDbType.Varchar2, ParameterDirection.Input).Value = objSelectionEntryModel.HeadOfficeId; objOracleCommand.Parameters.Add("p_branch_office_id", OracleDbType.Varchar2, ParameterDirection.Input).Value = objSelectionEntryModel.BranchOfficeId; 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); objOracleTransaction.Rollback(); } finally { strConn.Close(); } } } return(strMsg); }
//save section entry pdf file public string SaveSeactionPdfFileUpload(SelectionEntryModel objSelectionEntryModel) { string strMsg = ""; OracleTransaction objOracleTransaction = null; OracleCommand objOracleCommand = new OracleCommand("SELECTION_FILE_UPLOAD_SAVE"); objOracleCommand.CommandType = CommandType.StoredProcedure; if (!string.IsNullOrEmpty(objSelectionEntryModel.GridTranId)) { objOracleCommand.Parameters.Add("P_TRAN_ID", OracleDbType.Varchar2, ParameterDirection.Input).Value = objSelectionEntryModel.GridTranId.Trim(); } else { objOracleCommand.Parameters.Add("P_TRAN_ID", OracleDbType.Varchar2, ParameterDirection.Input).Value = null; } if (!string.IsNullOrEmpty(objSelectionEntryModel.UploadDate)) { objOracleCommand.Parameters.Add("P_UPLOAD_DATE", OracleDbType.Varchar2, ParameterDirection.Input).Value = objSelectionEntryModel.UploadDate.Trim(); } else { objOracleCommand.Parameters.Add("P_UPLOAD_DATE", OracleDbType.Varchar2, ParameterDirection.Input).Value = null; } if (!string.IsNullOrEmpty(objSelectionEntryModel.FileName)) { objOracleCommand.Parameters.Add("p_file_name", OracleDbType.Varchar2, ParameterDirection.Input).Value = objSelectionEntryModel.FileName.Trim(); } else { objOracleCommand.Parameters.Add("p_file_name", OracleDbType.Varchar2, ParameterDirection.Input).Value = null; } if (!string.IsNullOrEmpty(objSelectionEntryModel.CVSize)) { byte[] array = System.Convert.FromBase64String(objSelectionEntryModel.CVSize); objOracleCommand.Parameters.Add("P_FILE_SIZE", OracleDbType.Blob, ParameterDirection.Input).Value = array; } else { objOracleCommand.Parameters.Add("P_FILE_SIZE", OracleDbType.Clob, ParameterDirection.Input).Value = null; } if (!string.IsNullOrEmpty(objSelectionEntryModel.FileExtension)) { objOracleCommand.Parameters.Add("P_FILE_EXTENSION", OracleDbType.Varchar2, ParameterDirection.Input).Value = objSelectionEntryModel.FileExtension.Trim(); } else { objOracleCommand.Parameters.Add("P_FILE_EXTENSION", OracleDbType.Varchar2, ParameterDirection.Input).Value = null; } objOracleCommand.Parameters.Add("p_update_by", OracleDbType.Varchar2, 100, ParameterDirection.Input).Value = objSelectionEntryModel.UpdateBy; objOracleCommand.Parameters.Add("p_create_by", OracleDbType.Varchar2, 100, ParameterDirection.Input).Value = objSelectionEntryModel.UpdateBy; objOracleCommand.Parameters.Add("p_head_office_id", OracleDbType.Varchar2, 100, ParameterDirection.Input).Value = objSelectionEntryModel.HeadOfficeId; objOracleCommand.Parameters.Add("p_branch_office_id", OracleDbType.Varchar2, 100, ParameterDirection.Input).Value = objSelectionEntryModel.BranchOfficeId; 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); objOracleTransaction.Rollback(); } finally { strConn.Close(); } } return(strMsg); }
//delete data public string DeleteSelectionEntry(SelectionEntryModel objSelectionEntryModel) { string vStrMsg = ""; string[] TranIdArray = objSelectionEntryModel.GridTranId.Split(','); int x = TranIdArray.Count(); for (int i = 0; i < x; i++) { var arrayTranId = TranIdArray[i]; OracleTransaction objOracleTransaction = null; OracleCommand objOracleCommand = new OracleCommand("PRO_SELECTION_ENTRY_DELETE"); objOracleCommand.CommandType = CommandType.StoredProcedure; if (!string.IsNullOrEmpty(arrayTranId)) { objOracleCommand.Parameters.Add("P_TRAN_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = arrayTranId.Trim(); } else { objOracleCommand.Parameters.Add("P_TRAN_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (!string.IsNullOrEmpty(objSelectionEntryModel.StyleNo)) { objOracleCommand.Parameters.Add("P_STYLE_NO", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = objSelectionEntryModel.StyleNo.Trim(); } else { objOracleCommand.Parameters.Add("P_STYLE_NO", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (!string.IsNullOrEmpty(objSelectionEntryModel.ModelNo)) { objOracleCommand.Parameters.Add("P_MODEL_NO", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = objSelectionEntryModel.ModelNo.Trim(); } else { objOracleCommand.Parameters.Add("P_MODEL_NO", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } objOracleCommand.Parameters.Add("p_update_by", OracleDbType.Varchar2, ParameterDirection.Input).Value = objSelectionEntryModel.UpdateBy; objOracleCommand.Parameters.Add("p_head_office_id", OracleDbType.Varchar2, ParameterDirection.Input).Value = objSelectionEntryModel.HeadOfficeId; objOracleCommand.Parameters.Add("p_branch_office_id", OracleDbType.Varchar2, ParameterDirection.Input).Value = objSelectionEntryModel.BranchOfficeId; 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(); vStrMsg = objOracleCommand.Parameters["P_MESSAGE"].Value.ToString(); } catch (Exception ex) { throw new Exception("Error : " + ex.Message); objOracleTransaction.Rollback(); } finally { strConn.Close(); } } } return(vStrMsg); }