// PUT api/AdmissionInfo/5
public IHttpActionResult PutAdmissionInfo(int id, AdmissionInfo admissioninfo)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != admissioninfo.AdmId)
{
return(BadRequest());
}
db.Entry(admissioninfo).State = EntityState.Modified;
db.Entry(admissioninfo.StudentInfo).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!AdmissionInfoExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostAdmissionInfo(AdmissionInfo admissioninfo)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
//db.SaveChanges();
//admissioninfo.StdtId = admissioninfo.StudentInfo.StudentId;
db.StudentInfoes.Add(admissioninfo.StudentInfo);
db.AdmissionInfoes.Add(admissioninfo);
db.SaveChanges();
}
catch (DbUpdateException)
{
if (AdmissionInfoExists(admissioninfo.AdmId))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = admissioninfo.AdmId }, admissioninfo));
}
private void delAdmission_Click(object sender, RoutedEventArgs e)
{
AdmissionInfo admissionToDelete = GetSelectedAdmissionItemforDel();
if (admissionToDelete != null)
{
allAdmissionFormCollection.Remove(admissionToDelete);
SmsDb.DbInteraction.DeleteAdmission(admissionToDelete.id);
fetchAdmissionData();
}
}
public IHttpActionResult GetAdmissionInfo([FromUri] string id)
{
AdmissionInfo admissioninfo = db.AdmissionInfoes.Include(st => st.StudentInfo).Where(t => t.AdmissionNumber == id).FirstOrDefault();
if (admissioninfo == null)
{
return(NotFound());
}
return(Ok(admissioninfo));
}
public IHttpActionResult DeleteAdmissionInfo(int id)
{
AdmissionInfo admissioninfo = db.AdmissionInfoes.Find(id);
if (admissioninfo == null)
{
return(NotFound());
}
db.AdmissionInfoes.Remove(admissioninfo);
db.SaveChanges();
return(Ok(admissioninfo));
}
private AdmissionInfo GetSelectedAdmissionItemforDel()
{
AdmissionInfo admissionToDelete = null;
if (manageAdmissionView.SelectedIndex == -1)
{
MessageBox.Show("Please Select an Item");
}
else
{
AdmissionInfo i = (AdmissionInfo)manageAdmissionView.SelectedItem;
admissionToDelete = _allAdmissionFormCollection.Where(item => item.id.Equals(i.id)).First();
}
return(admissionToDelete);
}
public void Post(Student studentdto)
{
using (var context = new KPCollegeContext())
{
AdmissionInfo adInfo = new AdmissionInfo();
adInfo.Id = studentdto.StudentID;
adInfo.Name = studentdto.Name;
adInfo.Dob = studentdto.DOB;
adInfo.DateOfAdmission = studentdto.DateOfAdmission;
adInfo.Branch = studentdto.Branch;
adInfo.Address = studentdto.Address;
adInfo.Gender = studentdto.Gender;
adInfo.AdmissionFee = studentdto.MaintainanceFee;
adInfo.TutionFee = studentdto.TutionFee;
context.AdmissionInfo.Add(adInfo);
context.SaveChanges();
}
}
private static List <AdmissionInfo> QueryAllAdmissionListinDb()
{
List <AdmissionInfo> AdmissionList = new List <AdmissionInfo>();
MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection();
try
{ //define the command reference
MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
msqlCommand.Connection = msqlConnection;
msqlCommand.CommandText = "Select * From admission ;";
MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader();
while (msqlReader.Read())
{
AdmissionInfo Admission = new AdmissionInfo();
Admission.id = msqlReader.GetString("id");
Admission.name = msqlReader.GetString("name");
Admission.grdain = msqlReader.GetString("gurdian");
Admission.address = msqlReader.GetString("address");
Admission.phone = msqlReader.GetString("phone");
Admission.applyfor = msqlReader.GetString("applyfor");
Admission.qualification = msqlReader.GetString("qualification");
Admission.marksprcntg = msqlReader.GetString("marksprcntg");
Admission.formNo = msqlReader.GetString("formNo");
AdmissionList.Add(Admission);
}
}
catch (Exception er)
{
}
finally
{
//always close the connection
msqlConnection.Close();
}
return(AdmissionList);
}
public static int RegisterNewAdmissionForm(AdmissionInfo NewAdmissionForm)
{
int returnVal = 0;
MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection();
try
{
//define the command reference
MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
//define the connection used by the command object
msqlCommand.Connection = msqlConnection;
msqlCommand.CommandText = "INSERT INTO admission(id,name,gurdian,address,phone,applyfor,qualification,marksprcntg,formNo) " +
"VALUES(@id,@name,@gurdian,@address,@phone,@applyfor,@qualification,@marksprcntg,@formNo)";
msqlCommand.Parameters.AddWithValue("@id", NewAdmissionForm.id);
msqlCommand.Parameters.AddWithValue("@name", NewAdmissionForm.name);
msqlCommand.Parameters.AddWithValue("@gurdian", NewAdmissionForm.grdain);
msqlCommand.Parameters.AddWithValue("@address", NewAdmissionForm.address);
msqlCommand.Parameters.AddWithValue("@phone", NewAdmissionForm.phone);
msqlCommand.Parameters.AddWithValue("@applyfor", NewAdmissionForm.applyfor);
msqlCommand.Parameters.AddWithValue("@qualification", NewAdmissionForm.qualification);
msqlCommand.Parameters.AddWithValue("@marksprcntg", NewAdmissionForm.marksprcntg);
msqlCommand.Parameters.AddWithValue("@formNo", NewAdmissionForm.formNo);
msqlCommand.ExecuteNonQuery();
returnVal = 1;
}
catch (Exception er)
{
returnVal = 0;
}
finally
{
//always close the connection
msqlConnection.Close();
}
return(returnVal);
}
public static int RegisterNewAdmission(AdmissionInfo NewAdmissionForm)
{
return(RegisterNewAdmissionForm(NewAdmissionForm));
}
