protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["QuantityUnder"] != null)
{
string quantityUnder = ClassHashing.basicDecryption(Request.QueryString["QuantityUnder"]);
Company company = Company.getCompanyByID(Request.Cookies["CompanyID"].Value);
StaffReportTableAdapters.GetStockRemainReportTableAdapter ds = new StaffReportTableAdapters.GetStockRemainReportTableAdapter();
DataTable dt = ds.GetData(Convert.ToInt32(quantityUnder), company.CompanyID);
ReportParameter[] rParams = new ReportParameter[]
{
new ReportParameter("Limit", quantityUnder),
new ReportParameter("CompanyName", company.Name),
new ReportParameter("CompanyAddress", company.Address)
};
rvStockRemainReport.LocalReport.ReportPath = "Staff/Owner/Report/StockRemainReport.rdlc";
rvStockRemainReport.LocalReport.DataSources.Clear();
rvStockRemainReport.LocalReport.DataSources.Add(new ReportDataSource("getStockRemain", dt));
rvStockRemainReport.LocalReport.SetParameters(rParams);
rvStockRemainReport.LocalReport.Refresh();
}
else
{
Response.Write("<script LANGUAGE='JavaScript' >alert('Unable to generate relative document.')</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["UserCookie"] != null)
{
var Cookie = Request.Cookies["UserCookie"];
if (Cookie.Values["UserInfo"] != null)
{
txtcurrent.Text = DateTime.Now.ToString("yyyy-MM-ddTH:mm");
CompareDuedate.ValueToCompare = Convert.ToString(txtcurrent.Text);
string userString = ClassHashing.basicDecryption(Cookie.Values["UserInfo"].ToString());
User user = ExpressPrintingSystem.Model.Entities.User.toUserObject(userString);
txtcustomerID.Text = user.ID;
string d = txtDueDate.Text;
ViewState["UserID"] = ClassHashing.basicEncryption(user.ID);
string detail = "Information" + "<br/>";
detail += "----------------------" + "<br />";
detail += "Non-Color" + "<br/>";
detail += "-----------" + "<br/>";
detail += "P1001 -" + "RM2.50 for Binding, Plastic cover and RM0.10 for non-color page" + "<br/>";
detail += "Color Page" + "<br/>";
detail += "-----------" + "<br/>";
detail += "P1002 -" + "RM2.50 for binding, Plastic cover and RM0.30 for color page" + "<br/>";
Label11.Text = detail;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["StartDate"] != null && Request.QueryString["EndDate"] != null && Request.QueryString["ReportType"] != null)
{
string startingDate = ClassHashing.basicDecryption(Request.QueryString["StartDate"]);
string endingDate = ClassHashing.basicDecryption(Request.QueryString["EndDate"]);
string reportType = ClassHashing.basicDecryption(Request.QueryString["ReportType"]);
Company company = Company.getCompanyByID(Request.Cookies["CompanyID"].Value);
StaffReportTableAdapters.GetSalesReportTableAdapter ds = new StaffReportTableAdapters.GetSalesReportTableAdapter();
DataTable dt = ds.GetData(DateTime.Parse(startingDate), (DateTime.Parse(endingDate)).AddDays(1), company.CompanyID);
Microsoft.Reporting.WebForms.ReportParameter[] rParams = new Microsoft.Reporting.WebForms.ReportParameter[]
{
new Microsoft.Reporting.WebForms.ReportParameter("FromDate", startingDate),
new Microsoft.Reporting.WebForms.ReportParameter("ToDate", endingDate),
new Microsoft.Reporting.WebForms.ReportParameter("reportType", reportType),
new Microsoft.Reporting.WebForms.ReportParameter("CompanyName", company.Name),
new Microsoft.Reporting.WebForms.ReportParameter("CompanyAddress", company.Address)
};
rvSalesReport.LocalReport.ReportPath = "Staff/Owner/Report/SaleReport.rdlc";
rvSalesReport.LocalReport.DataSources.Clear();
rvSalesReport.LocalReport.DataSources.Add(new ReportDataSource("getSales", dt));
rvSalesReport.LocalReport.SetParameters(rParams);
rvSalesReport.LocalReport.Refresh();
}
else
{
Response.Write("<script LANGUAGE='JavaScript' >alert('Unable retrieve generate relative document.')</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.Form.DefaultButton = this.btnSubmit.UniqueID;
if (!IsPostBack)
{
DisplayAppropriateAuthorizationMessage();
if (Request.Cookies["me"] != null)
{
txtname.Text = ClassHashing.basicDecryption((string)Request.Cookies["me"].Value);
CheckBox1.Checked = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.Cookies["UserCookie"] != null)
{
var Cookie = Request.Cookies["UserCookie"];
if (Cookie.Values["UserInfo"] != null)
{
string userString = ClassHashing.basicDecryption(Cookie.Values["UserInfo"].ToString());
User user = ExpressPrintingSystem.Model.Entities.User.toUserObject(userString);
ViewState["UserID"] = ClassHashing.basicEncryption(user.ID);
SqlConnection conTaxi;
string connStr = ConfigurationManager.ConnectionStrings["printDBServer"].ConnectionString;
conTaxi = new SqlConnection(connStr);
conTaxi.Open();
string strCheck;
SqlCommand cmdCheck;
strCheck = "Select CustomerName, CustomerEmail, CustomerDOB, CustomerPhoneNo, CustomerContactMethod from Customer Where CustomerID=@CustomerID";
cmdCheck = new SqlCommand(strCheck, conTaxi);
cmdCheck.Parameters.AddWithValue("@CustomerID", user.ID);
SqlDataReader dtr;
dtr = cmdCheck.ExecuteReader();
if (dtr.Read())
{
string CustomerName = dtr["CustomerName"].ToString();
string customeremail = dtr["CustomerEmail"].ToString();
DateTime customerdob = Convert.ToDateTime(dtr["CustomerDOB"]);
string customerphoneno = dtr["CustomerPhoneNo"].ToString();
string customercontmethod = dtr["CustomerContactMethod"].ToString();
txtName.Text = CustomerName;
txtEmail.Text = customeremail;
customerDOB.Text = Convert.ToString(customerdob);
txtPhoNo.Text = customerphoneno;
rbtContMet.SelectedValue = customercontmethod;
}
conTaxi.Close();
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["UserCookie"] != null)
{
var Cookie = Request.Cookies["UserCookie"];
if (Cookie.Values["UserInfo"] != null)
{
string userString = ClassHashing.basicDecryption(Cookie.Values["UserInfo"].ToString());
User user = ExpressPrintingSystem.Model.Entities.User.toUserObject(userString);
ViewState["UserID"] = ClassHashing.basicEncryption(user.ID);
bindData();
}
}
}
private void populateRequirementControl()
{
DataTable documentlistDataTable;
if (Request.QueryString["requestlistid"] != null && Request.QueryString["documentID"] != null)
{
string requestlistID = ClassHashing.basicDecryption(Request.QueryString["requestlistid"]);
string documentID = ClassHashing.basicDecryption(Request.QueryString["documentID"]);
try
{
using (SqlConnection conPrintDB = new SqlConnection(ConfigurationManager.ConnectionStrings["printDBServer"].ConnectionString))
{
string strSelect = "SELECT * FROM Documentlist WHERE RequestlistID = @requestlistID AND DocumentID = @documentID";
using (SqlCommand cmdSelect = new SqlCommand(strSelect, conPrintDB))
{
cmdSelect.Parameters.AddWithValue("@requestlistID", requestlistID);
cmdSelect.Parameters.AddWithValue("@documentID", documentID);
using (SqlDataAdapter da = new SqlDataAdapter(cmdSelect))
{
documentlistDataTable = new DataTable();
da.Fill(documentlistDataTable);
}
}
lblColor.Text = (string)documentlistDataTable.Rows[0]["DocumentColor"];
lblBothSide.Text = (string)documentlistDataTable.Rows[0]["DocumentBothSide"];
lblPaperType.Text = String.Format("{0} gsm", (int)documentlistDataTable.Rows[0]["DocumentPaperType"]);
lblQuantity.Text = String.Format("{0}", (int)documentlistDataTable.Rows[0]["DocumentQuantity"]);
lblDescription.Text = (string)documentlistDataTable.Rows[0]["DocumentDescription"];
}
}
catch (Exception ex)
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "There is a problem occur when processing the document. Please try again later";
}
}
else
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "System cannot find any document. Please retry.";
}
}
private void populateStaffToControls()
{
DataTable result = null;
try
{
if (Request.QueryString["staffID"] != null)
{
using (SqlConnection conPrintDB = new SqlConnection(ConfigurationManager.ConnectionStrings["printDBServer"].ConnectionString))
{
string strSelect = "select StaffName, StaffEmail, StaffNRIC, StaffDOB, StaffPhoneNo from CompanyStaff where StaffID = @staffID";
string encryptedText = (string)Request.QueryString["staffID"];
string staffID = ClassHashing.basicDecryption(encryptedText);
using (SqlCommand cmdSelect = new SqlCommand(strSelect, conPrintDB))
{
cmdSelect.Parameters.AddWithValue("@staffID", staffID);
using (SqlDataAdapter da = new SqlDataAdapter(cmdSelect))
{
result = new DataTable();
da.Fill(result);
}
lblStaffID.Text = staffID;
txtName.Text = (string)result.Rows[0]["StaffName"];
txtEmail.Text = (string)result.Rows[0]["StaffEmail"];
txtNRIC.Text = (string)result.Rows[0]["StaffNRIC"];
txtPhoneNo.Text = (string)result.Rows[0]["StaffPhoneNo"];
cldBOD.SelectedDate = Convert.ToDateTime(result.Rows[0]["StaffDOB"]);
cldBOD.VisibleDate = Convert.ToDateTime(result.Rows[0]["StaffDOB"]);
}
}
}
else
{
lblError.Text = "The system could not found any record related to the staff.";
}
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string userID = ClassHashing.basicDecryption((string)ViewState["UserID"]);
SqlConnection conTaxi;
string connStr = ConfigurationManager.ConnectionStrings["printDBServer"].ConnectionString;
conTaxi = new SqlConnection(connStr);
conTaxi.Open();
string strEdit;
SqlCommand cmdAdd;
strEdit = "Update Customer Set CustomerName = @customerName, CustomerEmail = @customerEmail, CustomerDOB = @customerDOB, CustomerPhoneNo = @customerPhoneNo, CustomerContactMethod = @customerContactMethod WHERE CustomerID = @customerID";
cmdAdd = new SqlCommand(strEdit, conTaxi);
cmdAdd.Parameters.AddWithValue("@customerName", txtName.Text);
cmdAdd.Parameters.AddWithValue("@customerEmail", txtEmail.Text);
cmdAdd.Parameters.AddWithValue("@customerDOB", Convert.ToDateTime(customerDOB.Text));
cmdAdd.Parameters.AddWithValue("@customerPhoneNo", txtPhoNo.Text);
cmdAdd.Parameters.AddWithValue("@customerContactMethod", rbtContMet.SelectedValue);
cmdAdd.Parameters.AddWithValue("@customerID", userID);
int m = cmdAdd.ExecuteNonQuery();
if (m > 0)
{
Response.Write("<script>alert('Updated Successful');</script>");
Response.Redirect("CustomerDetail.aspx");
}
else
{
Response.Write("<script>alert('Updated Failed');</script>");
}
conTaxi.Close();
}
private void populateDocumentControl()
{
DataTable documentDataTable;
Document document;
if (Request.QueryString["documentID"] != null)
{
string documentID = ClassHashing.basicDecryption(Request.QueryString["documentID"]);
try
{
using (SqlConnection conPrintDB = new SqlConnection(ConfigurationManager.ConnectionStrings["printDBServer"].ConnectionString))
{
string strSelect = "SELECT * FROM Document WHERE DocumentID = @documentID";
using (SqlCommand cmdSelect = new SqlCommand(strSelect, conPrintDB))
{
cmdSelect.Parameters.AddWithValue("@documentID", documentID);
using (SqlDataAdapter da = new SqlDataAdapter(cmdSelect))
{
documentDataTable = new DataTable();
da.Fill(documentDataTable);
}
document = new Document((string)documentDataTable.Rows[0]["DocumentID"], (string)documentDataTable.Rows[0]["DocumentName"], (string)documentDataTable.Rows[0]["DocumentType"], (string)documentDataTable.Rows[0]["FileIDInCloud"], (string)documentDataTable.Rows[0]["CustomerID"], (int)documentDataTable.Rows[0]["Size"], (int)documentDataTable.Rows[0]["PageNumber"]);
}
}
documentViewer.DocumentSource = new DocumentSource(
new DocumentInfo(document.FileIDInCloud, document.DocumentName), backblaze.downloadFileIntoBytes(document.FileIDInCloud));
}
catch (Exception ex)
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "There is a problem occur when processing the document. Please try again later";
}
}
else
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "System cannot find any document. Please retry.";
}
}
private List <Document> getDocumentList()
{
string userID = ClassHashing.basicDecryption((string)ViewState["UserID"]);
List <Document> listdocument = new List <Document>();
DataTable documentResult;
try
{
using (SqlConnection conPrintDB = new SqlConnection(ConfigurationManager.ConnectionStrings["printDBServer"].ConnectionString))
{
string strSelect = "SELECT * from Document WHERE CustomerID = @CustomerID";
using (SqlCommand cmdSelect = new SqlCommand(strSelect, conPrintDB))
{
cmdSelect.Parameters.AddWithValue("@CustomerID", userID);
using (SqlDataAdapter da = new SqlDataAdapter(cmdSelect))
{
documentResult = new DataTable();
da.Fill(documentResult);
}
for (int i = 0; i < documentResult.Rows.Count; i++)
{
Document document = new Document((string)documentResult.Rows[i]["DocumentID"], (string)documentResult.Rows[i]["DocumentName"], (string)documentResult.Rows[i]["DocumentType"], (string)documentResult.Rows[i]["FileIDInCloud"], (string)documentResult.Rows[i]["CustomerID"], (int)documentResult.Rows[i]["Size"], (int)documentResult.Rows[i]["PageNumber"]);
//Documentlist newDocumentlist = new Documentlist(document, (int)documentResult.Rows[i]["Sequences"], (string)documentResult.Rows[i]["DocumentColor"], (string)documentResult.Rows[i]["DocumentBothSide"], (int)documentResult.Rows[i]["DocumentPaperType"], (int)documentResult.Rows[i]["DocumentQuantity"], documentResult.Rows[i]["DocumentDescription"].ToString());
//newDocumentlist.RequestlistID = requestlistID;
//documentList.Add(newDocumentlist);
listdocument.Add(document);
}
}
}
return(listdocument);
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
protected void btnCreditCardlink_Click(object sender, ImageClickEventArgs e)
{
if (Request.Cookies["UserCookie"] != null)
{
var Cookie = Request.Cookies["UserCookie"];
if (Cookie.Values["UserInfo"] != null)
{
string userString = ClassHashing.basicDecryption(Cookie.Values["UserInfo"].ToString());
User user = ExpressPrintingSystem.Model.Entities.User.toUserObject(userString);
SqlConnection conTaxi;
string connStr = ConfigurationManager.ConnectionStrings["printDBServer"].ConnectionString;
conTaxi = new SqlConnection(connStr);
conTaxi.Open();
string strCheck;
SqlCommand cmdCheck;
strCheck = "Select CustomerEmail from Customer Where CustomerID=@CustomerID";
cmdCheck = new SqlCommand(strCheck, conTaxi);
cmdCheck.Parameters.AddWithValue("@CustomerID", user.ID);
SqlDataReader dtr;
dtr = cmdCheck.ExecuteReader();
if (dtr.Read())
{
string customeremail = dtr["CustomerEmail"].ToString();
Session["email"] = customeremail;
}
conTaxi.Close();
}
}
Response.Redirect("Payment.aspx");
}
private void verifyUser()
{
if (Request.Cookies["UserCookie"] != null)
{
var cookie = Request.Cookies["UserCookie"];
if (cookie.Values["UserInfo"] != null)
{
string userString = ClassHashing.basicDecryption(cookie.Values["UserInfo"].ToString());
User user = ExpressPrintingSystem.Model.Entities.User.toUserObject(userString);
initUserMenu();
userInfoControl.Text = "Welcome, " + user.Name;
userInfoControl.NavigateUrl = "";
}
else
{
if (Request.Cookies["UserCookie"] != null)
{
Response.Cookies["UserCookie"].Expires = DateTime.Now.AddDays(-1);
}
FormsAuthentication.SignOut();
userInfoControl.Text = "Sign In";
userInfoControl.NavigateUrl = "";
}
}
else
{
if (Request.Cookies["UserCookie"] != null)
{
Response.Cookies["UserCookie"].Expires = DateTime.Now.AddDays(-1);
}
FormsAuthentication.SignOut();
userInfoControl.Text = "Sign In";
userInfoControl.NavigateUrl = "";
}
}
private Request PopulateDataToObject()
{
List <Documentlist> documentlist = createDocumentList();
List <Requestlist> requestlist = new List <Requestlist>();
Requestlist newRequestlist = new Requestlist(ddlPackage.SelectedValue, Requestlist.STATUS_PENDING, rbtRequestType.SelectedValue, documentlist);
requestlist.Add(newRequestlist);
string companyID = Request.QueryString["CompanyID"];
string CustomerID = ClassHashing.basicDecryption((string)ViewState["UserID"]);
DateTime currentDate = DateTime.Now;
DateTime DueDate = Convert.ToDateTime(txtDueDate.Text);
Request request = new Model.Entities.Request(currentDate, DueDate, null, companyID, CustomerID, requestlist);
return(request);
}
private void populateDataToControls()
{
if (Request.QueryString["PackageID"] != null)
{
string packageid = ClassHashing.basicDecryption(Request.QueryString["PackageID"]);
DataTable packageResult = null;
DataTable itemsResult = null;
try
{
using (SqlConnection conPrintDB = new SqlConnection(ConfigurationManager.ConnectionStrings["printDBServer"].ConnectionString))
{
string strSelect = "SELECT * FROM Package WHERE PackageID = @packageid";
using (SqlCommand cmdSelect = new SqlCommand(strSelect, conPrintDB))
{
cmdSelect.Parameters.AddWithValue("@packageid", packageid);
using (SqlDataAdapter da = new SqlDataAdapter(cmdSelect))
{
packageResult = new DataTable();
da.Fill(packageResult);
}
}
if (packageResult != null)
{
itemsResult = null;
strSelect = "SELECT i.ItemID, i.ItemName, i.ItemPrice, i.ItemStockQuantity, i.ItemSupplier, p.Quantity FROM Item i, PackageItem p WHERE i.ItemID = p.ItemID AND p.PackageID = @packageID";
using (SqlCommand cmdSelect = new SqlCommand(strSelect, conPrintDB))
{
cmdSelect.Parameters.Clear();
cmdSelect.Parameters.AddWithValue("@packageID", packageid);
using (SqlDataAdapter da = new SqlDataAdapter(cmdSelect))
{
itemsResult = new DataTable();
da.Fill(itemsResult);
}
}
Model.Entities.Package package;
List <PackageItems> packageItems = new List <PackageItems>();
if (itemsResult != null)
{
for (int j = 0; j < itemsResult.Rows.Count; j++)
{
packageItems.Add(new PackageItems(new Model.Entities.Item((string)itemsResult.Rows[j]["ItemID"], (string)itemsResult.Rows[j]["ItemName"], (decimal)itemsResult.Rows[j]["ItemPrice"],
(int)itemsResult.Rows[j]["ItemStockQuantity"], (string)itemsResult.Rows[j]["ItemSupplier"]), (int)itemsResult.Rows[j]["Quantity"]));
}
package = new Model.Entities.Package((string)packageResult.Rows[0]["PackageID"], (string)packageResult.Rows[0]["PackageName"], (decimal)packageResult.Rows[0]["PackagePrice"], (string)packageResult.Rows[0]["PackageSupport"], (string)packageResult.Rows[0]["PackageType"], (decimal)packageResult.Rows[0]["PrintingPricePerPaper"], packageItems);
}
else
{
package = new Model.Entities.Package((string)packageResult.Rows[0]["PackageID"], (string)packageResult.Rows[0]["PackageName"], (decimal)packageResult.Rows[0]["PackagePrice"], (string)packageResult.Rows[0]["PackageSupport"], (string)packageResult.Rows[0]["PackageType"], (decimal)packageResult.Rows[0]["PrintingPricePerPaper"]);
}
lblPackageID.Text = package.PackageID;
txtName.Text = package.PackageName;
txtPrice.Text = String.Format("{0:0.00}", package.PackagePrice);
ddlType.SelectedValue = package.PackageType;
if (ddlType.SelectedValue.Equals(Model.Entities.Package.TYPE_PRINTING))
{
string[] documentSupport = package.PackageSupport.Split(';');
foreach (string document in documentSupport)
{
for (int i = 0; i < cblSupport.Items.Count; i++)
{
if (cblSupport.Items[i].ToString().Equals(document))
{
cblSupport.Items[i].Selected = true;
}
}
}
txtPricePerPaper.Text = String.Format("{0:0.00}", package.PrintingPrice);
}
DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
DataRow drCurrentRow = null;
foreach (PackageItems packageitem in package.PackageItems)
{
//add new row
if (dtCurrentTable.Rows[0]["itemName"].Equals("N/A"))
{
dtCurrentTable.Rows[dtCurrentTable.Rows.Count - 1]["itemID"] = packageitem.Item.ItemID;
dtCurrentTable.Rows[dtCurrentTable.Rows.Count - 1]["itemName"] = packageitem.Item.ItemName;
dtCurrentTable.Rows[dtCurrentTable.Rows.Count - 1]["Column1"] = packageitem.Quantity;
}
else
{
drCurrentRow = dtCurrentTable.NewRow();
drCurrentRow["itemID"] = packageitem.Item.ItemID;
drCurrentRow["itemName"] = packageitem.Item.ItemName;
drCurrentRow["Column1"] = packageitem.Quantity;
dtCurrentTable.Rows.Add(drCurrentRow);
}
}
ViewState["CurrentTable"] = dtCurrentTable;
gvPackageItem.DataSource = dtCurrentTable;
gvPackageItem.DataBind();
SetPreviousData();
}
}
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
else
{
lblError.Text = "Invalid PackageID. Please reselect your package to edit.";
}
}
private List <Documentlist> createDocumentList()
{
string userID = ClassHashing.basicDecryption((string)ViewState["UserID"]);
//create document list and upload file to cloud
List <Documentlist> documentList = new List <Documentlist>();
int totalpage = 0;
int count = 0;
int normalCount = 0;
if (FileUpload1.HasFile)
{
HttpFileCollection hfc = Request.Files;
for (int i = 0; i < hfc.Count; i++)
{
HttpPostedFile hpf = hfc[i];
if (hpf.ContentLength > 0)
{
//upload to backblaze
String contentType = hpf.ContentType; //Type of file i.e. image/jpeg, audio/mpeg...
String getPath = Path.GetFileName(hpf.FileName);
hpf.SaveAs(Server.MapPath("~/File/") + getPath); //save to server side file
String fileName = hpf.FileName; //Desired name for the file
String filePath = Server.MapPath("~/File/") + getPath; //File path of desired upload
int size = FileUpload1.PostedFile.ContentLength;
lblgetallfilename.Text += String.Format("{0} , ", fileName);
string getallfilename = lblgetallfilename.Text;
Session["allfilename"] = getallfilename;
Session["pathfile"] = filePath;
string getFileIDInCloud = backblaze.UploadFile(contentType, filePath, fileName);
int numberOfPages = 0;
if (Path.GetExtension(hpf.FileName).Equals(".docx"))
{
// get the page number
var application = new Application();
var document = application.Documents.Open(filePath); //open document
numberOfPages = document.ComputeStatistics(WdStatistic.wdStatisticPages, false);
document.Close(); ///close document
//get the count of file
count = hfc.Count;
Session["countthepackageitem"] = count;
FileInfo file = new FileInfo(filePath);
if (file.Exists)//check file exsit or not
{
file.Delete();
}
}
else if (Path.GetExtension(hpf.FileName).Equals(".pdf"))
{
FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read);
StreamReader r = new StreamReader(fs);
string pdfText = r.ReadToEnd();
Regex rx1 = new Regex(@"/Type\s*/Page[^s]");
MatchCollection matches = rx1.Matches(pdfText);
numberOfPages = Convert.ToInt32(matches.Count.ToString());
fs.Close();
//get the count of file
count = hfc.Count;
Session["countthepackageitem"] = count;
FileInfo file = new FileInfo(filePath);
if (file.Exists)//check file exsit or not
{
file.Delete();
}
}
else if (Path.GetExtension(hpf.FileName).Equals(".png") || Path.GetExtension(hpf.FileName).Equals(".PNG") || Path.GetExtension(hpf.FileName).Equals(".jpg"))
{
count = hfc.Count - 1;
Session["countthepackageitem"] = count;
numberOfPages = 1;
FileInfo file = new FileInfo(filePath);
if (file.Exists)//check file exsit or not
{
file.Delete();
}
}
//calculate the total page in multiple file
totalpage += numberOfPages;
Session["totalpage"] = totalpage;
normalCount = hfc.Count;
Session["normalcount"] = normalCount;
// upload to my sqldatabase
var uploadFileObject = (JObject)JsonConvert.DeserializeObject(getFileIDInCloud);
String FileIdInCloud = uploadFileObject["fileId"].Value <string>();//get file ID
Model.Entities.Document newdocument = new Model.Entities.Document(fileName, contentType, FileIdInCloud, userID, size, numberOfPages);
int sequences = 0; ////remember to do it;
string documentColor = "null";
string documentbothside = rbtDocumentSide.SelectedValue;
int documentpapertype = Convert.ToInt32(ddlPaperType.SelectedValue);
int documentquantity = Convert.ToInt32(txtDocumentQuantity.Text);
string documentdescription = txtDocumentDescription.Text;
documentList.Add(new Documentlist(newdocument, sequences, documentColor, documentbothside, documentpapertype, documentquantity, documentdescription));
}
}
}
return(documentList);
}