public ReturnError OpenAccount(string FullName, string UserName, String Password, Boolean AccountType,string EmailAdrress)
{
DBConnection DBop = new DBConnection();
ReturnError error = new ReturnError();
/// check if empty data
if (( FullName.Length==0)||( UserName.Length==0)||(Password.Length==0)||( EmailAdrress.Length==0))
{
error.ErrorID = 1;
error.ErrorMessage = "please fill all your information";
return error;
}
/// check if this account avilable
DataTable dataTable = new DataTable();
dataTable = DBop.NewConectionDLL.SelectDataSet("Admins", " * ", "UserName like '" + UserName + "' or EmailAdrress like '" + EmailAdrress + "'").Tables[0];
if ((dataTable != null) && (dataTable.Rows.Count > 0))
{
error.ErrorID = 1;
error.ErrorMessage = "the user name or email address already used by other account try with different email or user name";
return error;
}
/// save new account
///
ColoumnParam[] Coloumns = new ColoumnParam[6];
Coloumns[0] = new ColoumnParam("FullName", ColoumnType.varchar50, FullName);
Coloumns[1] = new ColoumnParam("UserName", ColoumnType.varchar50, UserName);
Coloumns[2] = new ColoumnParam("Password", ColoumnType.varchar50, Password);
Coloumns[3] = new ColoumnParam("AccountType", ColoumnType.Bit, AccountType);
Coloumns[4] = new ColoumnParam("DateRegister", ColoumnType.DateTime, DateTime.Now);
Coloumns[5] = new ColoumnParam("EmailAdrress", ColoumnType.varchar50, EmailAdrress);
if (DBop.NewConectionDLL.InsertRow("Admins", Coloumns))
{
dataTable = DBop.NewConectionDLL.SelectDataSet("Admins", " * ", "UserName like '" + UserName + "'").Tables[0];
/////send email to new account=========================================================
// System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage();
// mail.To.Add(EmailAdrress);
// mail.From = new MailAddress( "*****@*****.**" , "Email head", System.Text.Encoding.UTF8);
// mail.Subject = "Complete your final steps with my phone locations";
//mail.SubjectEncoding = System.Text.Encoding.UTF8;
//mail.Body = "Thank you for using my phone locations system" + Environment.NewLine + "Your account now ready to be used. please setup this app from google play on your phone" + Environment.NewLine + "https://play.google.com/store/apps/details?id=phonelocation.example.asuss550c.phonelocation" + Environment.NewLine + "Then from setting login with your user name and password." + Environment.NewLine + "And enjoy." + Environment.NewLine + "Best regards,";
//mail.BodyEncoding = System.Text.Encoding.UTF8;
//mail.IsBodyHtml = true;
//mail.Priority = MailPriority.High;
//SmtpClient client = new SmtpClient();
//client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "abc3551356");
//client.Port = 25;
//client.Host = "mail.alrubaye.com";
//client.EnableSsl = true;
//try
//{
// client.Send(mail);
// // Page.RegisterStartupScript("UserMsg", "<script>alert('Successfully Send...');if(alert){ window.location='SendMail.aspx';}</script>");
//}
//catch (Exception ex)
//{
// Exception ex2 = ex;
// string errorMessage = string.Empty;
// while (ex2 != null)
// {
// errorMessage += ex2.ToString();
// ex2 = ex2.InnerException;
// }
// // Page.RegisterStartupScript("UserMsg", "<script>alert('Sending Failed...');if(alert){ window.location='SendMail.aspx';}</script>");
//}
error.ErrorID = 2;
error.AdminID = (int)dataTable.Rows[0]["UserID"];
error.ErrorMessage = "Greate you insert new record";
return error;
}
else
{
error.ErrorID = 1;
error.ErrorMessage = "Error , cannot insert this record in the Database";
return error;
}
}
public ReturnError InsertPhoneInfo(int UserID, string PhoneMac, string PhoneName)
{
DBConnection DBop = new DBConnection();
ReturnError error = new ReturnError();
/// check if this account avilable
DataTable dataTable = new DataTable();
dataTable = DBop.NewConectionDLL.SelectDataSet("Admins", " * ", "UserID=" + UserID).Tables[0];
if ((dataTable != null) && (dataTable.Rows.Count > 0))
{
Boolean isnulti = (Boolean)dataTable.Rows[0]["AccountType"];
dataTable = DBop.NewConectionDLL.SelectDataSet("AdminPhones", " * ", "PhoneMac like '" + PhoneMac + "'").Tables[0];
if ((dataTable != null) && (dataTable.Rows.Count > 0))
{
error.ErrorID = 1;
error.ErrorMessage = "this phone is already registered in database";
return error;
}
// check if this phone is not comercial
if (isnulti == false)
{
dataTable = DBop.NewConectionDLL.SelectDataSet("AdminPhones", " * ", "UserID=" + UserID ).Tables[0];
if ((dataTable != null) && (dataTable.Rows.Count > 0))
{
error.ErrorID = 1;
error.ErrorMessage = "this type of account is for one device only";
return error;
}
}
ColoumnParam[] Coloumns = new ColoumnParam[4];
Coloumns[0] = new ColoumnParam("UserID", ColoumnType.Int, UserID);
Coloumns[1] = new ColoumnParam("PhoneMac", ColoumnType.varchar50, PhoneMac);
Coloumns[2] = new ColoumnParam("DateRegister", ColoumnType.DateTime, DateTime.Now);
Coloumns[3] = new ColoumnParam("PhoneName", ColoumnType.varchar50, PhoneName);
if (DBop.NewConectionDLL.InsertRow("AdminPhones", Coloumns))
{
error.ErrorID = 2;
error.ErrorMessage = "Greate you insert new record";
return error;
}
else
{
error.ErrorID = 1;
error.ErrorMessage = "Error , cannot insert this record in the Database";
return error;
}
}
else
{
error.ErrorID = 1;
error.ErrorMessage = "Error , cannot find this record in the Database";
return error;
}
}
public ReturnError InsertTrackR(string PhoneMac, string Latitude, string longitude)
{
DBConnection DBop = new DBConnection();
ReturnError error = new ReturnError();
/// check if this account avilable
DataTable dataTable = new DataTable();
dataTable = DBop.NewConectionDLL.SelectDataSet("AdminPhones", " * ", "PhoneMac like '" + PhoneMac + "'").Tables[0];
if ((dataTable != null) && (dataTable.Rows.Count > 0))
{
int PhoneID = (int)dataTable.Rows[0]["PhoneID"];
ColoumnParam[] Coloumns = new ColoumnParam[4];
Coloumns[0] = new ColoumnParam("Latitude", ColoumnType.Float, Latitude);
Coloumns[1] = new ColoumnParam("longitude", ColoumnType.Float, longitude);
Coloumns[2] = new ColoumnParam("PhoneID", ColoumnType.Int, PhoneID);
Coloumns[3] = new ColoumnParam("DateRecord", ColoumnType.DateTime, DateTime.Now);
if (DBop.NewConectionDLL.InsertRow("Tracking", Coloumns))
{
error.ErrorID = 2;
error.ErrorMessage = "Greate you insert new record";
return error;
}
else
{
error.ErrorID = 1;
error.ErrorMessage = "Error , cannot insert this record in the Database";
return error;
}
}
else
{
error.ErrorID = 1;
error.ErrorMessage = "Error , this phone isnot register in your database";
return error;
}
}
public ReturnError IsExisitAccount(string UserName, string Password)
{
DBConnection DBop = new DBConnection();
ReturnError error = new ReturnError();
/// check if this account avilable
DataTable dataTable = new DataTable();
dataTable = DBop.NewConectionDLL.SelectDataSet("Admins", " * ", "UserName like '" + UserName + "' AND Password like '" + Password + "'").Tables[0];
if ((dataTable != null) && (dataTable.Rows.Count > 0))
{
error.ErrorID = 2;
error.AdminID = (int)dataTable.Rows[0]["UserID"];
error.ErrorMessage = "Greate we find record";
return error;
}
else
{
error.ErrorID = 1;
error.ErrorMessage = "Error , cannot find this record in the Database";
return error;
}
}
public ReturnError ReturnLastLocationPN(string PhoneNumber)
{
DBConnection DBop = new DBConnection();
ReturnError error = new ReturnError();
string[] Phones = PhoneNumber.Split(':');
for (int k = 0; k < Phones.Length - 1; k++)
{
/// check if this account avilable
DataTable dataTable = new DataTable();
dataTable = DBop.NewConectionDLL.SelectDataSet("AdminPhones", " * ", "PhoneNumber like '%" + Phones[k] + "' and IsVisabale=1").Tables[0];
if ((dataTable != null) && (dataTable.Rows.Count > 0))
{
int PhoneID = (int)dataTable.Rows[0]["PhoneID"];
dataTable = DBop.NewConectionDLL.SelectDataSet("Tracking", " * ", "PhoneID=" + PhoneID + " and DateRecord=( select max(DateRecord) from Tracking where PhoneID=" + PhoneID + ")").Tables[0];
if ((dataTable != null) && (dataTable.Rows.Count > 0))
{
error.ErrorMessage = error.ErrorMessage + ":" + Phones[k];
}
}
} // for for
if (error.ErrorMessage != null)
{
// error.myTrack = mytrack1;
error.ErrorID = 2;
// error.ErrorMessage = "Greate you find record";
return error;
}
else
{
error.ErrorID = 1;
error.ErrorMessage = "Error ,we cannot find any friend for this phone";
return error;
}
}
public ReturnError ReturnLastLocationPNOne(string PhoneNumber)
{
DBConnection DBop = new DBConnection();
ReturnError error = new ReturnError();
/// check if this account avilable
DataTable dataTable = new DataTable();
dataTable = DBop.NewConectionDLL.SelectDataSet("AdminPhones", " * ", "PhoneNumber like '%" + PhoneNumber + "' and IsVisabale=1").Tables[0];
if ((dataTable != null) && (dataTable.Rows.Count > 0))
{
int PhoneID = (int)dataTable.Rows[0]["PhoneID"];
dataTable = DBop.NewConectionDLL.SelectDataSet("Tracking", " * ", "PhoneID=" + PhoneID + " and DateRecord=( select max(DateRecord) from Tracking where PhoneID=" + PhoneID + ")").Tables[0];
if ((dataTable != null) && (dataTable.Rows.Count > 0))
{
error.ErrorMessage = dataTable.Rows[0]["Latitude"].ToString() + ":" + dataTable.Rows[0]["longitude"].ToString() + ":" + dataTable.Rows[0]["DateRecord"].ToString();
error.ErrorID = 2;
// error.ErrorMessage = "Greate you find record";
return error;
}
else
{
error.ErrorID = 1;
error.ErrorMessage = "Error , cannot Find Records in this date Range";
return error;
}
}
else
{
error.ErrorID = 1;
error.ErrorMessage = "You Cannot access to this person location. may be he dont allow you to see his location or he didnot install (my phone locations)";
return error;
}
}
public ReturnError InsertPhoneNumberPrivicy( string PhoneMac, string PhoneNumber, Boolean IsVisabale)
{
DBConnection DBop = new DBConnection();
ReturnError error = new ReturnError();
/// check if this account avilable
DataTable dataTable = new DataTable();
dataTable = DBop.NewConectionDLL.SelectDataSet("AdminPhones", " * ", "PhoneMac like '" + PhoneMac + "' and PhoneNumber like '" + PhoneNumber +"'").Tables[0];
if ((dataTable != null) && (dataTable.Rows.Count > 0))
{
ColoumnParam[] Coloumns = new ColoumnParam[1];
Coloumns[0] = new ColoumnParam("IsVisabale", ColoumnType.Bit, IsVisabale);
if (DBop.NewConectionDLL.UpdateRow("AdminPhones", Coloumns, "PhoneMac like '" + PhoneMac + "' and PhoneNumber like '" + PhoneNumber + "'"))
{
error.ErrorID = 2;
error.ErrorMessage = "Greate you update the record";
return error;
}
else
{
error.ErrorID = 1;
error.ErrorMessage = "Error , cannot insert this record in the Database";
return error;
}
}
else
{
error.ErrorID = 1;
error.ErrorMessage = "Error , this phone is not registared in database";
return error;
}
}
public ReturnError OpenAccount(string FullName, string UserName, String Password, Boolean AccountType, string EmailAdrress)
{
DBConnection DBop = new DBConnection();
ReturnError error = new ReturnError();
/// check if empty data
if ((FullName.Length == 0) || (UserName.Length == 0) || (Password.Length == 0) || (EmailAdrress.Length == 0))
{
error.ErrorID = 1;
error.ErrorMessage = "please fill all your information";
return error;
}
/// check if this account avilable
DataTable dataTable = new DataTable();
dataTable = DBop.NewConectionDLL.SelectDataSet("Admins", " * ", "UserName like '" + UserName + "' or EmailAdrress like '" + EmailAdrress + "'").Tables[0];
if ((dataTable != null) && (dataTable.Rows.Count > 0))
{
error.ErrorID = 1;
error.ErrorMessage = "the user name or email address already used by other account try with different email or user name";
return error;
}
/// save new account
///
ColoumnParam[] Coloumns = new ColoumnParam[6];
Coloumns[0] = new ColoumnParam("FullName", ColoumnType.varchar50, FullName);
Coloumns[1] = new ColoumnParam("UserName", ColoumnType.varchar50, UserName);
Coloumns[2] = new ColoumnParam("Password", ColoumnType.varchar50, Password);
Coloumns[3] = new ColoumnParam("AccountType", ColoumnType.Bit, AccountType);
Coloumns[4] = new ColoumnParam("DateRegister", ColoumnType.DateTime, DateTime.Now);
Coloumns[5] = new ColoumnParam("EmailAdrress", ColoumnType.varchar50, EmailAdrress);
if (DBop.NewConectionDLL.InsertRow("Admins", Coloumns))
{
dataTable = DBop.NewConectionDLL.SelectDataSet("Admins", " * ", "UserName like '" + UserName + "'").Tables[0];
// dataTable = DBop.NewConectionDLL.SelectDataSet("Admins", " * " ).Tables[0];
/////send email to new account=========================================================
// System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage();
// mail.To.Add(EmailAdrress);
// mail.From = new MailAddress( "*****@*****.**" , "Email head", System.Text.Encoding.UTF8);
// mail.Subject = "Complete your final steps with my phone locations";
//mail.SubjectEncoding = System.Text.Encoding.UTF8;
// for (int i = 0; i < dataTable.Rows.Count; i++) {
try
{
string smtpAddress = "mail.alrubaye.com";
int portNumber = 25;
bool enableSSL = false;
string emailFrom = "*****@*****.**";
string password = "******";
string emailTo = EmailAdrress;
string subject = "Welcome in my phone location system";
string body = "Thank you for using my phone locations system \n" + " \n Your account now ready to be used. please setup this app from google play on your phone \n" + "https://play.google.com/store/apps/details?id=phonelocation.example.asuss550c.phonelocation" + "\nThen from setting login with your user name and password." + "And enjoy." + "Best regards,";
using (MailMessage mail = new MailMessage())
{
mail.From = new MailAddress(emailFrom);
mail.To.Add(emailTo);
mail.Subject = subject;
mail.Body = body;
mail.IsBodyHtml = true;
// Can set to false, if you are sending pure text.
// mail.Attachments.Add(new Attachment("C:\\SomeFile.txt"));
// mail.Attachments.Add(new Attachment("C:\\SomeZip.zip"));
using (SmtpClient smtp = new SmtpClient(smtpAddress, portNumber))
{
smtp.Credentials = new NetworkCredential(emailFrom, password);
smtp.EnableSsl = enableSSL;
smtp.Send(mail);
}
}
}
catch (Exception ex) { }
//} // for loop
error.ErrorID = 2;
error.AdminID = (int)dataTable.Rows[0]["UserID"];
error.ErrorMessage = "Greate you insert new record";
return error;
}
else
{
error.ErrorID = 1;
error.ErrorMessage = "Error , cannot insert this record in the Database";
return error;
}
}
