private String saveFile(HttpPostedFile postedFile)
{
int userID = 0;
string userName = getUserNameFromFile(postedFile);
EReceiptLINQDataContext context = new EReceiptLINQDataContext();
var lastReceiptNumber = from num in context.Receipts
select num;
int maxReceiptValue = (from c in lastReceiptNumber select c.RECEIPT_ID).Max();
string savePath = ("~/IMG/receiptImage/" + userName + "/receipt" + (maxReceiptValue + 1) + ".jpg");
DirectoryCheck(userName);
FileUpload1.SaveAs(Server.MapPath(savePath));
string pathOfFile = "http://localhost:49765/" + savePath.Substring(savePath.IndexOf("~") + 2);
Receipt receiptImage = new Receipt
{
RECEIPT_URL = pathOfFile,
UPLOAD_DATE = DateTime.Now,
};
context.Receipts.InsertOnSubmit(receiptImage);
context.SubmitChanges();
var userIDNumber = from u in context.Customers
where u.USER_NAME == userName
select u;
foreach (var x in userIDNumber)
{
userID = x.USER_ID;
break;
}
CustomerReceipt custRec = new CustomerReceipt
{
USER_ID = userID,
RECEIPT_ID = (maxReceiptValue + 1),
};
context.CustomerReceipts.InsertOnSubmit(custRec);
context.SubmitChanges();
context.Connection.Close();
Label1.Text = "Upload Successful";
return savePath;
}
protected void Button1_Click(object sender, EventArgs e)
{
String generatedKey = "p+1o,";
String saltedKey = CalculateMD5Hash(passwordTextBox.Text.ToString() + generatedKey);
String hashedKey = CalculateMD5Hash(saltedKey); //saltedKey.GetHashCode().ToString();
using (EReceiptLINQDataContext context = new EReceiptLINQDataContext())
{
var potentialUserName = from u in context.Customers
where u.USER_NAME == usernameTextBox.Text
select u;
if (Enumerable.Count(potentialUserName) == 1)
{
// UserNameTaken.Text = "Username Already Taken";
Response.Redirect("Today.aspx", false);
}
else
{
Customer customer = new Customer
{
USER_NAME = usernameTextBox.Text,
FIRST_NAME = firstNameTextBox.Text,
LAST_NAME = lastNameTextBox.Text,
EMAIL = emailTextBox.Text,
SALT_PASSWORD = saltedKey,
HASHED_PASSWORD = hashedKey,
};
context.Customers.InsertOnSubmit(customer);
context.SubmitChanges();
Session["LoggedInUsername"] = usernameTextBox.Text;
Response.Redirect("Today.aspx", false);
}
}
}
private String saveFile(HttpPostedFile postedFile)
{
int userID = 0;
string userName = getUserNameFromFile(postedFile);
EReceiptLINQDataContext context = new EReceiptLINQDataContext();
var lastReceiptNumber = from num in context.Receipts
select num;
int maxReceiptValue = (from c in lastReceiptNumber select c.RECEIPT_ID).Max();
string savePath = ("~/IMG/receiptImage/" + userName + "/receipt" + (maxReceiptValue + 1) + ".jpg");
DirectoryCheck(userName);
FileUpload1.SaveAs(Server.MapPath(savePath));
string pathOfFile = "http://localhost:49765/" + savePath.Substring(savePath.IndexOf("~") + 2);
Receipt receiptImage = new Receipt
{
RECEIPT_URL = pathOfFile,
UPLOAD_DATE = DateTime.Now,
};
context.Receipts.InsertOnSubmit(receiptImage);
context.SubmitChanges();
var userIDNumber = from u in context.Customers
where u.USER_NAME == userName
select u;
foreach (var x in userIDNumber)
{
userID = x.USER_ID;
break;
}
CustomerReceipt custRec = new CustomerReceipt
{
USER_ID = userID,
RECEIPT_ID = (maxReceiptValue + 1),
};
context.CustomerReceipts.InsertOnSubmit(custRec);
context.SubmitChanges();
context.Connection.Close();
Label1.Text = "Upload Successful";
return(savePath);
}
protected void LoginButton_Click1(object sender, EventArgs e)
{
String generatedKey = "p+1o,";
String saltedKey = CalculateMD5Hash(passwordTextBox.Text.ToString() + generatedKey);
String hashedKey = CalculateMD5Hash(saltedKey); //saltedKey.GetHashCode().ToString();
EReceiptLINQDataContext EReceiptDB = new EReceiptLINQDataContext();
var userResults = from u in EReceiptDB.Customers
where u.USER_NAME == usernameTextBox.Text &&
u.SALT_PASSWORD == saltedKey &&
u.HASHED_PASSWORD == hashedKey
select u;
if (Enumerable.Count(userResults) == 1)
{
Session["LoggedInUsername"] = usernameTextBox.Text;
Response.Redirect("Today.aspx");
}
else
{
}
}
protected void LoginButton_Click1(object sender, EventArgs e)
{
String generatedKey = "p+1o,";
String saltedKey = CalculateMD5Hash(passwordTextBox.Text.ToString() + generatedKey);
String hashedKey = CalculateMD5Hash(saltedKey); //saltedKey.GetHashCode().ToString();
EReceiptLINQDataContext EReceiptDB = new EReceiptLINQDataContext();
var userResults = from u in EReceiptDB.Customers
where u.USER_NAME == usernameTextBox.Text
&& u.SALT_PASSWORD == saltedKey
&& u.HASHED_PASSWORD == hashedKey
select u;
if (Enumerable.Count(userResults) == 1)
{
Session["LoggedInUsername"] = usernameTextBox.Text;
Response.Redirect("Today.aspx");
}
else
{
}
}
protected void Button1_Click(object sender, EventArgs e)
{
String generatedKey = "p+1o,";
String saltedKey = CalculateMD5Hash(passwordTextBox.Text.ToString() + generatedKey);
String hashedKey = CalculateMD5Hash(saltedKey); //saltedKey.GetHashCode().ToString();
using (EReceiptLINQDataContext context = new EReceiptLINQDataContext())
{
var potentialUserName = from u in context.Customers
where u.USER_NAME == usernameTextBox.Text
select u;
if (Enumerable.Count(potentialUserName) == 1)
{
// UserNameTaken.Text = "Username Already Taken";
Response.Redirect("Today.aspx", false);
}
else
{
Customer customer = new Customer
{
USER_NAME = usernameTextBox.Text,
FIRST_NAME = firstNameTextBox.Text,
LAST_NAME = lastNameTextBox.Text,
EMAIL = emailTextBox.Text,
SALT_PASSWORD = saltedKey,
HASHED_PASSWORD = hashedKey,
};
context.Customers.InsertOnSubmit(customer);
context.SubmitChanges();
Session["LoggedInUsername"] = usernameTextBox.Text;
Response.Redirect("Today.aspx", false);
}
}
}
