//BUTTON CLICK
//fetching details of last inserted candidate details
int AppID=0;
var query = obj_KeralaPharmacyDL.GetApplication();
if (query.Count > 0)
{
AppID = Convert.ToInt32(query[0].pk_intApplicationID);
var obj_ApplicationCourse = new ApplicationCourseDetail
{
fk_intApplicationID = AppID,
vaBatchNo = txtBatchNo.Text
};
obj_KeralaPharmacyDL.insertApplicationCourse(obj_ApplicationCourse);
}
//DL
public List<Application> GetApplication()
{
using (var context = new KeralaPharmacyEntities ())
{
//context.Applications=>calling table instance
//OrderByDescending=>for top details we are orering descending mode
//c =>--Its a syntax for getting fields in that table
//c.pk_intApplicationID=->we are ordering by primary key iepk_intApplicationID
//Take(1).ToList()->taking top 1 to list
return context.Applications.OrderByDescending(c => c.pk_intApplicationID).Take(1).ToList();
}
}
No comments:
Post a Comment