protected void ButtonSignUp_Click(object sender, EventArgs e)
{
Member member = new Member();
User user = new User();
user.Name = TextBoxName.Text;
user.NickName = TextBoxNick.Text;
user.Mail = TextBoxMail.Text;
user.Address = TextBoxAddress.Text;
member.FacultyName = ddlFacultyName.SelectedItem.Text;
member.MemberType = ddlMemberType.SelectedItem.Text;
user.Gender = RadioButtonGender.Text;
user.Password = InputPassword.Value;
if (user.Password == InputConfirmPassword.Value)
{
UserDataProcess.InsertUser(user);
member.UserId = MemberDataProcess.getUserIdByNickName(user.NickName);
MemberDataProcess.InsertMember(member);
Response.Redirect("Default.aspx");
}
else
{
TextBoxAddress.Text = "";
InputPassword.Value = "";
TextBoxMail.Text = "";
TextBoxName.Text = "";
TextBoxNick.Text = "";
InputConfirmPassword.Value = "";
ddlFacultyName.SelectedIndex = -1;
ddlMemberType.SelectedIndex = -1;
}
}
protected void GridViewAdmin_RowCommand(object sender, GridViewCommandEventArgs e)
{
User user = (User)Session["AuthenticatedUserData"];
if (e.CommandName == "ExtendTime")
{
int rowIndex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex;
GridViewAdmin.EditIndex = rowIndex;
GridViewAdmin.DataSource = BorrowDataProcess.GetUserBorrows(user.UserId); //Görüldüğü gibi GridView’e DataSet nesnesi atanıyor.
GridViewAdmin.DataBind(); //this.DataBind() değil GridView’in DataBind()’i çağrıldı
}
else if (e.CommandName == "Extend")
{
int rowIndex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex;
String Returndate = ((DropDownList)GridViewAdmin.Rows[rowIndex].FindControl("ddlReturnTime")).SelectedValue;
String RecieveDate = ((Label)GridViewAdmin.Rows[rowIndex].FindControl("LabelRecieve")).Text;
String name = ((Label)GridViewAdmin.Rows[rowIndex].FindControl("LabelUserName")).Text;
String itemName = ((Label)GridViewAdmin.Rows[rowIndex].FindControl("LabelEditName")).Text;
int userId = BorrowDataProcess.getUserIdByNickName(name).UserId;
int itemId = ItemDataProcess.getItemIdByItemName(itemName);
Borrow borrow = new Borrow();
string oldDate = (e.CommandArgument).ToString().Substring(0, 10);
string[] tempDate = oldDate.Split('.');
int coeff = Convert.ToInt32(Returndate.Split(' ')[0]);
int day = Convert.ToInt32(tempDate[0]) + (coeff * 7);
int month = Convert.ToInt32(tempDate[1]);
int year = Convert.ToInt32(tempDate[2]);
if (day > 30)
{
day = day % 30;
month++;
}
if (month > 12)
{
month = month % 12;
year++;
}
Returndate = year.ToString() + month.ToString().PadLeft(2, '0') + day.ToString().PadLeft(2, '0');
borrow.ReturnDate = Returndate.ToString();
borrow.UserId = userId;
borrow.ItemId = itemId;
BorrowDataProcess.UpdateBorrow(borrow);
GridViewAdmin.EditIndex = -1;
GridViewAdmin.DataSource = BorrowDataProcess.GetUserBorrows(user.UserId); //Görüldüğü gibi GridView’e DataSet nesnesi atanıyor.
GridViewAdmin.DataBind(); //this.DataBind() değil GridView’in DataBind()’i çağrıldı
}
else if (e.CommandName == "ReturnItem")
{
int rowIndex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex;
String Returndate = ((Label)GridViewAdmin.Rows[rowIndex].FindControl("LabelReturn")).Text;
String name = ((Label)GridViewAdmin.Rows[rowIndex].FindControl("LabelUserName")).Text;
String itemName = ((Label)GridViewAdmin.Rows[rowIndex].FindControl("LabelName")).Text;
String RecieveDate = ((Label)GridViewAdmin.Rows[rowIndex].FindControl("LabelReceive")).Text;
int userId = BorrowDataProcess.getUserIdByNickName(name).UserId;
int itemId = ItemDataProcess.getItemIdByItemName(itemName);
int memberId = MemberDataProcess.getMemberByUserId(userId).MemberId;
//controlReturning(RecieveDate,Returndate);
string[] cRetDate = Returndate.Split('/');
string tempRet = cRetDate[2] + cRetDate[1] + cRetDate[0];
string[] cRecDate = RecieveDate.Split('/');
string tempRec = cRecDate[2] + cRecDate[1] + cRecDate[0];
Bill bill = new Bill();
string[] temp = DateTime.Now.ToShortDateString().Split('/');
bill.BillDate = temp[2] + temp[1] + temp[0];
bill.ItemID = itemId;
bill.MemberID = memberId;
bill.BillValue = calculateBillValue(tempRet).ToString();
BorrowDataProcess.InsertBill(bill);
Response.Redirect("HomeLibrary.aspx");
}
else if (e.CommandName == "CancelUpdate")
{
GridViewAdmin.EditIndex = -1;
GridViewAdmin.DataSource = BorrowDataProcess.GetUserBorrows(user.UserId); //Görüldüğü gibi GridView’e DataSet nesnesi atanıyor.
GridViewAdmin.DataBind(); //this.DataBind() değil GridView’in DataBind()’i çağrıldı
}
}
protected int convertUserIdToMemberId(int userId)
{
return(MemberDataProcess.getMemberByUserId(userId).MemberId);
}
private void GridViewDataBind()
{
GridViewAdmin.DataSource = MemberDataProcess.GetMembers(); //Görüldüğü gibi GridView’e DataSet nesnesi atanıyor.
GridViewAdmin.DataBind(); //this.DataBind() değil GridView’in DataBind()’i çağrıldı
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRow")
{
int rowIndex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex;
GridViewAdmin.EditIndex = rowIndex;
GridViewDataBind();
}
else if (e.CommandName == "DeleteRow")
{
int memberID = Convert.ToInt32(e.CommandArgument);
int userID = MemberDataProcess.getUserIdByMemberId(memberID);
MemberDataProcess.DeleteBillByMemberID(memberID);
BorrowDataProcess.DeleteBorrowByUserID(userID);//Önce kiralamaları varsa onları siliyoruz.
MemberDataProcess.DeleteMemberByID(Convert.ToInt32(e.CommandArgument));
GridViewDataBind();
}
else if (e.CommandName == "CancelUpdate")
{
GridViewAdmin.EditIndex = -1;
GridViewDataBind();
}
else if (e.CommandName == "UpdateRow")
{
int rowIndex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex;
Member member = new Member();
User user = new User();
member.MemberId = Convert.ToInt32(e.CommandArgument);
member.FacultyName = ((DropDownList)GridViewAdmin.Rows[rowIndex].FindControl("ddlFacultyName")).SelectedItem.Text;
member.MemberType = ((DropDownList)GridViewAdmin.Rows[rowIndex].FindControl("ddlMemberType")).SelectedItem.Text;
member.IsActive = true;
user.Name = ((TextBox)GridViewAdmin.Rows[rowIndex].FindControl("TextBoxMemberName")).Text;
user.Gender = ((DropDownList)GridViewAdmin.Rows[rowIndex].FindControl("ddlGender")).SelectedItem.Text;
user.Address = ((TextBox)GridViewAdmin.Rows[rowIndex].FindControl("TextBoxMemberAddress")).Text;
user.Password = ((TextBox)GridViewAdmin.Rows[rowIndex].FindControl("TextBoxMemberPassword")).Text;
user.NickName = ((TextBox)GridViewAdmin.Rows[rowIndex].FindControl("TextBoxMemberNickName")).Text;
user.IsOnline = false;
user.Mail = ((TextBox)GridViewAdmin.Rows[rowIndex].FindControl("TextBoxMemberMail")).Text;
GridViewAdmin.EditIndex = -1;
member.UserId = MemberDataProcess.getUserIdByMemberId(member.MemberId);
user.UserId = MemberDataProcess.getUserIdByMemberId(member.MemberId);
UserDataProcess.UpdateUsers(user);
MemberDataProcess.UpdateMembers(member);
GridViewDataBind();
}
else if (e.CommandName == "InsertRow")
{
Member member = new Member();
User user = new User();
member.FacultyName = ((DropDownList)GridViewAdmin.FooterRow.FindControl("ddlMemberInsertFacultyName")).SelectedItem.Text;
member.MemberType = ((DropDownList)GridViewAdmin.FooterRow.FindControl("ddlMemberInsertType")).SelectedItem.Text;
member.IsActive = true;
user.Name = ((TextBox)GridViewAdmin.FooterRow.FindControl("txtName")).Text;
user.Gender = ((DropDownList)GridViewAdmin.FooterRow.FindControl("ddlMemberInsertGender")).SelectedItem.Text;
user.Address = ((TextBox)GridViewAdmin.FooterRow.FindControl("txtAddress")).Text;
user.Password = ((TextBox)GridViewAdmin.FooterRow.FindControl("txtPassword")).Text;
user.NickName = ((TextBox)GridViewAdmin.FooterRow.FindControl("txtNickName")).Text;
user.IsOnline = false;
user.Mail = ((TextBox)GridViewAdmin.FooterRow.FindControl("txtMail")).Text;
UserDataProcess.InsertUser(user);
member.UserId = MemberDataProcess.getUserIdByNickName(user.NickName);
MemberDataProcess.InsertMember(member);
GridViewDataBind();
}
}