protected void LstOutcoming_DataBinding(object sender, EventArgs e)
{
OnlineSchoolEntities km = new OnlineSchoolEntities();
var schoolId = new SchoolInformation().getId();
var semesterId = MyDate.getCurrentSemesterId();
var Outcoming = (from I in km.Outcomings
join p in km.Schools on I.SchoolId equals p.Id
where I.SchoolId == schoolId && I.IsDeleted != true && I.SemesterId == semesterId
orderby I.Id descending
select new
{
I.Date,
I.Number,
I.FileNumber,
SourceTo = (from c in km.Constants where c.Id == I.SourceTo select c.value).FirstOrDefault(),
I.Subject,
Type = (from c in km.Constants where c.Id == I.Type select c.value).FirstOrDefault(),
Attachment = (from c in km.Constants where c.Id == I.Type select c.value).FirstOrDefault(),
I.Id,
}).ToList();
LstOutcoming.DataSource = Outcoming;
LstOutcoming.DataBind();
}
protected void LstOutcoming_DataBinding(object sender, EventArgs e)
{
OnlineSchoolEntities km = new OnlineSchoolEntities();
var schoolId = new SchoolInformation().getId();
int semesterId = MyDate.getCurrentSemesterId();
var Outcoming = (from O in km.Outcomings
where O.IsDeleted != true &&
O.ReceivedDate != null && O.SemesterId == semesterId &&
O.SchoolId == schoolId
select new
{
O.Number,
O.Date,
O.Type,
O.Attachment,
O.Subject,
O.SourceTo,
O.ReceivedName,
O.ReceivedDate,
O.Id,
}).ToList();
LstOutcoming.DataSource = Outcoming;
LstOutcoming.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LstOutcoming.DataBind();
}
}
protected void LstOutcoming_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (e.CommandName == "btnDelete")
{
int id = int.Parse(e.CommandArgument.ToString());
var c = (from k in km.Outcomings where k.Id == id select k).FirstOrDefault();
c.IsDeleted = true;
km.SaveChanges();
LstOutcoming.DataBind();
}
else if (e.CommandName == "btnEdit")
{
Response.Redirect("OutcomingAdd.aspx?id=" + e.CommandArgument);
}
else if (e.CommandName == "btnDetails")
{
Response.Redirect("OutcomingDetails.aspx?id=" + e.CommandArgument);
}
else if (e.CommandName == "receipt")
{
}
}
