/// <summary> /// Preview archive fragments /// </summary> /// <param name="camera">Selected camera</param> /// <returns></returns> /// <remarks> /// TODO: Improve performance. Solve freeze behavior. /// </remarks> private async Task InitFragmentsAsync(CameraViewModel camera) { try { _fragments.Clear(); camera.Model.Fragments.Clear(); DateTime dateEnd = DateTime.Now.ToUniversalTime(); DateTime dateStart = new DateTime(year: dateEnd.Year - 1, month: dateEnd.Month, day: dateEnd.Day, hour: dateEnd.Hour, minute: dateEnd.Minute, second: dateEnd.Second); string url = _spec.GetArchiveUrl(camera.Model, dateStart, dateEnd); XmlDocument doc = await SpecificationModel.GetXmlDocAsync(url); await camera.Model.InitFragments(doc); foreach (ArchiveFragment f in camera.Model.Fragments) { _fragments.Add(new ArchiveFragmentViewModel(f.FromTime, f.ToTime)); } } catch (InvalidOperationException e) { System.Diagnostics.Debug.WriteLine(e.Message); } }
public async Task PUT_Updates_Data() { var controller = new SpecificationsController(Context); ConfigureRequest(controller); var item = SetupContext(); var model = new SpecificationModel { Id = item.ItemId, UnitOfMeasure = new UnitOfMeasureModel { Id = Context.UnitsOfMeasure.First().Id }, ComparisonType = ComparisonType.Either, LowerBound = "True", UpperBound = "False", IsDeleted = true }; var result = await GetData <SpecificationModel>(controller.Put(model)); Assert.AreEqual(model.Id, result.Id); Assert.AreEqual(model.UnitOfMeasure.Id, result.UnitOfMeasure.Id); Assert.AreEqual(model.ComparisonType, result.ComparisonType); Assert.AreEqual(model.LowerBound, result.LowerBound); Assert.IsTrue(result.IsDeleted); }
public static StoreItemModel ConvertStoreItemToModel(StoreItem storeItem) { if (storeItem == null) { return(null); } List <ImageModel> storeImages = new List <ImageModel>(); List <SpecificationModel> specifications = new List <SpecificationModel>(); List <CommentModel> comments = new List <CommentModel>(); if (storeItem.Images != null) { foreach (var image in storeItem.Images) { var imageFileBase = ConvertToImageModel(image); if (imageFileBase == null) { continue; } storeImages.Add(imageFileBase); } } if (storeItem.Specification != null) { foreach (var specification in storeItem.Specification) { SpecificationModel specificationModel = ConvertToSpecificationModel(specification); specifications.Add(specificationModel); } } if (storeItem.UserComments != null) { foreach (var userComment in storeItem.UserComments) { CommentModel commentModel = CommentProcessor.ConvertToCommentModel(userComment); comments.Add(commentModel); } } StoreItemModel model = new StoreItemModel { Id = storeItem.Id, Name = storeItem.Name, Discription = storeItem.Discription, Brand = storeItem.Brand, Price = storeItem.Price, Discount = storeItem.DiscountPercentage, Images = storeImages, InStock = storeItem.InStock, Specifications = specifications, Comments = comments, }; return(model); }
private static SpecificationModel ConvertToSpecificationModel(Specification specification) { SpecificationModel specificationModel = new SpecificationModel { Name = specification.Name, Description = specification.Description }; return(specificationModel); }
public async Task PUT_Is_Bad_Request_Missing_UnitId() { var controller = new SpecificationsController(Context); ConfigureRequest(controller); var model = new SpecificationModel(); var result = await GetResponse(controller.Put(model)); Assert.AreEqual(HttpStatusCode.BadRequest, result.StatusCode); }
public SpecificationModel GetStyleWiseFromProductMain(SpecificationModel objDressSpecModel) { var sql = "SELECT " + "TO_CHAR (NVL (STYLE_NO,'N/A'))STYLE_NO, " + "TO_CHAR (NVL (SEASON_YEAR,'0'))SEASON_YEAR, " + "TO_CHAR (NVL (SEASON_ID,'0'))SEASON_ID, " + "TO_CHAR (NVL (SEASON_NAME,'N/A'))SEASON_NAME " + "FROM VEW_PRODUCT_MAIN where head_office_id = '" + objDressSpecModel.HeadOfficeId + "' AND branch_office_id = '" + objDressSpecModel.BranchOfficeId + "' "; if (!string.IsNullOrEmpty(objDressSpecModel.SeasonYear)) { sql = sql + " and SEASON_YEAR = '" + objDressSpecModel.SeasonYear + "' "; } if (!string.IsNullOrEmpty(objDressSpecModel.SeasonId)) { sql = sql + " and SEASON_ID = '" + objDressSpecModel.SeasonId + "' "; } using (OracleConnection objConnection = GetConnection()) { OracleCommand objCommand = new OracleCommand(sql, objConnection); objConnection.Open(); OracleDataReader objReader = objCommand.ExecuteReader(); try { while (objReader.Read()) { objDressSpecModel.StyleNo = objReader.GetString(0); objDressSpecModel.SeasonYear = objReader.GetString(1); objDressSpecModel.SeasonId = objReader.GetString(2); objDressSpecModel.SeasonName = objReader.GetString(3); } } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { objReader.Close(); objConnection.Close(); } } return(objDressSpecModel); }
/// <summary> /// Request data about cameras and add them as soon as possible /// </summary> /// <param name="url">Streaming server url</param> /// <returns></returns> public async Task InitSpecificationModelAsync(string url) { try { _specModel = await SpecificationModel.CreateAsync(url); _specModel.InitCameras(); Cell.SetServer(_specModel); Header = TITLE; } catch (InvalidOperationException e) { Header = e.Message; Cell.RemoveServer(); System.Diagnostics.Debug.WriteLine(e.Message); } }
public DataTable SearchStyleFromProductMain(SpecificationModel objDressSpecModel) { DataTable dataTable = new DataTable(); string sql = "SELECT " + "ROWNUM SL, " + "TO_CHAR (NVL (SEASON_ID,'0'))SEASON_ID, " + "TO_CHAR (NVL (SEASON_NAME,'N/A'))SEASON_NAME, " + "TO_CHAR (NVL (SEASON_YEAR,'0'))SEASON_YEAR, " + "TO_CHAR (NVL (STYLE_NO,'N/A'))STYLE_NO, " + "TO_CHAR (NVL (STYLE_NO,'N/A'))STYLE_NAME " + "FROM VEW_PRODUCT_MAIN where head_office_id = '" + objDressSpecModel.HeadOfficeId + "' AND branch_office_id = '" + objDressSpecModel.BranchOfficeId + "' "; if (!string.IsNullOrWhiteSpace(objDressSpecModel.StyleSearch)) { sql = sql + "and (lower(STYLE_NO) like lower( '%" + objDressSpecModel.StyleSearch + "%') or upper(STYLE_NO)like upper('%" + objDressSpecModel.StyleSearch + "%') )"; } 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(dataTable); dataTable.AcceptChanges(); } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { strConn.Close(); } } return(dataTable); }
// Create specification public int create(int weight, int height, int width, int length) { // Establish models SpecificationModel specModel = new SpecificationModel(); // Holds the new specification Specification newSpec = new Specification(); // Stored details for the specification newSpec.Weight = weight; newSpec.Height = height; newSpec.Width = width; newSpec.Length = length; // Adds the object to the database int specificationID = specModel.NewSpecification(newSpec); // Return the specificationID return(specificationID); }
public async Task <IHttpActionResult> Put(SpecificationModel updated) { if (updated == null) { return(this.BadRequest("Model must not be null.")); } if (updated.UnitOfMeasure == null) { return(this.BadRequest("Unit of measure must not be null.")); } var results = await this.datasource.UpdateAsync(updated); if (results == null) { return(this.BadRequest("The record could not be updated.")); } return(this.Ok(results)); }
// Calculates the base cost of the package based on dimensions / weight private int calcBaseCost(Package thisPackage) { // In pence int runningCost = 0; SpecificationModel specModel = new SpecificationModel(); // Iterates through the packages in the list Specification thisSpec = specModel.SearchSpecification(thisPackage.SpecificationID); // Works out delivery band if (thisSpec.Length <= 42 && thisSpec.Width <= 34 && thisSpec.Height <= 27 && thisSpec.Weight <= 100) { runningCost += 1500; } else if (thisSpec.Length <= 50 && thisSpec.Width <= 45 && thisSpec.Height <= 34 && thisSpec.Weight <= 250) { runningCost += 2100; } else if (thisSpec.Length <= 60 && thisSpec.Width <= 54 && thisSpec.Height <= 41 && thisSpec.Weight <= 400) { runningCost += 3000; } else if (thisSpec.Length <= 96 && thisSpec.Width <= 15 && thisSpec.Height <= 15) { runningCost += 1750; } else // Catch { // Outwith package band fee runningCost += 3500; } // Returns the collective running cost return(runningCost); }
public async Task PUT_Is_OK() { var controller = new SpecificationsController(Context); ConfigureRequest(controller); var item = SetupContext(); var model = new SpecificationModel { Id = item.ItemId, UnitOfMeasure = new UnitOfMeasureModel { Id = Context.UnitsOfMeasure.First().Id }, ComparisonType = ComparisonType.Between, LowerBound = "0", UpperBound = "10" }; var result = await GetResponse(controller.Put(model)); Assert.AreEqual(HttpStatusCode.OK, result.StatusCode); }
public DataTable GetDressSpecRecord(SpecificationModel objDressSpecModel) { DataTable dataTable = new DataTable(); string sql = "SELECT " + "ROWNUM SL, " + "STYLE_NO, " + "STYLE_NAME, " + "SEASON_ID, " + "SEASON_NAME, " + "SEASON_YEAR, " + "TO_CHAR(SPECIFICATION_DATE, 'dd/mm/yyyy') SPECIFICATION_DATE, " + "CREATE_BY, " + "CREATE_DATE, " + "UPDATE_BY, " + "UPDATE_DATE, " + "HEAD_OFFICE_ID, " + "BRANCH_OFFICE_ID " + "FROM VEW_DRESS_SPEC_MAIN WHERE HEAD_OFFICE_ID = '" + objDressSpecModel.HeadOfficeId + "' AND BRANCH_OFFICE_ID = '" + objDressSpecModel.BranchOfficeId + "' "; if (!string.IsNullOrWhiteSpace(objDressSpecModel.SearchBy)) { sql = sql + "and (lower(STYLE_NO) like lower( '%" + objDressSpecModel.SearchBy + "%') " + "or upper(STYLE_NO)like upper('%" + objDressSpecModel.SearchBy + "%')) " + "or (lower(STYLE_NAME) like lower( '%" + objDressSpecModel.SearchBy + "%') " + "or upper(STYLE_NAME)like upper('%" + objDressSpecModel.SearchBy + "%')) " + "or (lower(SEASON_NAME) like lower( '%" + objDressSpecModel.SearchBy + "%') " + "or upper(SEASON_NAME)like upper('%" + objDressSpecModel.SearchBy + "%')) " + //"or (lower(SPECIFICATION_DATE) like lower( '%" + objDressSpecModel.SearchBy + "%') " + //"or upper(SPECIFICATION_DATE)like upper('%" + objDressSpecModel.SearchBy + "%')) " + "or (lower(SEASON_YEAR) like lower( '%" + objDressSpecModel.SearchBy + "%') " + "or upper(SEASON_YEAR)like upper('%" + objDressSpecModel.SearchBy + "%'))"; } if (!string.IsNullOrWhiteSpace(objDressSpecModel.SeasonYear)) { sql = sql + "and SEASON_YEAR= '" + objDressSpecModel.SeasonYear + "'"; } if (!string.IsNullOrWhiteSpace(objDressSpecModel.SeasonId)) { sql = sql + "and SEASON_ID = '" + objDressSpecModel.SeasonId + "'"; } 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(dataTable); dataTable.AcceptChanges(); } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { strConn.Close(); } } return(dataTable); }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in .NET: //ORIGINAL LINE: public FeatureModel(org.maltparser.core.feature.spec.SpecificationModel _specModel, FeatureRegistry _registry, org.maltparser.core.feature.system.FeatureEngine _engine, String dataSplitColumn, String dataSplitStructure) throws org.maltparser.core.exception.MaltChainedException public FeatureModel(SpecificationModel _specModel, FeatureRegistry _registry, FeatureEngine _engine, string dataSplitColumn, string dataSplitStructure) { specModel = _specModel; registry = _registry; featureEngine = _engine; addressFunctionCache = new List <AddressFunction>(); featureFunctionCache = new List <FeatureFunction>(); FeatureVector tmpMainFeatureVector = null; foreach (SpecificationSubModel subModel in specModel) { FeatureVector fv = new FeatureVector(this, subModel); if (tmpMainFeatureVector == null) { if (subModel.SubModelName.Equals("MAIN")) { tmpMainFeatureVector = fv; } else { tmpMainFeatureVector = fv; put(subModel.SubModelName, fv); } } else { put(subModel.SubModelName, fv); } } mainFeatureVector = tmpMainFeatureVector; if (!ReferenceEquals(dataSplitColumn, null) && dataSplitColumn.Length > 0 && !ReferenceEquals(dataSplitStructure, null) && dataSplitStructure.Length > 0) { //JAVA TO C# CONVERTER WARNING: The original Java variable was marked 'final': //ORIGINAL LINE: final StringBuilder sb = new StringBuilder(); StringBuilder sb = new StringBuilder(); sb.Append("InputColumn("); sb.Append(dataSplitColumn); sb.Append(", "); sb.Append(dataSplitStructure); sb.Append(')'); divideFeatureFunction = identifyFeature(sb.ToString()); // this.divideFeatureIndexVectorMap = new HashMap<String,ArrayList<Integer>>(); divideFeatureIndexVector = new List <int>(); for (int i = 0; i < mainFeatureVector.Count; i++) { if (mainFeatureVector[i].Equals(divideFeatureFunction)) { divideFeatureIndexVector.Add(i); } } foreach (SpecificationSubModel subModel in specModel) { FeatureVector featureVector = get(subModel.SubModelName); if (featureVector == null) { featureVector = mainFeatureVector; } string divideKeyName = "/" + subModel.SubModelName; // divideFeatureIndexVectorMap.put(divideKeyName, divideFeatureIndexVector); FeatureVector divideFeatureVector = (FeatureVector)featureVector.clone(); foreach (int?i in divideFeatureIndexVector) { divideFeatureVector.Remove(divideFeatureVector[i]); } put(divideKeyName, divideFeatureVector); } } else { divideFeatureFunction = null; // this.divideFeatureIndexVectorMap = null; divideFeatureIndexVector = null; } }
public string DeleteTrimsEntry(SpecificationModel objDressSpecModel) { string strMsg = ""; //string[] tranIdArray = objDressSpecModel.GridTranId.Split(','); //int x = tranIdArray.Count(); int x = objDressSpecModel.TranId.Count(); for (int i = 0; i < x; i++) { //var arrayTranId = tranIdArray[i]; string tranId = objDressSpecModel.TranId[i]; OracleCommand objOracleCommand = new OracleCommand("PRO_DRESS_SPEC_DELETE"); objOracleCommand.CommandType = CommandType.StoredProcedure; if (objDressSpecModel.StyleNo != "") { objOracleCommand.Parameters.Add("p_STYLE_NO", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = objDressSpecModel.StyleNo; } else { objOracleCommand.Parameters.Add("p_STYLE_NO", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (objDressSpecModel.SeasonYear != "") { objOracleCommand.Parameters.Add("p_SEASON_YEAR", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = objDressSpecModel.SeasonYear; } else { objOracleCommand.Parameters.Add("p_SEASON_YEAR", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (objDressSpecModel.SeasonId != "") { objOracleCommand.Parameters.Add("p_SEASON_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = objDressSpecModel.SeasonId; } else { objOracleCommand.Parameters.Add("p_SEASON_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (tranId != null) { objOracleCommand.Parameters.Add("p_TRAN_ID", OracleDbType.Varchar2, ParameterDirection.Input).Value = tranId; } else { objOracleCommand.Parameters.Add("p_TRAN_ID", OracleDbType.Varchar2, ParameterDirection.Input).Value = null; } objOracleCommand.Parameters.Add("p_update_by", OracleDbType.Varchar2, ParameterDirection.Input).Value = objDressSpecModel.UpdateBy; objOracleCommand.Parameters.Add("p_head_office_id", OracleDbType.Varchar2, ParameterDirection.Input).Value = objDressSpecModel.HeadOfficeId; objOracleCommand.Parameters.Add("p_branch_office_id", OracleDbType.Varchar2, ParameterDirection.Input).Value = objDressSpecModel.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) { trans.Rollback(); throw new Exception("Error : " + ex.Message); } finally { trans.Dispose(); strConn.Close(); } } } return(strMsg); }
public DataTable GetDressSpecDetailRecord(SpecificationModel objDressSpecModel) { DataTable dataTable = new DataTable(); string sql = "SELECT " + "STYLE_NO, " + "STYLE_NAME, " + "SEASON_ID, " + "SEASON_YEAR, " + "SIZE_ID, " + "TO_CHAR(SPECIFICATION_DATE, 'dd/mm/yyyy') SPECIFICATION_DATE, " + "SPEC_DESCRIPTION, " + "SIZE_VALUE, " + "TRAN_ID, " + "CREATE_BY, " + "CREATE_DATE, " + "UPDATE_BY, " + "UPDATE_DATE, " + "HEAD_OFFICE_ID, " + "BRANCH_OFFICE_ID " + "FROM product_spec_sub WHERE HEAD_OFFICE_ID = '" + objDressSpecModel.HeadOfficeId + "' AND BRANCH_OFFICE_ID = '" + objDressSpecModel.BranchOfficeId + "' "; if (!string.IsNullOrWhiteSpace(objDressSpecModel.StyleNo)) { sql = sql + "and STYLE_NO = '" + objDressSpecModel.StyleNo + "'"; } if (!string.IsNullOrWhiteSpace(objDressSpecModel.SeasonYear)) { sql = sql + "and SEASON_YEAR= '" + objDressSpecModel.SeasonYear + "'"; } if (!string.IsNullOrWhiteSpace(objDressSpecModel.SeasonId)) { sql = sql + "and SEASON_ID = '" + objDressSpecModel.SeasonId + "'"; } sql = sql + " ORDER BY STYLE_NO"; OracleCommand objCommand = new OracleCommand(sql); OracleDataAdapter objDataAdapter = new OracleDataAdapter(objCommand); using (OracleConnection strConn = GetConnection()) { try { objCommand.Connection = strConn; strConn.Open(); objDataAdapter.Fill(dataTable); dataTable.AcceptChanges(); } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { strConn.Close(); } } return(dataTable); }
public void SetServer(SpecificationModel spec) { _spec = spec; InitCameras(); }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in .NET: //ORIGINAL LINE: public FeatureModel getFeatureModel(org.maltparser.core.feature.spec.SpecificationModel specModel, FeatureRegistry registry, String dataSplitColumn, String dataSplitStructure) throws org.maltparser.core.exception.MaltChainedException public virtual FeatureModel getFeatureModel(SpecificationModel specModel, FeatureRegistry registry, string dataSplitColumn, string dataSplitStructure) { return(new FeatureModel(specModel, registry, featureEngine, dataSplitColumn, dataSplitStructure)); }
public string SaveDressSpecEntry(SpecificationModel objDressSpecModel) { string strMsg = null; int count = objDressSpecModel.SizeId.Length; int x = objDressSpecModel.SizeId.Count(); for (int i = 0; i < x; i++) { var sizeId = objDressSpecModel.SizeId[i]; var description = objDressSpecModel.Description[i]; var sizeValue = objDressSpecModel.SizeValue[i]; var tranId = objDressSpecModel.TranId[i]; OracleCommand objOracleCommand = new OracleCommand("pro_dress_spec_save"); objOracleCommand.CommandType = CommandType.StoredProcedure; if (objDressSpecModel.StyleNo != "") { objOracleCommand.Parameters.Add("p_STYLE_NO", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = objDressSpecModel.StyleNo; } else { objOracleCommand.Parameters.Add("p_STYLE_NO", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (objDressSpecModel.StyleName != "") { objOracleCommand.Parameters.Add("p_STYLE_NAME", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = objDressSpecModel.StyleName; } else { objOracleCommand.Parameters.Add("p_STYLE_NAME", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (objDressSpecModel.SeasonId != "") { objOracleCommand.Parameters.Add("p_SEASON_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = objDressSpecModel.SeasonId; } else { objOracleCommand.Parameters.Add("p_SEASON_ID", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (objDressSpecModel.SeasonYear != "") { objOracleCommand.Parameters.Add("p_SEASON_YEAR", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = objDressSpecModel.SeasonYear; } else { objOracleCommand.Parameters.Add("p_SEASON_YEAR", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (objDressSpecModel.SpecificationDate.Length > 6) { objOracleCommand.Parameters.Add("p_SPECIFICATION_DATE", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = objDressSpecModel.SpecificationDate; } else { objOracleCommand.Parameters.Add("p_SPECIFICATION_DATE", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null; } if (sizeId != null) { objOracleCommand.Parameters.Add("p_SIZE_ID", OracleDbType.Varchar2, ParameterDirection.Input).Value = sizeId; } else { objOracleCommand.Parameters.Add("p_SIZE_ID", OracleDbType.Varchar2, ParameterDirection.Input).Value = null; } if (description != null) { objOracleCommand.Parameters.Add("p_SPEC_DESCRIPTION", OracleDbType.Varchar2, ParameterDirection.Input).Value = description; } else { objOracleCommand.Parameters.Add("p_SPEC_DESCRIPTION", OracleDbType.Varchar2, ParameterDirection.Input).Value = null; } if (sizeValue != null) { objOracleCommand.Parameters.Add("p_SIZE_VALUE", OracleDbType.Varchar2, ParameterDirection.Input).Value = sizeValue; } else { objOracleCommand.Parameters.Add("p_SIZE_VALUE", OracleDbType.Varchar2, ParameterDirection.Input).Value = null; } if (tranId.Length > 0) { objOracleCommand.Parameters.Add("p_TRAN_ID", OracleDbType.Varchar2, ParameterDirection.Input).Value = tranId; } else { objOracleCommand.Parameters.Add("p_TRAN_ID", OracleDbType.Varchar2, ParameterDirection.Input).Value = null; } objOracleCommand.Parameters.Add("p_update_by", OracleDbType.Varchar2, ParameterDirection.Input).Value = objDressSpecModel.UpdateBy; objOracleCommand.Parameters.Add("p_head_office_id", OracleDbType.Varchar2, ParameterDirection.Input).Value = objDressSpecModel.HeadOfficeId; objOracleCommand.Parameters.Add("p_branch_office_id", OracleDbType.Varchar2, ParameterDirection.Input).Value = objDressSpecModel.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) { trans.Rollback(); //trans.Dispose(); throw new Exception("Error : " + ex.Message); } finally { trans.Dispose(); strConn.Close(); } } } return(strMsg); }