public override void Delete(object Obj)
{
book_issue Book_issue = (book_issue)Obj;
dbEntities.book_issue.Remove(Book_issue);
dbEntities.SaveChanges();
}
private List <object> ListWithSql(string sql, int limit = 0, int offset = 0)
{
List <object> book_IssuesList = new List <object>();
var book_issues = dbEntities.book_issue
.SqlQuery(sql
).
Select(book_issue => book_issue);
if (limit > 0)
{
book_issues = book_issues.Skip(offset * limit).Take(limit).ToList();
}
else
{
book_issues = book_issues.ToList();
}
foreach (var bs in book_issues)
{
book_issue BookIssue = bs;
book_IssuesList.Add(BookIssue);
}
/* where b.author.name.Contains(val)
|| b.title.Contains(val) || b.review.Contains(val) || b.author.name.Contains(val)
||
|| b.category.category_name.Contains(val) || b.publisher.name.Contains(val)
|| select b;*/
return(book_IssuesList);
}
public override object Add(object Obj)
{
book_issue Book_issue = (book_issue)Obj;
if (Book_issue.id == null)
{
Book_issue.id = StringUtil.GenerateRandomChar(10);
}
if (Book_issue.qty == null || Book_issue.qty == 0)
{
Book_issue.qty = 1;
}
Book_issue.ref_issue = "not used";
try
{
Book_issue.book_issue2 = null;
Book_issue.issue = null;
Book_issue.book_issue1 = null;
Book_issue.book_record = null;
if (Book_issue.book_return == null)
{
Book_issue.book_return = 0;
}
book_issue newclass = dbEntities.book_issue.Add(Book_issue);
dbEntities.SaveChanges();
return(newclass);
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
// return null;
}
catch (System.Data.Entity.Infrastructure.DbUpdateException dbEx)
{
Exception raise = new Exception(dbEx.StackTrace);
throw raise;
// return null;
}
catch (System.Exception dbEx)
{
Exception raise = new Exception(dbEx.StackTrace);
throw raise;
// return null;
}
}
private string GetBookIssueList()
{
BookIssueService = new book_issueService();
List <object> book_issuesObj = BaseService.GetObjectList(BookIssueService, Request);
BookIssueCount = BookIssueService.ObjectCount();
if (book_issuesObj != null)
{
List <book_issue> book_issues = (List <book_issue>)ObjectUtil.ConvertList(book_issuesObj, typeof(List <book_issue>));
List <book_issue> book_issuesToSerialize = new List <book_issue>();
if (book_issues.Count > 0)
{
foreach (book_issue BookIssue in book_issues)
{
book_issue book_issue = (book_issue)ObjectUtil.GetObjectValues(new string[] {
"id", "book_record_id", "book_issue_id", "issue_id", "qty", "book_return"
}, BookIssue);
book_issuesToSerialize.Add(book_issue);
}
return(JsonConvert.SerializeObject(book_issuesToSerialize));
}
return("0");
}
return("0");
}
public override object Update(object Obj)
{
book_issue Book_issue = (book_issue)Obj;
dbEntities.Entry(Book_issue).CurrentValues.SetValues(Book_issue);
dbEntities.SaveChanges();
return(Book_issue);
}
private string GetBookStudentIssue()
{
if (StringUtil.NotNullAndNotBlank(Request.Form["rec_id"]) &&
StringUtil.NotNullAndNotBlank(Request.Form["student_id"]))
{
BookIssueService = new book_issueService();
bookRecordService = new Book_recordService();
studentService = new StudentService();
student Std = studentService.GetByIdFull(Request.Form["student_id"].ToString());
if (Std == null)
{
return("0");
}
List <object> BookIssuesOBJ = BookIssueService.SearchAdvanced(new Dictionary <string, object>()
{
{ "student_id", Request.Form["student_id"].ToString() },
{ "book_record_id", Request.Form["rec_id"].ToString() },
{ "book_return", "0" },
{ "issue_type", "issue" },
});
if (BookIssuesOBJ == null || BookIssuesOBJ.Count == 0)
{
return("0");
}
book_issue StudentBookIssue = (book_issue)BookIssuesOBJ.ElementAt(0);
if (StudentBookIssue == null)
{
return("0");
}
book_record BookRecord = (book_record)bookRecordService.GetById(Request.Form["rec_id"]);
if (BookRecord == null)
{
return("0");
}
book_record BookRecordToSend = (book_record)ObjectUtil.GetObjectValues(new string[] {
"id", "book_id", "available"
}, BookRecord);
if (BookRecord.book != null)
{
BookRecordToSend.book = (book)ObjectUtil.GetObjectValues(new string[] {
"id", "title"
}, BookRecord.book);
}
book_issue BookIssueToSend = (book_issue)ObjectUtil.GetObjectValues(new string[]
{
"id", "book_record_id", "book_return"
}, StudentBookIssue);
BookIssueToSend.book_record = BookRecordToSend;
return(JsonConvert.SerializeObject(BookIssueToSend));
}
return("0");
}
public static issue SubmitReturn(List <book_issue> BookIssues, string StudentId, AppUser AppUser)
{
string BookRecs = ObjectUtil.ListToDelimitedString(BookIssues, ";", "-", "book_record_id", "book_issue_id");
Dictionary <string, object> Params = MixParamWithUnP(
new Dictionary <string, object>()
{
{ "Action", "returnBook" },
{ "student_id", StudentId },
{ "book_recs", BookRecs }
},
AppUser);
Dictionary <string, object> RespParams = Request.PostReq(Transaction.URL, Params);
if (RespParams != null && RespParams["result"] != null && RespParams["result"].ToString() == "0")
{
Dictionary <string, object> DataMap = StringUtil.JSONStringToMap(RespParams["data"].ToString());
string IssueId = DataMap["issue_id"].ToString();
string Date = DataMap["date"].ToString();
if (DataMap["items"] == null || DataMap["items"].ToString().Equals(""))
{
return(null);
}
string[] BookIssuesString = DataMap["items"].ToString().Split(';');
List <book_issue> BookIssuesList = new List <book_issue>();
if (BookIssuesString.Length > 0)
{
foreach (string Item in BookIssuesString)
{
string[] Ids = Item.Split('~');
book_issue BS = new book_issue()
{
id = Ids[1],
book_record_id = Ids[0]
};
BookIssuesList.Add(BS);
}
}
Date = Date.Replace("PM", "");
Date = Date.Replace("AM", "");
issue Issue = new issue()
{
id = IssueId,
date = StringUtil.StringToDateTime(Date),
book_issue = BookIssuesList
};
return(Issue);
}
return(null);
}
private List <object> ListWithSql(string sql, int limit = 0, int offset = 0)
{
List <object> issueList = new List <object>();
var issues = dbEntities.issues
.SqlQuery(sql
).
Select(issue => new
{
issue,
book_issue = dbEntities.book_issue.Where(b => b.issue_id.Equals(issue.id)).Select(bi => new
{
bi,
book_record = dbEntities.book_record.Where(br => br.id.Equals(bi.book_record_id)).FirstOrDefault()
}).ToList(),
});
if (limit > 0)
{
issues = issues.Skip(offset * limit).Take(limit).ToList();
}
else
{
issues = issues.ToList();
}
/* where b.author.name.Contains(val)
|| b.title.Contains(val) || b.review.Contains(val) || b.author.name.Contains(val)
||
|| b.category.category_name.Contains(val) || b.publisher.name.Contains(val)
|| select b;*/
foreach (var i in issues)
{
issue Issue = new issue();
Issue = i.issue;
Issue.book_issue = new List <book_issue>();
foreach (var bi in i.book_issue)
{
book_issue BookIssue = new book_issue();
BookIssue = bi.bi;
BookIssue.book_record = bi.book_record;
Issue.book_issue.Add(BookIssue);
}
// Debug.WriteLine("title:"+Book.title+", cat:"+Book.category.category_name+", auth:"+Book.author.name);
issueList.Add(Issue);
}
return(issueList);
}
private void SearchBookRec(object sender, EventArgs e)
{
string RecId = InputRecId.Text.Trim();
book_issue BookIssue = UserClient.GetByStudentAndRecId(Student, RecId, appUser);
if (BookIssue != null && !IsExistInList(RecId, BookIssues))
{
BookIssue.book_issue_id = BookIssue.id;
BookIssue.id = null;
BookIssues.Add(BookIssue);
}
else
{
MessageBox.Show("Book Record Not Found");
}
UpdateForm();
}
private string GetIssuesList()
{
issueService = new IssueService();
List <object> Issues = BaseService.GetObjectList(issueService, Request);
IssueCount = issueService.ObjectCount();
if (Issues != null && Issues.Count > 0)
{
List <issue> IssuesToSerialize = new List <issue>();
foreach (issue Issue in Issues)
{
List <book_issue> BookIssues = new List <book_issue>();
foreach (book_issue BookIssue in Issue.book_issue)
{
book Book = (book)ObjectUtil.GetObjectValues(
new string[] { "id", "title", "page", "isbn", "img", "publisher_id", "author_id", "category_id", "review" }, BookIssue.book_record.book
);
book_record BRNew = (book_record)ObjectUtil.GetObjectValues(
new string[] { "id", "book_code", "available", "book_id" }, BookIssue.book_record);
book_issue BS = (book_issue)ObjectUtil.GetObjectValues(new string[]
{
"id", "book_record_id", "qty", "book_return", "book_issue_id",
}, BookIssue);
BRNew.book = Book;
BS.book_record = BRNew;
BookIssues.Add(BS);
}
issue IssueSerialize = (issue)ObjectUtil.GetObjectValues(new string[] {
"id", "date", "type", "additional_info", "student_id"
}, Issue);
IssueSerialize.book_issue = BookIssues;
IssuesToSerialize.Add(IssueSerialize);
}
return(JsonConvert.SerializeObject(IssuesToSerialize));
}
else
{
return("0");
}
}
private void SubmitIssue(object sender, EventArgs e)
{
var Confirm = MessageBox.Show("Are You Sure To Submit Return Transaction ??",
"Confirm Return!!",
MessageBoxButtons.YesNo);
if (Confirm == DialogResult.No)
{
return;
}
if (Student == null || BookIssues.Count == 0)
{
MessageBox.Show("Complete the field!");
return;
}
issue Issue = UserClient.SubmitReturn(BookIssues, Student.id, appUser);
if (Issue == null)
{
MessageBox.Show("Return Failed");
return;
}
BookIssues.ForEach(b =>
{
book_issue ExistInRecordedIssue = (GetByRecId(b.book_record_id, Issue.book_issue));
if (ExistInRecordedIssue != null)
{
b.id = ExistInRecordedIssue.id;
}
else
{
b.id = "FAILED";
}
});
MessageBox.Show("Return Success with ID: " + Issue.id);
UpdateForm();
}
protected void ButtonSave_Click(object sender, EventArgs e)
{
if (!IsStudentValid())
{
return;
}
book_issue BS = new book_issue();
BS.id = StringUtil.GenerateRandomChar(10);
BS.book_record_id = (TextBoxRecordId.Text.Trim());
if (!ExistBookRecord(BS.book_record_id, BookIssues))
{
book_record DBRecord = bookRecordService.FindByIdFull(BS.book_record_id);
if (null != DBRecord && DBRecord.available == (1))
{
BS.book_record = DBRecord;
BookIssues.Add(BS);
}
}
Session["BookIssues_" + CurrentStudent.id] = BookIssues;
PopulateBookIssues();
}
protected override Panel ShowDetailPanel(object Object)
{
issue Issue = (issue)Object;
Panel DetailPanel = new Panel();
Control[] DetailsCol = new Control[7 * (Issue.book_issue.Count + 1)];
//update
string[] ColumnLabels = { "No", "IssueId", "RecId", "Title", "", "Returned", Issue.type.Trim() + " item id" };
for (int i = 0; i < ColumnLabels.Length; i++)
{
DetailsCol[i] = new TitleLabel(11)
{
Text = ColumnLabels[i]
};
}
int ControlIndex = 7;
for (int i = 0; i < Issue.book_issue.Count; i++)
{
book_issue BS = Issue.book_issue[i];
if (Issue.type.Trim().Equals("issue"))
{
Dictionary <string, object> CheckReturnResponse = Transaction.FetchObj(0, 0, Transaction.URL, "checkReturnedBook", AppUser, new Dictionary <string, object>()
{
{ "book_issue_id", BS.id }
});
if (CheckReturnResponse["result"].ToString() == "0")
{
BS.book_issue_id = StringUtil.JSONStringToMap(CheckReturnResponse["data"].ToString())["book_issue_id"].ToString();
}
}
DetailsCol[ControlIndex++] = new Label()
{
Text = (i + 1).ToString()
};
DetailsCol[ControlIndex++] = new TextBoxReadonly()
{
Text = BS.id
};
DetailsCol[ControlIndex++] = new TextBoxReadonly()
{
Text = BS.book_record_id
};
DetailsCol[ControlIndex++] = new TextBoxReadonly()
{
Text = BS.book_record.book.title
};
DetailsCol[ControlIndex++] = new BlankControl()
{
Reserved = ReservedFor.BEFORE_HOR
};
string Type = Issue.type.ToLower().Trim();
if (Type == ("return"))
{
DetailsCol[ControlIndex++] = null;
}
else
{
DetailsCol[ControlIndex++] = new Label()
{
Text = BS.book_return == 1 ? "yes " + BS.ref_issue : "No"
};
}
DetailsCol[ControlIndex++] = new Label()
{
Text = BS.book_issue_id
};
}
//
DetailPanel = ControlUtil.GeneratePanel(7, DetailsCol, 5, 80, 20, Color.Orange, 5, 250);
student Student = UserClient.StudentById(Issue.student_id, AppUser);
Panel StudentDetail = ControlUtil.GeneratePanel(1, new Control[]
{
new Label()
{
Text = Issue.type.ToUpper().Trim() + " ID"
},
new TextBoxReadonly(13)
{
Text = Issue.id
},
new Label()
{
Text = "Date"
},
new TextBoxReadonly(13)
{
Text = Issue.date.ToString()
},
new Label()
{
Text = "Student ID"
},
new TextBoxReadonly(13)
{
Text = Student.id
},
new Label()
{
Text = "Student Name"
},
new TextBoxReadonly(13)
{
Text = Student.name
},
new Label()
{
Text = "Student ClassId"
},
new TextBoxReadonly(13)
{
Text = Student.class_id
},
}, 5, 200, 17, Color.Yellow, 5, 5, 500);
Panel Wrapper = new Panel();
Wrapper.Controls.Add(StudentDetail);
Wrapper.Controls.Add(DetailPanel);
Wrapper.SetBounds(5, 5, 500, 500);
Wrapper.AutoScroll = false;
Wrapper.VerticalScroll.Visible = true;
Wrapper.VerticalScroll.Enabled = true;
Wrapper.AutoScroll = true;
return(Wrapper);
}
protected void ButtonReturn_Click(object sender, EventArgs e)
{
try
{
book_issue BS = new book_issue();
BS.id = StringUtil.GenerateRandomChar(10);
//BS.book_issue_id = (TextBoxIssueRecordId.Text.Trim());
//add
student Student = (student)StudentService.GetById(TextBoxStudentID.Text);
if (Student == null)
{
return;
}
string Student_ID = Student.id;
string RecId = (TextBoxIssueRecordId.Text.Trim());
List <object> BookIssuesOBJ = BookIssueService.SearchAdvanced(new Dictionary <string, object>()
{
{ "student_id", Student_ID },
{ "book_record_id", RecId },
{ "issue_type", "issue" },
{ "book_return", "0" }
});
if (BookIssuesOBJ == null || BookIssuesOBJ.Count == 0)
{
return;
}
book_issue reffBookIssue = (book_issue)BookIssuesOBJ.ElementAt(0);
if (reffBookIssue.book_return != 0)
{
return;
}
BS.book_issue_id = reffBookIssue.id;
// book_issue reffBookIssue = (book_issue)BookIssueService.GetById(BS.book_issue_id);
if (!BookIssue.ExistBookRecord(BS.book_issue_id, BookIssuesReturn) && null != reffBookIssue)
{
//Check book_isue where book_rec_id = rec book_return != null || 0 and issue.student_id = std_id
string StudentId = TextBoxStudentID.Text;
if (BookIssueService.GetByBookIssueIdReturned(reffBookIssue.id).Count == 0)
{
book_record BookRecord = (book_record)bookRecordService.GetById(reffBookIssue.book_record_id);
//BS.book_issue2 = reffBookIssue;
BS.book_record_id = BookRecord.id;
book Book = (book)ObjectUtil.GetObjectValues(new string[]
{
"id", "title"
}, BookRecord.book);
book_record BookRec = (book_record)ObjectUtil.GetObjectValues(new string[]
{
"id", "book_id", "available"
}, BookRecord);
BookRec.book = Book;
BS.book_record = BookRec;
BookIssuesReturn.Add(BS);
}
}
}catch (HttpUnhandledException ex)
{
throw ex;
}
ButtonSearch_Click(sender, e);
ViewState["BookIssuesReturn"] = BookIssuesReturn;
PopulateBooksToReturn();
}
protected Panel StudentDetailPanel(student Student, string Type, int X, int Y, int W, int H)
{
List <book_issue> BookIssues = new List <book_issue>();
//fetch obj
Dictionary <string, object> FilterParams = new Dictionary <string, object>();
FilterParams.Add("student_id", Student.id);
FilterParams.Add("orderby", "book_issue.book_return");
FilterParams.Add("ordertype", "asc");
FilterParams.Add("issue_type", Type);
List <Dictionary <string, object> > ObjectMapList = Transaction.MapList(0, 0, Transaction.URL, "bookIssueList", AppUser, FilterParams);
//generate panel
Panel DetailPanel = new Panel();
int ListCount = ObjectMapList == null ? 0 : ObjectMapList.Count;
Control[] DetailsCol = new Control[8 * (ListCount + 2)];
//update
string[] ColumnLabels = { "No", "Id", "Trx Id", "RecId", /*"Title",*/ "", "Returned", "Book Issue Ref", "" };
//generate title
for (int i = 0; i < 8; i++)
{
if (i == 0)
{
DetailsCol[i] = new TitleLabel(13)
{
Text = ("============" + Type.ToUpper() + " LIST============")
};
}
else
{
DetailsCol[i] = new BlankControl()
{
Reserved = ReservedFor.BEFORE_HOR
};
}
}
//generate column name
for (int i = 8; i < ColumnLabels.Length + 8; i++)
{
if (ColumnLabels[i - 8] == "")
{
DetailsCol[i] = new BlankControl()
{
Reserved = ReservedFor.BEFORE_HOR
};
}
else
{
DetailsCol[i] = new Label()
{
Text = ColumnLabels[i - 8]
}
};
}
int ControlIndex = 16;
if (ObjectMapList == null)
{
goto End;
}
foreach (Dictionary <string, object> book_issueMap in ObjectMapList)
{
book_issue book_issue = (book_issue)ObjectUtil.FillObjectWithMap(new book_issue(), book_issueMap);
BookIssues.Add(book_issue);
}
for (int i = 0; i < BookIssues.Count; i++)
{
book_issue BS = BookIssues[i];
if (BS == null)
{
continue;
}
if (BS.id == null)
{
continue;
}
//if (type.Trim().Equals("issue"))
//{
// Dictionary<string, object> CheckReturnResponse = Transaction.FetchObj(0, 0, Transaction.URL, "checkReturnedBook", new Dictionary<string, object>()
// {
// {"book_issue_id",BS.id }
// });
// if (CheckReturnResponse["result"].ToString() == "0")
// {
// BS.book_issue_id = StringUtil.JSONStringToMap(CheckReturnResponse["data"].ToString())["book_issue_id"].ToString();
// }
//}
bool NotReturned = Type == "issue" && BS.book_return == 0;
DetailsCol[ControlIndex++] = new Label()
{
Text = (i + 1).ToString() + (NotReturned ? "*" : "")
};
DetailsCol[ControlIndex++] = new TextBoxReadonly()
{
Text = BS.id
};
DetailsCol[ControlIndex++] = new TextBoxReadonly()
{
Text = BS.issue_id
};
DetailsCol[ControlIndex++] = new TextBoxReadonly()
{
Text = BS.book_record_id
};
//DetailsCol[ControlIndex++] = new Label() { Text = BS.book_record.book.title };
DetailsCol[ControlIndex++] = new BlankControl()
{
Reserved = ReservedFor.BEFORE_HOR
};
//string Type = this.type.ToLower().Trim();
//if (Type == ("return"))
//{
// DetailsCol[ControlIndex++] = null;
//}
//else
//{
DetailsCol[ControlIndex++] = new TextBoxReadonly()
{
Text = BS.book_return.ToString()
};
//}
DetailsCol[ControlIndex++] = new TextBoxReadonly()
{
Text = BS.book_issue_id
};
DetailsCol[ControlIndex++] = new BlankControl()
{
Reserved = ReservedFor.BEFORE_HOR
};
}
//
End:
DetailPanel = ControlUtil.GeneratePanel(8, DetailsCol, 5, 70, 20, Color.Orange, X, Y, W, H);
return(DetailPanel);
}
private issue IssueBook()
{
if (StringUtil.NotNullAndNotBlank(Request.Form["student_id"]) &&
StringUtil.NotNullAndNotBlank(Request.Form["book_recs"]))
{
issueService = new IssueService();
studentService = new StudentService();
bookRecordService = new Book_recordService();
BookIssueService = new book_issueService();
string StudentId = Request.Form["student_id"];
student Student = (student)studentService.GetById(StudentId);
if (Student == null)
{
return(null);
}
string IssueID = StringUtil.GenerateRandomNumber(9);
issue Issue = new issue();
Issue.user_id = User.id;
Issue.id = IssueID;
Issue.type = "issue";
Issue.date = DateTime.Now;
Issue.student_id = Student.id;
Issue.addtional_info = "test";
string[] BookRecIds = Request.Form["book_recs"].Split(';');
if (BookRecIds.Length < 1)
{
return(null);
}
if (null == issueService.Add(Issue))
{
return(null);
}
List <book_issue> BookIssues = new List <book_issue>();
foreach (string Id in BookRecIds)
{
book_record BR = (book_record)bookRecordService.GetById(Id);
if (BR == null || BR.available == 0)
{
continue;
}
book_issue BookIssue = new book_issue();
BookIssue.id = StringUtil.GenerateRandomChar(10);
BookIssue.issue_id = IssueID;
BookIssue.book_record_id = Id;
BookIssue.qty = 1;
BookIssues.Add(BookIssue);
BookIssueService.Add(BookIssue);
BR.available = 0;
bookRecordService.Update(BR);
}
Issue.book_issue = BookIssues;
return(Issue);
}
return(null);
}
private void PopulateIssueList()
{
int No = 0;
PanelIssueLis.Controls.Clear();
int BookStillIssued = 0;
foreach (issue Issue in Issues)
{
if (null == Issue.book_issue || Issue.book_issue.Count == 0)
{
continue;
}
No++;
Panel PanelIssue = new Panel();
PanelIssue.Controls.Add(ControlUtil.GenerateLabel("<b>" + No + ". Issue ID: " + Issue.id + " (" + Issue.type + ")</b><br/>date: " + Issue.date + "<ol>"));
Panel PanelIssueItem = new Panel();
foreach (book_issue Bs in Issue.book_issue)
{
List <book_issue> BooksReturned = BookIssueService.GetByBookIssueIdReturned(Bs.id);
bool BookReturned = BooksReturned.Count == 1;
string labelHtml = "<li class=\"book_issue-item\" id=\"Book_Issue_Rec_" + Bs.id
+ "\"> Issue Rec Id: " + Bs.id + "<br/>Book Rec Id: "
+ Bs.book_record_id + "<br/>"
+ Bs.book_record.book.title + " - returned: <code>" + BookReturned + "</code>";// + DateTime.Now.ToString();
if (!BookReturned)
{
string[] Attrs = new string[]
{
"href=\"#\"",
"onclick=SetTextInput('" + Bs.book_record_id + "','MainContent_TextBoxIssueRecordId')"
};
string anchor = ControlUtil.GenerateHtmlTag("a", Attrs, " return now ");
labelHtml += "<br/>" + anchor;
BookStillIssued++;
}
else
{
string[] Attrs = new string[] {
"class=\"pointerable\"",
"onclick=\"ScrollToElement('Book_Return_Rec_" + BooksReturned[0].id + "')\""
};
string anchor = ControlUtil.GenerateHtmlTag("span", Attrs, BooksReturned[0].id);
labelHtml += "<br/> Return ref: " + anchor;
}
labelHtml += "</li>";
PanelIssueItem.Controls.Add(ControlUtil.GenerateLabel(labelHtml));
}
PanelIssue.Controls.Add(PanelIssueItem);
DateTime MaxReturn = DateUtil.PlusDay(Issue.date, int.Parse(TextBoxDuration.Text));
bool Late = false;
if (Issue.date.CompareTo(MaxReturn) > 0)
{
Late = true;
}
PanelIssue.Controls.Add(ControlUtil.GenerateLabel("</ol>Max return: " + MaxReturn + ", Late:" + Late + "<hr/>"));
PanelIssueLis.Controls.Add(PanelIssue);
}
issueCount.InnerHtml = BookStillIssued.ToString();
//BOOK RETURNED
No = 0;
PanelIssueReturn.Controls.Clear();
foreach (issue Issue in IssuesReturn)
{
if (null == Issue.book_issue || Issue.book_issue.Count == 0)
{
continue;
}
No++;
Panel PanelIssue = new Panel();
PanelIssue.Controls.Add(ControlUtil.GenerateLabel("<b>" + No + ". Issue ID: " + Issue.id + " (" + Issue.type + ")</b><br/>date: " + Issue.date + "<ol>"));
Panel PanelIssueItem = new Panel();
foreach (book_issue Bs in Issue.book_issue)
{
Bs.book_issue2 = (book_issue)BookIssueService.GetById(Bs.book_issue_id);
if (null != Bs.book_issue2)
{
book_issue BookIssueRef = Bs.book_issue2;
issue IssueRef = (issue)IssueService.GetById(BookIssueRef.issue_id);
DateTime IssuedDate = IssueRef.date;
DateTime MaxReturn = DateUtil.PlusDay(IssuedDate, int.Parse(TextBoxDuration.Text));
bool Late = false;
if (Issue.date.CompareTo(MaxReturn) > 0)
{
Late = true;
}
string[] Attrs = new string[] {
"class=\"pointerable\"",
"onclick=\"ScrollToElement('Book_Issue_Rec_" + Bs.book_issue_id + "')\""
};
string anchor = ControlUtil.GenerateHtmlTag("span", Attrs, Bs.book_issue_id);
PanelIssueItem.Controls.Add(ControlUtil.GenerateLabel("<li class=\"book_issue-item\" id=\"Book_Return_Rec_" + Bs.id
+ "\"> Return Rec Id: " + Bs.id + "<br/>Book Rec Id: "
+ Bs.book_record_id + " - Returned From Issue Rec Id: " + anchor +
"<br/>" + Bs.book_record.book.title
+ "<br/>Issued: " + IssuedDate + "<br/>Max return: " + MaxReturn + " - late: <code>" + Late
+ "</code></li>"));
}
}
PanelIssue.Controls.Add(PanelIssueItem);
PanelIssue.Controls.Add(ControlUtil.GenerateLabel("</ol><hr/>"));
PanelIssueReturn.Controls.Add(PanelIssue);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.RequestType == "POST")
{
CheckUser();
string Out = "\"" + GetTime() + "\"";
int Result = 1;
switch (Request.Form["Action"])
{
case "studentVisit":
Out = true || UserValid?GetStudentById() : "0";
if (Out != null && Out != "0")
{
string Visit = StudentVisit(Request.Form["Id"].ToString());
if (Visit != null && Visit != "0")
{
Out = "{" +
"\"student\":" + Out + ", \"visit\":" + Visit
+ "}";
Result = 0;
}
}
break;
case "addStudent":
Out = UserValid ? AddStudent() : "0";
if (Out != null && Out != "0")
{
Out = "{\"student\":" + Out + "}";
Result = 0;
}
break;
case "addAuthor":
Out = UserValid ? AddAuthor() : "0";
if (Out != null && Out != "0")
{
Out = "{\"author\":" + Out + "}";
Result = 0;
}
break;
case "addPublisher":
Out = UserValid ? AddPublisher() : "0";
if (Out != null && Out != "0")
{
Out = "{\"publisher\":" + Out + "}";
Result = 0;
}
break;
case "addClass":
Out = UserValid ? AddClass() : "0";
if (Out != null && Out != "0")
{
Out = "{\"class\":" + Out + "}";
Result = 0;
}
break;
case "addCategory":
Out = UserValid ? AddCategory() : "0";
if (Out != null && Out != "0")
{
Out = "{\"category\":" + Out + "}";
Result = 0;
}
break;
case "addBook":
Out = UserValid ? AddBook() : "0";
if (Out != null && Out != "0")
{
Out = "{\"book\":" + Out + "}";
Result = 0;
}
break;
case "studentById":
Out = UserValid ? GetStudentById() : "0";
if (Out != null && Out != "0")
{
Out = "{\"student\":" + Out + "}";
Result = 0;
}
break;
case "bookRecById":
Out = UserValid ? GetBookRecordById() : "0";
if (Out != null && Out != "0")
{
Out = "{\"book_record\":" + Out + "}";
Result = 0;
}
break;
case "bookList":
Out = UserValid ? GetBookList() : "0";
if (Out != null && Out != "0")
{
Out += (
",\"offset\":" + Request.Form["offset"]
+ ",\"count\":" + BookCount
+ ",\"limit\":" + Request.Form["limit"]
);
Result = 0;
}
break;
case "studentList":
Out = UserValid ? GetStudentList() : "0";
if (Out != null && Out != "0")
{
Out += (
",\"offset\":" + Request.Form["offset"]
+ ",\"count\":" + StudentCount
+ ",\"limit\":" + Request.Form["limit"]
);
Result = 0;
}
break;
case "issuesList":
Out = UserValid ? GetIssuesList() : "0";
if (Out != null && Out != "0")
{
Out += (
",\"offset\":" + Request.Form["offset"]
+ ",\"count\":" + IssueCount
+ ",\"limit\":" + Request.Form["limit"]
);
Result = 0;
}
break;
case "visitList":
Out = UserValid ? GetVisitsList() : "0";
if (Out != null && Out != "0")
{
Out += (
",\"offset\":" + Request.Form["offset"]
+ ",\"count\":" + VisitCount
+ ",\"limit\":" + Request.Form["limit"]
);
Result = 0;
}
break;
case "classList":
Out = UserValid ? GetClassList() : "0";
if (Out != null && Out != "0")
{
Out += (
",\"offset\":" + Request.Form["offset"]
+ ",\"count\":" + ClassCoount
+ ",\"limit\":" + Request.Form["limit"]
);
Result = 0;
}
break;
case "authorList":
Out = UserValid ? GetAuthorList() : "0";
if (Out != null && Out != "0")
{
Out += (
",\"offset\":" + Request.Form["offset"]
+ ",\"count\":" + AuthorCount
+ ",\"limit\":" + Request.Form["limit"]
);
Result = 0;
}
break;
case "publisherList":
Out = UserValid ? GetPublisherList() : "0";
if (Out != null && Out != "0")
{
Out += (
",\"offset\":" + Request.Form["offset"]
+ ",\"count\":" + PublisherCount
+ ",\"limit\":" + Request.Form["limit"]
);
Result = 0;
}
break;
case "categoryList":
Out = UserValid ? GetCategoryList() : "0";
if (Out != null && Out != "0")
{
Out += (
",\"offset\":" + Request.Form["offset"]
+ ",\"count\":" + CategoryCount
+ ",\"limit\":" + Request.Form["limit"]
);
Result = 0;
}
break;
case "bookIssueList":
Out = UserValid ? GetBookIssueList() : "0";
if (Out != null && Out != "0")
{
Out += (
",\"offset\":" + Request.Form["offset"]
+ ",\"count\":" + VisitCount
+ ",\"limit\":" + Request.Form["limit"]
);
Result = 0;
}
break;
case "checkReturnedBook":
book_issue ReturnBookIssue = UserValid ? GetBookIssue() : null;
if (ReturnBookIssue != null)
{
Out = (
"{\"book_issue_id\":\"" + ReturnBookIssue.id + "\"}"
);
Result = 0;
}
else
{
Result = 1;
}
break;
case "getBookIssueByStudentId":
string StudentBookIssue = UserValid ? GetBookStudentIssue() : null;
if (StudentBookIssue != null && StudentBookIssue != "0")
{
Out = (
"{\"book_issue\":" + StudentBookIssue + "}"
);
Result = 0;
}
else
{
Result = 1;
}
break;
case "issueBook":
issue Issue = UserValid ? IssueBook() : null;
if (Issue != null)
{
string RecIds = ObjectUtil.ListToDelimitedString(Issue.book_issue, ";", "~", "book_record_id", "id");
Out = (
"{\"issue_id\":\"" + Issue.id + "\",\"date\":\"" + Issue.date + "\", \"items\":\"" + RecIds + "\"}"
);
Result = 0;
}
else
{
Result = 1;
}
break;
case "returnBook":
issue IssueReturn = UserValid ? ReturnBook() : null;
if (IssueReturn != null)
{
string RecIds = ObjectUtil.ListToDelimitedString(IssueReturn.book_issue, ";", "~", "book_record_id", "id");
Out = (
"{\"issue_id\":\"" + IssueReturn.id + "\",\"date\":\"" + IssueReturn.date + "\", \"items\":\"" + RecIds + "\"}"
);
Result = 0;
}
else
{
Result = 1;
}
break;
}
Response.Clear();
Response.ContentType = "application/json; charset=utf-8";
Response.Write("{\"result\":" + Result + ",\"data\":" + Out + "}");
Response.End();
}
else
{
return;
}
}