/// <summary>
/// Event That Fires on Submit Click Which Downloads The File
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (ValidateCard())
{
Document_Details DocumentObj = (Document_Details)Session["DocumentObj"];
// var name = DocumentObj.DocumentPath;
Response.ContentType = "application/pdf";
Response.AppendHeader("Content-Disposition", "attachment; filename=" + DocumentObj.DocumentName + ".pdf");
Response.TransmitFile(Server.MapPath("~/Documents/" + DocumentObj.DocumentName + ".pdf"));
// Response.TransmitFile(Server.MapPath("~/Documents/" + DocumentObj.DocumentPath + ".pdf"));
Response.End();
}
else
{
Response.Write("<script>alert('Sorry! InValid Credit Card details.')</script>");
}
}
catch (ELibException ex)
{
Response.Write("<script>alert(" + ex.Message + ")</script>");
}
catch (Exception ex)
{
Response.Write("<script>alert(" + ex.Message + ")</script>");
}
}
public bool freebie(Document_Details document)
{
{
var dialog = new SaveFileDialog();
dialog.Filter = "PDF Files|*.pdf";
dialog.AddExtension = true;
if (dialog.ShowDialog().GetValueOrDefault() == true)
{
using (var fs = new System.IO.FileStream(document.DocumentPath, System.IO.FileMode.Open, System.IO.FileAccess.Read))
{
using (var sr = new System.IO.BinaryReader(fs))
{
var fs1 = new System.IO.FileStream(dialog.FileName, System.IO.FileMode.Create, System.IO.FileAccess.Write);
var sw = new System.IO.BinaryWriter(fs1);
sw.Write(sr.ReadBytes((int)fs.Length - 1));
sw.Close();
fs1.Close();
sr.Close();
fs.Close();
return(true);
}
}
}
else
{
return(false);
}
}
}
public Download(Document_Details Obj, decimal discount)
{
InitializeComponent();
DetailsObj = Obj;
lbldocnameval.Content = DetailsObj.DocumentName;
lbldocpriceval.Content = "Rs. " + ((double)DetailsObj.Price) + "/- INR";
lbltotalpriceval.Content = "Rs " + (Convert.ToDouble(DetailsObj.Price - (discount * DetailsObj.Price))) + "/- INR";
}
public List <Document_Details> BrowseDocuments(int disciplineIdSelected, int offsetPageNumber)
{
List <Document_Details> DisciplineDetailsListObj = null;
var ConnectionObj = DatabaseConnection.CreateConnection();
var CommandObj = DatabaseConnection.CreateCommand(ConnectionObj, "ELIB_Management_System.uspBrowse_Document_Details", CommandType.StoredProcedure);
var P1 = DatabaseConnection.CreateParameter(CommandObj, "@Discipline_Id", DbType.Int32);
P1.Value = disciplineIdSelected;
CommandObj.Parameters.Add(P1);
var P2 = DatabaseConnection.CreateParameter(CommandObj, "@OffsetPageNumber", DbType.Int32);
P2.Value = offsetPageNumber;
CommandObj.Parameters.Add(P2);
try
{
DataTable TableObj = DatabaseConnection.ExecuteReader(CommandObj);
if (TableObj != null && TableObj.Rows.Count > 0)
{
DisciplineDetailsListObj = new List <Document_Details>();
foreach (DataRow row in TableObj.Rows)
{
var DocumentDetailsObj = new Document_Details();
DocumentDetailsObj.DocumentId = (int)row[0];
DocumentDetailsObj.DocumentName = (string)row[1];
DocumentDetailsObj.DocumentDescription = (string)row[2];
DocumentDetailsObj.DocumentPath = (string)row[3];
DocumentDetailsObj.DocumentTypeId.DocumentTypeId = (int)row[4];
DocumentDetailsObj.DisciplineId.DisciplineId = (int)row[5];
DocumentDetailsObj.Title = (string)row[6];
DocumentDetailsObj.Author = (string)row[7];
DocumentDetailsObj.UploadDate = (DateTime)row[8];
DocumentDetailsObj.Price = (decimal)row[9];
DisciplineDetailsListObj.Add(DocumentDetailsObj);
}
}
}
catch (DbException ex)
{
throw new ELibException("There is an Error while fetching the document details from the database. Try again after some time", ex);
}
catch (Exception ex)
{
throw new ELibException("Unknown error", ex);
}
return(DisciplineDetailsListObj);
}
private bool ValidateDocuments(Document_Details obj)
{
var IsValid = true;
var ErrorMessage = new StringBuilder();
if (string.IsNullOrEmpty(obj.DocumentName))
{
IsValid = false;
ErrorMessage.AppendLine("Document Name Should Not be Epmty!");
}
if (string.IsNullOrEmpty(obj.DocumentDescription))
{
IsValid = false;
ErrorMessage.AppendLine("Document Description Should Not be Epmty!");
}
if (obj.DocumentTypeId.DocumentTypeId != 1 && obj.DocumentTypeId.DocumentTypeId != 2)
{
IsValid = false;
ErrorMessage.AppendLine("Document Type Name Should be Selected From DropDown List!");
}
if (obj.DisciplineId.DisciplineId <= 0)
{
IsValid = false;
ErrorMessage.AppendLine("Discipline Name Should be Selected From DropDown List!");
}
if (string.IsNullOrEmpty(obj.Title))
{
IsValid = false;
ErrorMessage.AppendLine("Document Description Should Not be Epmty!");
}
if (string.IsNullOrEmpty(obj.Author))
{
IsValid = false;
ErrorMessage.AppendLine("Author Should Not be Epmty!");
}
if (obj.Price < 0)
{
IsValid = false;
ErrorMessage.AppendLine("Price Should Not be Less Than 0 for Premium Documents!");
}
if (string.IsNullOrEmpty(obj.DocumentPath))
{
IsValid = false;
ErrorMessage.AppendLine("Document Path Should Not be Epmty!");
}
if (!IsValid)
{
throw new ELibException(ErrorMessage.ToString());
}
return(IsValid);
}
public List <Document_Details> SearchDocumentById(int id)
{
Document_Details DocumentDetailsObj = null;
var DocumentsList = new List <Document_Details>();
var ConnectionObj = DatabaseConnection.CreateConnection();
var CommandObj = DatabaseConnection.CreateCommand(ConnectionObj, "ELIB_Management_System.uspSelectDocument_DetailsById", CommandType.StoredProcedure);
var P1 = DatabaseConnection.CreateParameter(CommandObj, "@document_id", DbType.Int32);
P1.Value = id;
CommandObj.Parameters.Add(P1);
try
{
DataTable TableObj = DatabaseConnection.ExecuteReader(CommandObj);
if (TableObj != null && TableObj.Rows.Count > 0)
{
foreach (DataRow row in TableObj.Rows)
{
DocumentDetailsObj = new Document_Details();
DocumentDetailsObj.DocumentId = (int)row[0];
DocumentDetailsObj.DocumentName = (string)row[1];
DocumentDetailsObj.DocumentDescription = (string)row[2];
DocumentDetailsObj.DocumentPath = (string)row[3];
DocumentDetailsObj.DocumentTypeId.DocumentTypeId = (int)row[4];
DocumentDetailsObj.DisciplineId.DisciplineId = (int)row[5];
DocumentDetailsObj.Title = (string)row[6];
DocumentDetailsObj.Author = (string)row[7];
DocumentDetailsObj.UploadDate = ((DateTime)row[8]).Date;
DocumentDetailsObj.Price = (decimal)row[9];
DocumentDetailsObj.DocumentTypeName = (string)row[10];
DocumentDetailsObj.DisciplineName = (string)row[11];
DocumentsList.Add(DocumentDetailsObj);
}
}
}
catch (DbException ex)
{
throw new ELibException("Error reading data", ex);
}
catch (Exception ex)
{
throw new ELibException("Unknown error", ex);
}
return(DocumentsList);
}
/// <summary>
/// Event That Fires on Update Buttons Click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (txtDocumentNameUpdate.Text != null && txtDocumentDescriptionUpdate.Text != null && cmbDocumentTypeUpdate.Text != null &&
cmbDisciplineNameUpdate.Text != null && txtTitleUpdate != null && txtAuthorUpdate != null && txtPriceUpdate != null &&
lblPathUpdate.Text != null)
{
Document_Details DocumentObj = new Document_Details();
DocumentObj.DocumentId = Convert.ToInt32(txtDocumentIdUpdate.Text);
DocumentObj.DocumentName = txtDocumentNameUpdate.Text;
DocumentObj.DocumentDescription = txtDocumentDescriptionUpdate.Text;
DocumentObj.DocumentTypeId.DocumentTypeId = Convert.ToInt32(cmbDocumentTypeUpdate.SelectedItem.Value);
DocumentObj.DisciplineId.DisciplineId = Convert.ToInt32(cmbDisciplineNameUpdate.SelectedItem.Value);
DocumentObj.Title = txtTitleUpdate.Text;
DocumentObj.Author = txtAuthorUpdate.Text;
DocumentObj.Price = Convert.ToDecimal(txtPriceUpdate.Text);
SaveFileUpdate(fileUpdate);
DocumentObj.DocumentPath = pathToCheck;
var DocumentBLLObj = new Document_DetailsBLL();
var IsAdded = DocumentBLLObj.UpdateDocument(DocumentObj);
if (IsAdded)
{
Response.Write("<script>alert('Document Details Updated!')</script>");
}
else
{
Response.Write("<script>alert('Unable to update document')</script>");
}
}
}
catch (FormatException ex)
{
Response.Write("<script>alert('" + ex.Message + "')</script>");
}
catch (ELibException ex)
{
Response.Write("<script>alert('" + ex.Message + "')</script>");
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "')</script>");
}
}
private void btnUpload_Click(object sender, RoutedEventArgs e)
{
try
{
var dd = cmbDisciplineName.SelectedItem as Disciplines;
Document_Details DocumentObj = new Document_Details();
var dd1 = cmbDocumentTypeName.SelectedItem as Document_Type_Details;
DocumentObj.DocumentName = txtDocumentNameUpload.Text;
DocumentObj.DocumentDescription = txtDocumentDescriptionUpload.Text;
DocumentObj.DocumentTypeId.DocumentTypeId = dd1.DocumentTypeId;
DocumentObj.DisciplineId.DisciplineId = dd.DisciplineId;
DocumentObj.Title = txtTitleUpload.Text;
DocumentObj.Author = txtAuthorUpload.Text;
DocumentObj.Price = Convert.ToDecimal(txtPriceUpload.Text);
File(dialog1);
DocumentObj.DocumentPath = path;
var DocumentBLLObj = new Document_DetailsBLL();
var IsAdded = DocumentBLLObj.UploadDocument(DocumentObj);
if (IsAdded)
{
MessageBox.Show("Document Details added");
}
else
{
MessageBox.Show("Document Details not added");
}
}
catch (FormatException ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK);
}
catch (ELibException ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK);
}
catch (Exception ex)
{
MessageBox.Show("All Fields are Mandatory", "Error", MessageBoxButton.OK);
}
}
public bool UploadDocument(Document_Details documentObj)
{
var IsAdded = false;
try
{
if (ValidateDocuments(documentObj))
{
var DALObj = new Document_DetailsOperations();
IsAdded = DALObj.UploadDocument(documentObj);
}
}
catch (ELibException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new ELibException("Unknown error", ex);
}
return(IsAdded);
}
public bool UpdateDocument(Document_Details DocumentObj)
{
var IsUpdated = false;
try
{
if (ValidateDocuments(DocumentObj))
{
var ObjDAL = new Document_DetailsOperations();
IsUpdated = ObjDAL.UpdateDocument(DocumentObj);
}
}
catch (ELibException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new ELibException("Error editing Document details", ex);
}
return(IsUpdated);
}
public bool UpdateDocument(Document_Details documentObj)
{
var IsUpdated = false;
Document_Details newObj = new Document_Details();
var ConnectionObj = DatabaseConnection.CreateConnection();
var CommandObj = DatabaseConnection.CreateCommand(ConnectionObj, "ELIB_Management_System.uspUpdateDocument_Details", CommandType.StoredProcedure);
var Param0 = DatabaseConnection.CreateParameter(CommandObj, "@document_id", DbType.String);
Param0.Value = documentObj.DocumentId;
//Param0.Size = 20;
CommandObj.Parameters.Add(Param0);
var Param1 = DatabaseConnection.CreateParameter(CommandObj, "@document_name", DbType.String);
Param1.Value = documentObj.DocumentName;
Param1.Size = 20;
CommandObj.Parameters.Add(Param1);
var Param2 = DatabaseConnection.CreateParameter(CommandObj, "@document_description", DbType.String);
Param2.Value = documentObj.DocumentDescription;
Param2.Size = 200;
CommandObj.Parameters.Add(Param2);
var Param3 = DatabaseConnection.CreateParameter(CommandObj, "@document_path", DbType.String);
Param3.Value = documentObj.DocumentPath;
Param3.Size = 50;
CommandObj.Parameters.Add(Param3);
var Param4 = DatabaseConnection.CreateParameter(CommandObj, "@document_type_id", DbType.String);
Param4.Value = documentObj.DocumentTypeId.DocumentTypeId;
//Param4.Size = 200;
CommandObj.Parameters.Add(Param4);
var Param5 = DatabaseConnection.CreateParameter(CommandObj, "@discipline_id", DbType.String);
Param5.Value = documentObj.DisciplineId.DisciplineId;
//Param5.Size = 200;
CommandObj.Parameters.Add(Param5);
var Param6 = DatabaseConnection.CreateParameter(CommandObj, "@title", DbType.String);
Param6.Value = documentObj.Title;
Param6.Size = 30;
CommandObj.Parameters.Add(Param6);
var Param7 = DatabaseConnection.CreateParameter(CommandObj, "@author", DbType.String);
Param7.Value = documentObj.Author;
Param7.Size = 50;
CommandObj.Parameters.Add(Param7);
var Param8 = DatabaseConnection.CreateParameter(CommandObj, "@price", DbType.String);
Param8.Value = documentObj.Price;
CommandObj.Parameters.Add(Param8);
try
{
DatabaseConnection.ExecuteNonQuery(CommandObj);
IsUpdated = true;
}
catch (DbException ex)
{
throw new ELibException(ex.Message);
}
catch (Exception ex)
{
throw new ELibException(ex.Message);
}
return(IsUpdated);
}
