/// <summary>
/// Validates this instance.
/// </summary>
/// <remarks>
/// <para>
/// Ensures that <see cref="MobileNumber" /> is not null, empty string or only whitespace.
/// Also ensure no property is larger than it's maximum allowed length (see individual property notes for details).
/// Also ensures all base properties are valid, see <see cref="RequestBase.Validate"/>.
/// </para>
/// </remarks>
public override void Validate()
{
MobileNumber.GuardNullOrWhiteSpace("request", nameof(MobileNumber));
MobileNumber.GuardLength("request", nameof(MobileNumber), 0, 10);
base.Validate();
}
public ActionResult UpdateSCPending(int?id)
{
SeniorCitizen c = db.SeniorCitizens.FirstOrDefault(s => s.SeniorCitizenId == id);
if (c == null)
{
return(HttpNotFound());
}
else
{
c.Status = "Pending";
db.SaveChanges();
#region SMS NOTIF
if (c.Client.MobileNumbers != null)
{
MobileNumber mb = c.Client.MobileNumbers.FirstOrDefault(m => m.IsDisabled == false && m.Token != null);
if (mb != null)
{
try
{
SMS(mb.MobileNo, "Hello " + c.Client.GivenName + ", your Senior Citizen Application is now Pending.");
}
catch (Exception e)
{
Trace.TraceInformation(e.Message);
}
}
}
#endregion
return(RedirectToAction("Index", new { }));
}
}
private void SetValues()
{
try
{
query = "select * from PARENTS where [ParentId]=" + id;
cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
fatherName = (string)reader[1];
motherName = (string)reader[2];
fCNIC = (string)reader[3];
homeAddress = (string)reader[4];
fPhone = new MobileNumber((string)reader[5], (string)reader[6], (string)reader[7]);
mPhone = new MobileNumber((string)reader[8], (string)reader[9], (string)reader[10]);
emergencyContact = (string)reader[11];
elgibilityThreshold = (int)reader[12];
}
con.Close();
}
catch (SqlException ex)
{
Exception e = new Exception("Error Occured in Database processing. CodeIndex:102", ex);
throw e;
}
}
public void Patch(MobileNumber mobileNum)
{
MobileNumber dbMobileNum = _mobileNumberRepo.findOneBy(MobileNumber => MobileNumber.id.Equals(mobileNum.id));
dbMobileNum.number = mobileNum.number;
_mobileNumberRepo.Save();
}
protected void SetValues()
{
try
{
query = "SELECT * FROM STAFF WHERE StaffId=" + id;
cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
name = (string)reader[1];
cnic = (string)reader[2];
address = (string)reader[3];
number = new MobileNumber((string)reader[4], (string)reader[5], (string)reader[6]);
salary = (decimal)reader[7];
gender = (Genders)Convert.ToInt16(reader[8]);
joiningDate = (DateTime)reader[9];
}
con.Close();
}
catch (SqlException ex)
{
Exception e = new Exception("Error Occured in Database processing. CodeIndex:225", ex);
throw e;
}
}
public ActionResult Receive(string access_token, string subscriber_number)
{
string subscriber_number_p = "0" + subscriber_number;
MobileNumber mobile_no = db.MobileNumbers.Include(m => m.Person).FirstOrDefault(n => n.MobileNo == subscriber_number_p);
if (mobile_no != null)
{
mobile_no.Token = access_token;
db.SaveChanges();
Sms sms = new Sms(short_code, access_token);
dynamic response = sms
.SetReceiverAddress("+63" + subscriber_number)
.SetMessage("Hello, " + mobile_no.Person.GivenName + " from " + mobile_no.Person.Household.Name + " household. Your 4P's inquiry subscription is now verified. You could now inquire through text.")
.SendMessage()
.GetDynamicResponse();
Trace.TraceInformation(subscriber_number);
}
else
{
Trace.TraceInformation("mobile num doesn't exist");
}
return(null);
}
public ActionResult UpdatePWDRejected(int?id)
{
Pwd c = db.Pwds.FirstOrDefault(s => s.PwdId == id);
if (c == null)
{
return(HttpNotFound());
}
else
{
c.Status = "Rejected";
db.SaveChanges();
#region SMS NOTIF
if (c.Client.MobileNumbers != null)
{
MobileNumber mb = c.Client.MobileNumbers.FirstOrDefault(m => m.IsDisabled == false && m.Token != null);
if (mb != null)
{
try
{
SMS(mb.MobileNo, "Hello " + c.Client.GivenName + ", your PWD Application has been rejected.");
}
catch (Exception e)
{
Trace.TraceInformation(e.Message);
}
}
}
#endregion
return(RedirectToAction("Index", new { }));
}
}
public ActionResult UpdateSPApproved(int?id)
{
SoloParent c = db.SoloParents.FirstOrDefault(s => s.SoloParentId == id);
if (c == null)
{
return(HttpNotFound());
}
else
{
c.Status = "Approved";
db.SaveChanges();
#region SMS NOTIF
if (c.Client.MobileNumbers != null)
{
MobileNumber mb = c.Client.MobileNumbers.FirstOrDefault(m => m.IsDisabled == false && m.Token != null);
if (mb != null)
{
try
{
SMS(mb.MobileNo, "Hello " + c.Client.GivenName + ", your Solo Parent Application has been approved. Please wait for the updates regarding release date.");
}
catch (Exception e)
{
Trace.TraceInformation(e.Message);
}
}
}
#endregion
return(RedirectToAction("Index", new { }));
}
}
public void PopulatePageAndSubmit()
{
FirstName.SendKeys("Miller");
LastName.SendKeys("John");
UserEmail.SendKeys("*****@*****.**");
Gender.Click();
MobileNumber.SendKeys("0751123456");
DateOfBirth.Click();
Month.Click();
Year.Click();
Day.Click();
Subjects.SendKeys("Test subjects");
Thread.Sleep(2000);
Hobbies.Click();
((IJavaScriptExecutor)_driver).ExecuteScript("arguments[0].scrollIntoView(true);", Picture);
//Thread.Sleep(5000);
//Picture.Click();
CurrentAddress.SendKeys("Str. 13 Dec");
Thread.Sleep(2000);
StateDropDown.Click();
StateOption.Click();
CityDropDown.Click();
CityOption.Click();
Submit.Click();
}
private ActionResult SendSMS(string mobile_number, string message)
{
MobileNumber mb = db.MobileNumbers.FirstOrDefault(m => m.MobileNo == mobile_number);
string access_token = mb.Token;
Trace.TraceInformation("Token: " + access_token);
if (access_token != null)
{
try
{
Sms sms = new Sms(short_code, access_token);
// mobile number argument is with format 09, convert it to +639
string globe_format_receiver = "+63" + mobile_number.Substring(1);
dynamic response = sms.SetReceiverAddress(globe_format_receiver)
.SetMessage(message)
.SendMessage()
.GetDynamicResponse();
Trace.TraceInformation("Sent message; " + message);
}
catch (Exception e)
{
Trace.TraceInformation("Unable to send message to " + mobile_number + ". Error; " + e.Message);
}
}
return(null);
}
private void updateMobileNumbers(List <string> clientMobileNumbers, SimContact contact)
{
List <string> contactNumbers = new List <string>();
List <MobileNumber> numbersToDelete = new List <MobileNumber>();
foreach (MobileNumber mobileNumber in contact.MobileNumbers)
{
contactNumbers.Add(mobileNumber.number);
if (!clientMobileNumbers.Contains(mobileNumber.number))
{
numbersToDelete.Add(mobileNumber);
}
}
foreach (MobileNumber mobileNumber in numbersToDelete)
{
contact.removeMobileNumber(mobileNumber);
_mobileNumberRepo.Delete(mobileNumber);
}
foreach (string clientNumber in clientMobileNumbers)
{
if (!contactNumbers.Contains(clientNumber))
{
MobileNumber newMobileNumber = new MobileNumber()
{
number = clientNumber
};
_mobileNumberRepo.Create(newMobileNumber);
contact.addMobileNumber(newMobileNumber);
}
}
_mobileNumberRepo.Save();
}
public ActionResult Reply()
{
string message = Request.Form["Message"];
string inquiryId = Request.Form["InquiryId"];
Inquiry inquiry = db.Inquiries.Find(Convert.ToInt16(inquiryId));
#region SMS NOTIF
if (inquiry.Client.MobileNumbers != null)
{
MobileNumber mb = inquiry.Client.MobileNumbers.FirstOrDefault(m => m.IsDisabled == false && m.Token != null);
if (mb != null)
{
try
{
SMS(mb.MobileNo, message);
}
catch (Exception e)
{
Trace.TraceInformation(e.Message);
}
}
}
#endregion
return(RedirectToAction("Index", new { id = inquiry.ClientId }));
}
public Teacher(string name, string cnic, string address, MobileNumber number, decimal salary, Genders gender, string connectionString)
{
con = new SqlConnection(connectionString);
try
{
query = "INSERT INTO [STAFF] ([Name] ,[CNIC] ,[Address] ,[MCountryCode] ,[MCompanyCode] ,[MNumber] ,[Salary], [Gender], [JoiningDate]) VALUES ('" + name + "' ,'" + cnic + "' ,'" + address + "' ,'" + number.CountryCode + "' ,'" + number.CompanyCode + "' ,'" + number.Number + "' ," + salary + " ," + (int)gender + ", " + DateTime.Now + ");SELECT MAX(StaffId) FROM STAFF;";
cmd = new SqlCommand(query, con);
con.Open();
id = (int)cmd.ExecuteScalar();
query = "INSERT INTO [TEACHING_STAFF] ([StaffId]) VALUES (" + id + ")";
cmd = new SqlCommand(query, con);
cmd.ExecuteNonQuery();
con.Close();
}
catch (SqlException ex)
{
if (ex.Number == 2601)
{
throw new Exception("Field CNIC exists. CodeIndex:143", ex);
}
Exception e = new Exception("Error Occured in Database processing. CodeIndex:240", ex);
throw e;
}
this.name = name;
this.number = number;
this.salary = salary;
this.address = address;
this.cnic = cnic;
}
[InlineData(31203690388, false)] // Netherlands Landline
public void MobileValidationTest(ulong mobile, bool expectedResult)
{
bool testResult = MobileNumber.IsValidMobileNumber(mobile);
Output.WriteLine($"Tested Mobile: {mobile} => Test result: {testResult} | Expected result: {expectedResult} ");
Assert.Equal(expectedResult, testResult);
}
public ActionResult Receive(string access_token, string subscriber_number)
{
string subscriber_number_p = "0" + subscriber_number;
MobileNumber mobile_no = db.MobileNumbers.FirstOrDefault(n => n.MobileNo == subscriber_number_p);
if (mobile_no != null)
{
mobile_no.Token = access_token;
db.SaveChanges();
Sms sms = new Sms(short_code, access_token);
dynamic response = sms
.SetReceiverAddress("+63" + subscriber_number)
.SetMessage("Hello, " + mobile_no.Client.GivenName + "Your MSWD subscription is now verified. You could now inquire through text. Send 'learn more' for list of keywords.")
.SendMessage()
.GetDynamicResponse();
Trace.TraceInformation(subscriber_number);
}
else
{
Trace.TraceInformation("mobile num doesn't exist");
}
return(null);
}
public ActionResult UpdatePWDHomeVisit(int?id)
{
Pwd c = db.Pwds.FirstOrDefault(s => s.PwdId == id);
if (c == null)
{
return(HttpNotFound());
}
else
{
c.Status = "For Home Visit";
db.SaveChanges();
#region SMS NOTIF
if (c.Client.MobileNumbers != null)
{
MobileNumber mb = c.Client.MobileNumbers.FirstOrDefault(m => m.IsDisabled == false && m.Token != null);
if (mb != null)
{
try
{
SMS(mb.MobileNo, "Hello " + c.Client.GivenName + ", your PWD Application status is now For Home Visit. Please wait for the updates regarding home visit date.");
}
catch (Exception e)
{
Trace.TraceInformation(e.Message);
}
}
}
#endregion
return(RedirectToAction("Index", new { }));
}
}
public ActionResult DeleteConfirmed(int id)
{
MobileNumber mobileNumber = db.MobileNumbers.Find(id);
db.MobileNumbers.Remove(mobileNumber);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public AirportTaxisPage StepEnterMobileNumber(string mobileNumber)
{
MobileNumber.Clear();
Thread.Sleep(1000);
MobileNumber.SendKeys(mobileNumber);
Thread.Sleep(2000);
return(this);
}
public MobileAccountEventsArgs(MobileNumber caller, MobileNumber receiver, string message, string text = null)
{
CallingNumber = caller;
CalledNumber = receiver;
Message = message;
if (text != null)
{
Text = text;
}
}
public string GetPhoneNumber()
{
if (!String.IsNullOrEmpty(MobileNumber))
{
return
(MobileNumber.Trim().Replace("(", "").Replace(")", "").Replace("-", "").Replace(" ", "").Replace("+", "").Replace(".", ""));
}
return(string.Empty);
}
public SimContact getContactByMobileNumber(string number)
{
MobileNumber mobileNum = _mobileNumberRepo.findByNumber(number);
if (mobileNum == null || mobileNum.id <= -1)
{
return(null);
}
return(mobileNum.contact);
}
public ActionResult Edit([Bind(Include = "MobileNumberId,MobileNo,Token,DateTimeCreated,IsDisabled,PersonId")] MobileNumber mobileNumber)
{
if (ModelState.IsValid)
{
db.Entry(mobileNumber).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PersonId = new SelectList(db.Persons, "PersonId", "GivenName", mobileNumber.PersonId);
return(View(mobileNumber));
}
/// <summary>
/// Returns true if HoursAssignmentPerson instances are equal
/// </summary>
/// <param name="other">Instance of HoursAssignmentPerson to be compared</param>
/// <returns>Boolean</returns>
public bool Equals(HoursAssignmentPerson other)
{
if (other is null)
{
return(false);
}
if (ReferenceEquals(this, other))
{
return(true);
}
return
((
StaffNumber == other.StaffNumber ||
StaffNumber != null &&
StaffNumber.Equals(other.StaffNumber)
) &&
(
Forenames == other.Forenames ||
Forenames != null &&
Forenames.Equals(other.Forenames)
) &&
(
Surname == other.Surname ||
Surname != null &&
Surname.Equals(other.Surname)
) &&
(
MobileNumber == other.MobileNumber ||
MobileNumber != null &&
MobileNumber.Equals(other.MobileNumber)
) &&
(
Grade == other.Grade ||
Grade != null &&
Grade.Equals(other.Grade)
) &&
(
GradeType == other.GradeType ||
GradeType != null &&
GradeType.Equals(other.GradeType)
) &&
(
GradeTypeCategory == other.GradeTypeCategory ||
GradeTypeCategory != null &&
GradeTypeCategory.Equals(other.GradeTypeCategory)
) &&
(
WTE == other.WTE ||
WTE.Equals(other.WTE)
));
}
public ActionResult Create([Bind(Include = "MobileNumberId,MobileNo,Token,IsDisabled,ClientId,DateCreated")] MobileNumber mobileNumber)
{
if (ModelState.IsValid)
{
db.MobileNumbers.Add(mobileNumber);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ClientId = new SelectList(db.Clients, "ClientId", "GivenName", mobileNumber.ClientId);
return(View(mobileNumber));
}
public ActionResult Post(SendSms sendSms)
{
try
{
var mobileNumber = MobileNumber.Parse(sendSms.MobileNumber);
this.SmsService.Send(mobileNumber, sendSms.Message);
return(new OkResult());
}
catch (ArgumentException)
{
return(new BadRequestResult());
}
}
public override int GetHashCode()
{
int hash = 1;
if (Surname.Length != 0)
{
hash ^= Surname.GetHashCode();
}
if (Forename.Length != 0)
{
hash ^= Forename.GetHashCode();
}
hash ^= otherNames_.GetHashCode();
if (Salutation.Length != 0)
{
hash ^= Salutation.GetHashCode();
}
if (Suffix.Length != 0)
{
hash ^= Suffix.GetHashCode();
}
if (DisplayName.Length != 0)
{
hash ^= DisplayName.GetHashCode();
}
if (Gender != global::PKIo.Gender.NotKnown)
{
hash ^= Gender.GetHashCode();
}
if (dateOfBirth_ != null)
{
hash ^= DateOfBirth.GetHashCode();
}
if (EmailAddress.Length != 0)
{
hash ^= EmailAddress.GetHashCode();
}
if (MobileNumber.Length != 0)
{
hash ^= MobileNumber.GetHashCode();
}
if (ExternalId.Length != 0)
{
hash ^= ExternalId.GetHashCode();
}
if (_unknownFields != null)
{
hash ^= _unknownFields.GetHashCode();
}
return(hash);
}
public ActionResult Create([Bind(Include = "MobileNumberId,MobileNo,Token,DateTimeCreated,IsDisabled,PersonId")] MobileNumber mobileNumber)
{
mobileNumber.DateTimeCreated = DateTime.UtcNow.AddHours(8);
mobileNumber.Token = null;
if (ModelState.IsValid)
{
db.MobileNumbers.Add(mobileNumber);
db.SaveChanges();
return(RedirectToAction("ClientIndex", new { id = mobileNumber.PersonId }));
}
return(View(mobileNumber));
}
// GET: MobileNumbers/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MobileNumber mobileNumber = db.MobileNumbers.Find(id);
if (mobileNumber == null)
{
return(HttpNotFound());
}
return(View(mobileNumber));
}
// GET: MobileNumbers/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MobileNumber mobileNumber = db.MobileNumbers.Find(id);
if (mobileNumber == null)
{
return(HttpNotFound());
}
ViewBag.PersonId = new SelectList(db.Persons, "PersonId", "GivenName", mobileNumber.PersonId);
return(View(mobileNumber));
}
private TelecomEnum GetTelecom()
{
Dictionary <string, TelecomEnum> mobilePrefixes = new Dictionary <string, TelecomEnum>();
mobilePrefixes.Add("980", TelecomEnum.Ncell);
mobilePrefixes.Add("986", TelecomEnum.Ntc);
if (!String.IsNullOrWhiteSpace(MobileNumber) && MobileNumber.Length >= 3)
{
if (mobilePrefixes.ContainsKey(MobileNumber.Substring(0, 3)))
{
return(mobilePrefixes[MobileNumber.Substring(0, 3)]);
}
}
return(TelecomEnum.None);
}
