/// <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
}
