public string Post(LU_SchemeName _LU_SchemeName, string transactionType) { string ret = string.Empty; try { Parameters[] colparameters = new Parameters[10] { new Parameters("@paramId", _LU_SchemeName.Id, DbType.Int32, ParameterDirection.Input), new Parameters("@paramName", _LU_SchemeName.Name, DbType.String, ParameterDirection.Input), new Parameters("@paramActivateFromDate", _LU_SchemeName.ActivateFromDate, DbType.Date, ParameterDirection.Input), new Parameters("@paramActivateToDate", _LU_SchemeName.ActivateToDate, DbType.Date, ParameterDirection.Input), new Parameters("@paramCreatorId", _LU_SchemeName.CreatorId, DbType.Int32, ParameterDirection.Input), new Parameters("@paramCreationDate", _LU_SchemeName.CreationDate, DbType.DateTime, ParameterDirection.Input), new Parameters("@paramModifierId", _LU_SchemeName.ModifierId, DbType.Int32, ParameterDirection.Input), new Parameters("@paramModificationDate", _LU_SchemeName.ModificationDate, DbType.DateTime, ParameterDirection.Input), new Parameters("@paramIsActive", _LU_SchemeName.IsActive, DbType.Boolean, ParameterDirection.Input), new Parameters("@paramTransactionType", transactionType, DbType.String, ParameterDirection.Input) }; dbExecutor.ManageTransaction(TransactionType.Open); ret = dbExecutor.ExecuteScalarString(true, CommandType.StoredProcedure, "wsp_LU_SchemeName_Post", colparameters, true); dbExecutor.ManageTransaction(TransactionType.Commit); } catch (DBConcurrencyException except) { dbExecutor.ManageTransaction(TransactionType.Rollback); throw except; } catch (Exception ex) { dbExecutor.ManageTransaction(TransactionType.Rollback); throw ex; } return(ret); }
public IHttpActionResult PutLU_SchemeName(int id, LU_SchemeName lU_SchemeName) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != lU_SchemeName.Id) { return(BadRequest()); } db.Entry(lU_SchemeName).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!LU_SchemeNameExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GetLU_SchemeName(int id) { LU_SchemeName lU_SchemeName = db.LU_SchemeName.Find(id); if (lU_SchemeName == null) { return(NotFound()); } return(Ok(lU_SchemeName)); }
public IHttpActionResult PostLU_SchemeName(LU_SchemeName lU_SchemeName) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.LU_SchemeName.Add(lU_SchemeName); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = lU_SchemeName.Id }, lU_SchemeName)); }
public IHttpActionResult DeleteLU_SchemeName(int id) { LU_SchemeName lU_SchemeName = db.LU_SchemeName.Find(id); if (lU_SchemeName == null) { return(NotFound()); } db.LU_SchemeName.Remove(lU_SchemeName); db.SaveChanges(); return(Ok(lU_SchemeName)); }