/// <summary> /// Retrieves list of CompanyBranch objects from SqlCommand, after database query /// number of rows retrieved and returned depends upon the rows field value /// </summary> /// <param name="cmd">The command object to use for query</param> /// <param name="rows">Number of rows to process</param> /// <returns>A list of CompanyBranch objects</returns> private CompanyBranchList GetList(SqlCommand cmd, long rows) { // Select multiple records SqlDataReader reader; long result = SelectRecords(cmd, out reader); //CompanyBranch list CompanyBranchList list = new CompanyBranchList(); using ( reader ) { // Read rows until end of result or number of rows specified is reached while (reader.Read() && rows-- != 0) { CompanyBranch companyBranchObject = new CompanyBranch(); FillObject(companyBranchObject, reader); list.Add(companyBranchObject); } // Close the reader in order to receive output parameters // Output parameters are not available until reader is closed. reader.Close(); } return(list); }
/// <summary> /// populates a CompanyBranch with its child entities /// </summary> /// <param name="companyBranch"></param> /// <param name="fillChilds"></param> private void FillCompanyBranchWithChilds(CompanyBranch companyBranchObject, bool fillChilds) { // populate child data for a companyBranchObject if (companyBranchObject != null) { } }
public async Task <IActionResult> Edit(int id, [Bind("Id, CompanyId,Name,Description,AddressNation,AddressCity,AddressStreet,AddressState")] CompanyBranch companyBranch) { companyBranch.CompanyId = id; if (ModelState.IsValid) { try { _context.Update(companyBranch); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CompanyBranchExists(companyBranch.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index), new { id = companyBranch.Id })); } return(View(companyBranch)); }
/// <summary> /// Update CompanyBranch Object. /// Data manipulation processing for: new, deleted, updated CompanyBranch /// </summary> /// <param name="companyBranchObject"></param> /// <returns></returns> public bool Update(CompanyBranch companyBranchObject) { bool success = false; success = UpdateBase(companyBranchObject); return(success); }
public async Task <ActionResult> DeleteConfirmed(int id) { CompanyBranch companyBranch = await db.CompanyBranches.FirstOrDefaultAsync(x => x.branchId == id); companyBranch.active = false; await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Edit([Bind(Include = "branchId,branchName,entryBy,entryDate,active")] CompanyBranch companyBranch) { if (ModelState.IsValid) { db.Entry(companyBranch).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(companyBranch)); }
// POST: odata/CompanyBranches public IHttpActionResult Post(CompanyBranch companyBranch) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.CompanyBranches.Add(companyBranch); db.SaveChanges(); return(Created(companyBranch)); }
// DELETE: odata/CompanyBranches(5) public IHttpActionResult Delete([FromODataUri] int key) { CompanyBranch companyBranch = db.CompanyBranches.Find(key); if (companyBranch == null) { return(NotFound()); } db.CompanyBranches.Remove(companyBranch); db.SaveChanges(); return(StatusCode(HttpStatusCode.NoContent)); }
// GET: CompanyBranches/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CompanyBranch companyBranch = await db.CompanyBranches.FindAsync(id); if (companyBranch == null) { return(HttpNotFound()); } return(View(companyBranch)); }
public int?Create(CreateCompanyBranchViewModel companyBranch) { var objCompanyBranch = new CompanyBranch(companyBranch.Name, companyBranch.IdCompany, companyBranch.MaxkilometersDelivery, new Address(companyBranch.City, companyBranch.Address, companyBranch.FullNumber, companyBranch.Latitude, companyBranch.Longitude)); _companyBranchRepository.Create(objCompanyBranch); if (!IsError() && _companyBranchRepository.ExistCompanyNameDapper(objCompanyBranch.Name)) { AddError("Company branch already exists"); } if (Commit()) { return(objCompanyBranch.IdCompany); } return(null); }
public async Task <ActionResult> Create([Bind(Include = "branchName")] CompanyBranch companyBranch) { if (ModelState.IsValid) { companyBranch.entryBy = 1; companyBranch.entryDate = DateTime.Now; companyBranch.active = true; db.CompanyBranches.Add(companyBranch); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(companyBranch)); }
// POST api/CompanyBranch public HttpResponseMessage PostCompanyBranch(CompanyBranch companybranch) { if (ModelState.IsValid) { companybranch.InsertBy = loginUser.UserID; db.CompanyBranches.Add(companybranch); db.SaveChanges(); HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, companybranch); response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = companybranch.CompanyBranchID })); return response; } else { return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState); } }
public async static Task <IDTO> AddUpdateMode(CompanyBranch companyBranch) { string SPName = ""; string message = ""; OracleDynamicParameters dyParam = new OracleDynamicParameters(); ComplateOperation <int> complate = new ComplateOperation <int>(); if (companyBranch.ID.HasValue) { dyParam.Add(CompanyBranchSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)companyBranch.ID ?? DBNull.Value); SPName = CompanyBranchSPName.SP_UPADTE_COMPANY_BRANCH; message = "Updated Successfully"; } else { dyParam.Add(CompanyBranchSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output); SPName = CompanyBranchSPName.SP_INSERT_COMPANY_BRANCH; message = "Inserted Successfully"; } dyParam.Add(CompanyBranchSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)companyBranch.Name ?? DBNull.Value, 1000); dyParam.Add(CompanyBranchSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)companyBranch.Name2 ?? DBNull.Value, 1000); dyParam.Add(CompanyBranchSpParams.PARAMETER_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)companyBranch.Code ?? DBNull.Value, 30); dyParam.Add(CompanyBranchSpParams.PARAMETER_PHONE, OracleDbType.Varchar2, ParameterDirection.Input, (object)companyBranch.Phone ?? DBNull.Value, 30); dyParam.Add(CompanyBranchSpParams.PARAMETER_FAX, OracleDbType.Varchar2, ParameterDirection.Input, (object)companyBranch.Fax ?? DBNull.Value, 30); dyParam.Add(CompanyBranchSpParams.PARAMETER_EMAIL, OracleDbType.Varchar2, ParameterDirection.Input, (object)companyBranch.Email ?? DBNull.Value, 30); dyParam.Add(CompanyBranchSpParams.PARAMETER_ADDRESS, OracleDbType.Varchar2, ParameterDirection.Input, (object)companyBranch.Address ?? DBNull.Value, 30); dyParam.Add(CompanyBranchSpParams.PARAMETER_ADDRESS2, OracleDbType.Varchar2, ParameterDirection.Input, (object)companyBranch.Address2 ?? DBNull.Value, 30); dyParam.Add(CompanyBranchSpParams.PARAMETER_COMPANY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)companyBranch.CompanyID ?? DBNull.Value); dyParam.Add(CompanyBranchSpParams.PARAMETER_CITY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)companyBranch.CityID ?? DBNull.Value); dyParam.Add(CompanyBranchSpParams.PARAMETER_COUNTRY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)companyBranch.CountryID ?? DBNull.Value); dyParam.Add(CompanyBranchSpParams.PARAMETER_COUNTRY_CURRENCY_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)companyBranch.CurrencyCode ?? DBNull.Value, 30); if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, dyParam) == -1) { complate.message = message; } else { complate.message = "Operation Failed"; } return(complate); }
public async Task <IActionResult> Create([Bind("CompanyId,Name,Description,AddressNation,AddressCity,AddressStreet,AddressState")] CompanyBranch companyBranch) { if (ModelState.IsValid) { _context.Add(companyBranch); await _context.SaveChangesAsync(); // TODO fix redirect // return RedirectToAction(nameof(Index), new { companyBranch.CompanyId }); return(RedirectToRoute(new { controller = "CompanyBranches", action = "Index", id = companyBranch.CompanyId })); } return(View(companyBranch)); }
public IActionResult Create(int?id) { if (id == null) { return(NotFound()); } var companyBranch = new CompanyBranch(); companyBranch.Company = _context.CompaniesDB .FirstOrDefault(m => m.Id == id); if (companyBranch.Company.Id != id) { return(NotFound()); } return(View(companyBranch)); }
/// <summary> /// Retrieves CompanyBranch object from SqlCommand, after database query /// </summary> /// <param name="cmd">The command object to use for query</param> /// <returns>CompanyBranch object</returns> private CompanyBranch GetObject(SqlCommand cmd) { SqlDataReader reader; long rows = SelectRecords(cmd, out reader); using (reader) { if (reader.Read()) { CompanyBranch companyBranchObject = new CompanyBranch(); FillObject(companyBranchObject, reader); return(companyBranchObject); } else { return(null); } } }
/// <summary> /// Insert new companyBranch. /// data manipulation for insertion of CompanyBranch /// </summary> /// <param name="companyBranchObject"></param> /// <returns></returns> private bool Insert(CompanyBranch companyBranchObject) { // new companyBranch using (CompanyBranchDataAccess data = new CompanyBranchDataAccess(ClientContext)) { // insert to companyBranchObject Int32 _Id = data.Insert(companyBranchObject); // if successful, process if (_Id > 0) { companyBranchObject.Id = _Id; return(true); } else { return(false); } } }
/// <summary> /// Update base of CompanyBranch Object. /// Data manipulation processing for: new, deleted, updated CompanyBranch /// </summary> /// <param name="companyBranchObject"></param> /// <returns></returns> public bool UpdateBase(CompanyBranch companyBranchObject) { // use of switch for different types of DML switch (companyBranchObject.RowState) { // insert new rows case BaseBusinessEntity.RowStateEnum.NewRow: return(Insert(companyBranchObject)); // delete rows case BaseBusinessEntity.RowStateEnum.DeletedRow: return(Delete(companyBranchObject.Id)); } // update rows using (CompanyBranchDataAccess data = new CompanyBranchDataAccess(ClientContext)) { return(data.Update(companyBranchObject) > 0); } }
/// <summary> /// /// </summary> /// <param name="requestDto"></param> /// <returns></returns> /* public async Task<int> AddBranch(BranchDto requestDto) * { * try * { * var branch = new Branch * { * Name = requestDto.Name, * Address = requestDto.Address, * Email = requestDto.Email, * Phone = requestDto.Phone, * Location=requestDto.Location, * CreatedOn = DateTime.Now, * CompanyBranch = new List<CompanyBranch> * * { * new CompanyBranch * { * FkCompanyId = requestDto.CompanyId, * * * } * * } * * }; * _context.Branch.Add(branch); * _context.SaveChanges(); * return await Task.FromResult(branch.PkBranchId); * * } * catch (Exception e) * { * Console.WriteLine(e); * throw; * } * } */ public async Task <int> AddBranch(BranchDto requestDto) { try { var branch = new Branch { Name = requestDto.Name, Address = requestDto.Address, Email = requestDto.Email, Phone = requestDto.Phone, Location = requestDto.Location, CreatedOn = DateTime.Now, }; _context.Branch.Add(branch); _context.SaveChanges(); var CompanyBranch = new CompanyBranch { FkCompanyId = requestDto.CompanyId, FkBranchId = branch.PkBranchId, }; _context.CompanyBranch.Add(CompanyBranch); return(await Task.FromResult(_context.SaveChanges())); } catch (Exception e) { Console.WriteLine(e); throw; } }
public IHttpActionResult Patch([FromODataUri] int key, Delta <CompanyBranch> patch) { Validate(patch.GetEntity()); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } CompanyBranch companyBranch = db.CompanyBranches.Find(key); if (companyBranch == null) { return(NotFound()); } patch.Patch(companyBranch); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CompanyBranchExists(key)) { return(NotFound()); } else { throw; } } return(Updated(companyBranch)); }
public ActionResult CreateCompanyBranch(CompanyBranch companyBranch) { var message = _iCompanyBranchService.InsertOrUpdateWithoutIdentity(companyBranch); return(Json(message, JsonRequestBehavior.AllowGet)); }
// PUT api/CompanyBranch/5 public HttpResponseMessage PutCompanyBranch(long id, CompanyBranch companybranch) { companybranch.Company =null; companybranch.CompanyBranchType = null; companybranch.CompanyBranchCategory = null; companybranch.Country= null; companybranch.City = null; companybranch.Language =null; companybranch.Currency = null; if (!ModelState.IsValid) { return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState); } if (id != companybranch.CompanyBranchID) { return Request.CreateResponse(HttpStatusCode.BadRequest); } companybranch.UpdateBy = loginUser.UserID; db.Entry(companybranch).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex); } return Request.CreateResponse(HttpStatusCode.OK); }
public Employee(string name, CompanyBranch companyBranch) { Name = name; CompanyBranch = companyBranch; Validate(); }
/// <summary> /// Fill External Childs of CompanyBranch Object. /// </summary> /// <param name="companyBranchObject"></param> /// <returns></returns> public void FillChilds(CompanyBranch companyBranchObject) { ///Fill external information of Childs of CompanyBranchObject }