public PoEntryModel GetPoEntryData(string styleId, string seasonYear, string seasonName, string headOfficeId, string branchOfficeId) { PoEntryModel objPoEntryModel = new PoEntryModel(); var sql = "SELECT " + "STYLE_NO," + "STYLE_NAME," + "HEAD_OFFICE_ID," + "BRANCH_OFFICE_ID," + "SEASON_YEAR," + "SEASON_ID," + "SEASON_NAME," + "FIT_ID," + "FIT_NAME," + "SIZE_ID," + "OCCASION_ID," + "PO_NO " + " FROM VEW_PRODUCT_MAIN where STYLE_NO = '" + styleId + "' AND SEASON_YEAR = '" + seasonYear + "' AND SEASON_NAME = '" + seasonName + "' 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()) { objPoEntryModel.StyleNo = objDataReader.GetValue(0).ToString(); objPoEntryModel.StyleName = objDataReader.GetValue(1).ToString(); objPoEntryModel.SeasoneYear = objDataReader.GetValue(4).ToString(); objPoEntryModel.SeasoneName = objDataReader.GetValue(5).ToString(); objPoEntryModel.Fit = objDataReader.GetValue(7).ToString(); objPoEntryModel.Occasion = objDataReader.GetValue(10).ToString(); objPoEntryModel.PoNumber = objDataReader.GetValue(11).ToString(); } } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { strConn.Close(); } } return(objPoEntryModel); }
//Save and Delete Data public string SavePoEntry(PoEntryModel objPoEntryModel) { string strMsg; OracleCommand objOracleCommand = new OracleCommand("PRO_PO_INFO_SAVE"); objOracleCommand.CommandType = CommandType.StoredProcedure; objOracleCommand.Parameters.Add("P_TRAN_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.TranIdS) ? objPoEntryModel.TranIdS : null; objOracleCommand.Parameters.Add("P_PO_NO", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.PoNumber) ? objPoEntryModel.PoNumber : null; objOracleCommand.Parameters.Add("P_STYLE_NO", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.StyleNo) ? objPoEntryModel.StyleNo : null; objOracleCommand.Parameters.Add("P_SEASON_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.SeasoneName) ? objPoEntryModel.SeasoneName : null; objOracleCommand.Parameters.Add("P_SEASON_YEAR", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.SeasoneYear) ? objPoEntryModel.SeasoneYear : null; objOracleCommand.Parameters.Add("P_COST_PRICE", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.CostPrice) ? objPoEntryModel.CostPrice : null; objOracleCommand.Parameters.Add("P_RETAIL_PRICE", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.RetailPrice) ? objPoEntryModel.RetailPrice : null; objOracleCommand.Parameters.Add("P_FABRIC_QUANTITY", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.FabricQuantity) ? objPoEntryModel.FabricQuantity : null; objOracleCommand.Parameters.Add("P_FIT_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.Fit) ? objPoEntryModel.Fit : null; objOracleCommand.Parameters.Add("P_store_delivery_date", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.StoreDeleveryDate) ? objPoEntryModel.StoreDeleveryDate : null; objOracleCommand.Parameters.Add("P_size_id", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.SizeIdS) ? objPoEntryModel.SizeIdS : null; objOracleCommand.Parameters.Add("P_size_value", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.SizeValueS) ? objPoEntryModel.SizeValueS : null; objOracleCommand.Parameters.Add("P_EMBROIDARY_YN", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.EmbroidaryS) ? objPoEntryModel.EmbroidaryS : null; objOracleCommand.Parameters.Add("P_KARCHUPI_YN", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.KarchupiS) ? objPoEntryModel.KarchupiS : null; objOracleCommand.Parameters.Add("P_PRINT_YN", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.PrintS) ? objPoEntryModel.PrintS : null; objOracleCommand.Parameters.Add("P_WASH_YN", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.WashS) ? objPoEntryModel.WashS : null; objOracleCommand.Parameters.Add("P_OCCASION_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.Occasion) ? objPoEntryModel.Occasion : null; objOracleCommand.Parameters.Add("P_COLOR_WAY_NO_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.ColorWayNumberS) ? objPoEntryModel.ColorWayNumberS : null; objOracleCommand.Parameters.Add("P_COLOR_WAY_NAME", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.ColorWayNameS) ? objPoEntryModel.ColorWayNameS : null; objOracleCommand.Parameters.Add("P_INSERT_DATE", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.InsertDate) ? objPoEntryModel.InsertDate : null; objOracleCommand.Parameters.Add("P_UPDATE_BY", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.UpdateBy) ? objPoEntryModel.UpdateBy : null; objOracleCommand.Parameters.Add("p_HEAD_OFFICE_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.HeadOfficeId) ? objPoEntryModel.HeadOfficeId : null; objOracleCommand.Parameters.Add("p_BRANCH_OFFICE_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objPoEntryModel.BranchOfficeId) ? objPoEntryModel.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); }