public IHttpActionResult PutServiceBranch(int id, ServiceBranch serviceBranch)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != serviceBranch.BranchId)
{
return(BadRequest());
}
db.Entry(serviceBranch).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ServiceBranchExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetServiceBranch(int id)
{
ServiceBranch serviceBranch = db.ServiceBranches.Find(id);
if (serviceBranch == null)
{
return(NotFound());
}
return(Ok(serviceBranch));
}
public IHttpActionResult PostServiceBranch(ServiceBranch serviceBranch)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.ServiceBranches.Add(serviceBranch);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = serviceBranch.BranchId }, serviceBranch));
}
public IHttpActionResult DeleteServiceBranch(int id)
{
ServiceBranch serviceBranch = db.ServiceBranches.Find(id);
if (serviceBranch == null)
{
return(NotFound());
}
db.ServiceBranches.Remove(serviceBranch);
db.SaveChanges();
return(Ok(serviceBranch));
}
private static ServiceBranch MapServiceBranch(IDataReader reader)
{
ServiceBranch branch = new ServiceBranch();
int ord = 0;
branch.Id = reader.GetInt32(ord++);
branch.Code = reader.GetString(ord++);
branch.Name = reader.GetString(ord++);
branch.Inactive = reader.GetBoolean(ord++);
branch.DisplayOrder = reader.GetInt32(ord++);
branch.DateCreated = reader.GetDateTime(ord++);
branch.DateModified = reader.GetDateTime(ord++);
branch.UserIdCreated = reader.GetString(ord++);
return(branch);
}
public ServiceBranch SelectById(int id)
{
ServiceBranch branch = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.ServiceBranch_SelectById",
inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
}
, map : delegate(IDataReader reader, short set)
{
branch = MapServiceBranch(reader);
}
);
return(branch);
}
public List <ServiceBranch> SelectAll()
{
List <ServiceBranch> branchlist = new List <ServiceBranch>();
DataProvider.ExecuteCmd(GetConnection, "dbo.ServiceBranch_SelectAll",
inputParamMapper : null
, map : delegate(IDataReader reader, short set)
{
ServiceBranch branch = MapServiceBranch(reader);
branchlist.Add(branch);
}
);
return(branchlist);
}
