public IHttpActionResult PuttblStatu(int id, tblStatu tblStatu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblStatu.Id)
{
return(BadRequest());
}
db.Entry(tblStatu).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tblStatuExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Edit(int id)
{
tblMember tblmember;
using (Service1Client wcf = new Service1Client())
{
tblmember = wcf.GetOneMember(id);
List <tblPrivilage> listP = new List <tblPrivilage>();
var priv = wcf.GetPrivilageList();
tblPrivilage pri = wcf.GetOnePrivilage(tblmember.PrivilageID);
listP.Add(pri); //dodaje za pocetnu vrednost korisnikovu trenutnu privilegiju
if (pri != null) //ukoliko trenutna nije null dodaje i opciju null
{
listP.Add(null);
}
foreach (tblPrivilage p in priv)
{
if (pri != null)
{
if (p.PrivilageID != pri.PrivilageID) //dodaje sve ostale
{
listP.Add(p);
}
}
else
{
listP.Add(p);
}
}
ViewBag.PrivilageID = new SelectList(listP, "PrivilageID", "TypeOfPrivilage");
tblStatu statusNow = wcf.GetOneStatus(tblmember.StatusID);
List <tblStatu> statuss = new List <tblStatu>();
statuss.Add(statusNow);
var allStatus = wcf.GetStatusList();
foreach (tblStatu s in allStatus)
{
if (statusNow != null)
{
if (s.StatusID != statusNow.StatusID)
{
statuss.Add(s);
}
}
else
{
statuss.Add(s);
}
}
ViewBag.StatusID = new SelectList(statuss, "StatusID", "StatusType");
}
if (tblmember == null)
{
return(HttpNotFound());
}
return(View(tblmember));
}
public IHttpActionResult GettblStatu(int id)
{
tblStatu tblStatu = db.tblStatus.Find(id);
if (tblStatu == null)
{
return(NotFound());
}
return(Ok(tblStatu));
}
public IHttpActionResult PosttblStatu(tblStatu tblStatu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tblStatus.Add(tblStatu);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = tblStatu.Id }, tblStatu));
}
public IHttpActionResult DeletetblStatu(int id)
{
tblStatu tblStatu = db.tblStatus.Find(id);
if (tblStatu == null)
{
return(NotFound());
}
db.tblStatus.Remove(tblStatu);
db.SaveChanges();
return(Ok(tblStatu));
}
private void LoadGrid()
{
var statu = db.tblStatus.ToList();
tblStatu tbl = new tblStatu();
tbl.StatusDescription = "Choose Status";
statu.Insert(0, tbl);
cboStatusId.DataSource = statu;
cboStatusId.DisplayMember = "StatusDescription";
cboStatusId.ValueMember = "StatusId";
cboStatusId.SelectedIndex = 0;
//Select query to display column in datagrid view
dataGridView1.DataSource = db.tblAssignmentSubmissions.Select(x => new { AssignmentSubmissionId = x.AssignmentSubmissionId, AssignmentId = x.tblAssignment.tblSubject.SubjectName, Status = x.tblStatu.StatusDescription, SubmittedDate = x.SubmittedDate, IsOnTime = x.IsOnTime }).ToList();
}