protected void btnUpload_Click(object sender, EventArgs e)
{
try
{
// Before attempting to save the file, verify
// that the FileUpload control contains a file.
if (fuPhoto.HasFile)
{
// Call a helper method routine to save the file.
SaveFile(fuPhoto.PostedFile);
lblMessage.Text = "File uploaded";
}
else
{
savePath = Server.MapPath("Images");
string fileName = "CoverNull.png";
string pathToCheck = Path.Combine(savePath, fileName);
Book book = new Book();
book.PhotoName = pathToCheck;
User user = new User();
user = (User)Session["User"];
book.Title = txtTitle.Text;
book.Price = txtPrice.Text;
book.BookTypeID = new Guid(ddlGenre.SelectedValue);
user.Books.List.Add(book);
user.Save();
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
book = (Book)Session["Book"];
book.BookTypeID = new Guid(ddlGenre.SelectedValue);
book.Title = txtTitle.Text;
book.Price = txtPrice.Text;
if (fuPhoto.HasFile)
{
savePath = Server.MapPath("Images");
string fileName = fuPhoto.FileName;
string pathToCheck = Path.Combine(savePath, fileName);
book.PhotoName = pathToCheck;
}
else
{
savePath = Server.MapPath("Images");
book.PhotoName = Path.Combine(savePath, book.ID + book.MimeType);
}
User user = new User();
user = (User)Session["User"];
user.Books.List.Add(book);
user.Save();
}
public BookList GetAll()
{
_list.Clear();
Database db = new Database("Books");
db.Command.CommandType = System.Data.CommandType.StoredProcedure;
db.Command.CommandText = "tblBookGETALL";
DataTable dt = db.ExecuteQuery();
//dgvStudent.DataSource = dt;
foreach (DataRow dr in dt.Rows)
{
Book s = new Book();
s.Initialize(dr);
s.InitializeBusinessData(dr);
s.IsDirty = false;
s.IsNew = false;
s.evtIsSavable += new IsSavableHandler(s_evtIsSavable);
_list.Add(s);
}
return this;
}
public BookList GetByBookTypeID(Guid bookTypeID)
{
_list.Clear();
Database db = new Database("Books");
db.Command.CommandType = System.Data.CommandType.StoredProcedure;
db.Command.CommandText = "tblBookGETBYBOOKTYPEID";
db.Command.Parameters.Add("@BookTypeID", SqlDbType.UniqueIdentifier).Value = bookTypeID;
DataTable dt = db.ExecuteQuery();
//dgvStudent.DataSource = dt;
foreach (DataRow dr in dt.Rows)
{
Book s = new Book();
s.Initialize(dr);
s.InitializeBusinessData(dr);
s.IsDirty = false;
s.IsNew = false;
s.evtIsSavable += new IsSavableHandler(s_evtIsSavable);
_list.Add(s);
}
return this;
}
private Boolean Insert(Database db)
{
Book book = new Book();
try
{
db.Command.Parameters.Clear();
db.Command.CommandType = CommandType.StoredProcedure;
db.Command.CommandText = "tblBookINSERT";
base.Initialize(db.Command, Guid.Empty);
db.Command.Parameters.Add("@BookTypeID", SqlDbType.UniqueIdentifier).Value = _BookTypeID;
db.Command.Parameters.Add("@Title", SqlDbType.VarChar).Value = _Title;
db.Command.Parameters.Add("@Price", SqlDbType.VarChar).Value = _Price;
db.Command.Parameters.Add("@BookCover", SqlDbType.Image).Value = PhotoHelper.Photo.FileToByteArray(_PhotoName);
db.Command.Parameters.Add("@MimeType", SqlDbType.VarChar).Value = Path.GetExtension(_PhotoName);
db.ExecuteNonQueryWithTransaction();
base.Initialize(db.Command);
return true;
}
catch (Exception ex)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] == null)
{
Response.Redirect("default.aspx");
}
if (!Page.IsPostBack)
{
GetGenreData();
if (Request.QueryString["BookID"] != null)
{
book = new Book();
btnUpload.Visible = false;
btnSave.Visible = true;
book = book.GetByID(new Guid(Request.QueryString["BookID"]));
txtTitle.Text = book.Title;
txtPrice.Text = book.Price;
ddlGenre.SelectedValue = book.BookTypeID.ToString();
Session["Book"] = book;
}
else
{
btnSave.Visible = false;
}
}
}
void SaveFile(HttpPostedFile file)
{
// Specify the path to save the uploaded file to.
savePath = Server.MapPath("Images");
// Get the name of the file to upload.
string fileName = fuPhoto.FileName;
// Create the path and file name to check for duplicates.
string pathToCheck = Path.Combine(savePath, fileName);
// Create a temporary file name to use for checking duplicates.
string tempfileName = "";
// Check to see if a file already exists with the
// same name as the file to upload.
if (System.IO.File.Exists(pathToCheck))
{
int counter = 2;
while (System.IO.File.Exists(pathToCheck) == true)
{
// if a file with this name already exists,
// prefix the filename with a number.
tempfileName = counter.ToString() + fileName;
pathToCheck = Path.Combine(savePath, tempfileName);
counter++;
}
fileName = tempfileName;
// Notify the user that the file name was changed.
lblMessage.Text = "A file with the same name already exists." +
"<br />Your file was saved as " + fileName;
// Append the name of the file to upload to the path.
savePath = Path.Combine(savePath, fileName);
// Call the SaveAs method to save the uploaded
// file to the specified directory.
fuPhoto.SaveAs(savePath);
Book book = new Book();
book.PhotoName = savePath;
User user = new User();
user = (User)Session["User"];
book.Title = txtTitle.Text;
book.Price = txtPrice.Text;
book.BookTypeID = new Guid(ddlGenre.SelectedValue);
user.Books.List.Add(book);
user.Save();
}
else
{
// Append the name of the file to upload to the path.
savePath = Path.Combine(savePath, fileName);
// Call the SaveAs method to save the uploaded
// file to the specified directory.
fuPhoto.SaveAs(savePath);
////XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Book book = new Book();
book.PhotoName = savePath;
User user = new User();
user = (User)Session["User"];
book.Title = txtTitle.Text;
book.Price = txtPrice.Text;
book.BookTypeID = new Guid(ddlGenre.SelectedValue);
user.Books.List.Add(book);
user.Save();
// Notify the user that the file was saved successfully.
lblMessage.Text = "Your file was uploaded successfully.";
//Response.Redirect("UploadPhoto.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
book = book.GetByID(new Guid(Request.QueryString["BookID"]));
}
