public IHttpActionResult PutLU_User(int id, LU_User LU_User) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != LU_User.Id) { return(BadRequest()); } db.Entry(LU_User).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!LU_UserExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PostLU_User(LU_User LU_User) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.LU_User.Add(LU_User); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = LU_User.Id }, LU_User)); }
public IHttpActionResult DeleteLU_User(int id) { LU_User LU_User = db.LU_User.Find(id); if (LU_User == null) { return(NotFound()); } db.LU_User.Remove(LU_User); db.SaveChanges(); return(Ok(LU_User)); }
public string Post(LU_User obj, string transactionType) { string ret = string.Empty; try { obj.CreatorId = 1; obj.ModifierId = 1; obj.CreationDate = DateTime.Now; obj.ModificationDate = DateTime.Now; ret = Facade.LU_UserDAO.Post(obj, transactionType); return(ret); } catch (Exception ex) { return(ex.Message); } }
public string Post(LU_User _LU_User, string transactionType) { string ret = string.Empty; try { Parameters[] colparameters = new Parameters[12] { new Parameters("@paramId", _LU_User.Id, DbType.Int32, ParameterDirection.Input), new Parameters("@paramUserGroupId", _LU_User.UserGroupId, DbType.Int32, ParameterDirection.Input), new Parameters("@paramName", _LU_User.Name, DbType.String, ParameterDirection.Input), new Parameters("@paramEmail", _LU_User.Email, DbType.String, ParameterDirection.Input), new Parameters("@paramMobileNo", _LU_User.MobileNo, DbType.String, ParameterDirection.Input), new Parameters("@paramPassword", _LU_User.Password, DbType.String, ParameterDirection.Input), new Parameters("@paramCreatorId", _LU_User.CreatorId, DbType.Int32, ParameterDirection.Input), new Parameters("@paramCreationDate", _LU_User.CreationDate, DbType.DateTime, ParameterDirection.Input), new Parameters("@paramModifierId", _LU_User.ModifierId, DbType.Int32, ParameterDirection.Input), new Parameters("@paramModificationDate", _LU_User.ModificationDate, DbType.DateTime, ParameterDirection.Input), new Parameters("@paramIsActive", _LU_User.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_User_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); }