public async Task RegisterCustomerTest()
{
await CustomersModule.ExecuteCommandAsync(new RegisterNewCustomerCommand(
CustomerSampleData.Id,
CustomerSampleData.Email,
CustomerSampleData.Password,
CustomerSampleData.FirstName,
CustomerSampleData.LastName
));
var registration = await CustomersModule.ExecuteQueryAsync(new GetCustomerRegistrationQuery(
CustomerSampleData.Id
));
await CustomersModule.ExecuteCommandAsync(new ConfirmRegistrationCommand(
CustomerSampleData.Id,
registration.ActivationCode
));
var customer = await CustomersModule.ExecuteQueryAsync(
new GetCustomerQuery(CustomerSampleData.Id)
);
Assert.That(customer, Is.Not.Null);
Assert.That(customer.Id, Is.EqualTo(CustomerSampleData.Id));
Assert.That(customer.Email, Is.EqualTo(CustomerSampleData.Email));
Assert.That(customer.FirstName, Is.EqualTo(CustomerSampleData.FirstName));
Assert.That(customer.LastName, Is.EqualTo(CustomerSampleData.LastName));
Assert.That(customer.Password, Is.EqualTo(registration.Password));
}
public Task CheckReceivedMessage(CustomersModule customer)
{
//return Task.FromException(new NullReferenceException());
var tcs = new TaskCompletionSource <int>();
tcs.TrySetCanceled();
return(tcs.Task);
//return Task.FromResult(string.Join(",", customer));
}
void ICustomersRepository.Update(CustomersModule item)
{
var itemToUpdate = _customers.SingleOrDefault(r => r.MobilePhone == item.MobilePhone);
if (itemToUpdate != null)
{
itemToUpdate.ID = Guid.NewGuid().ToString();
itemToUpdate.Name = item.Name;
itemToUpdate.Email = item.Email;
itemToUpdate.MobilePhone = item.MobilePhone;
}
}
public async Task Authenticate_WithInvalidPassword_ShouldFail()
{
await CustomersModule.ExecuteCommandAsync(new CreateCustomerCommand(
CustomerSampleData.Id,
CustomerSampleData.Email,
CustomerSampleData.Password,
CustomerSampleData.FirstName,
CustomerSampleData.LastName
));
var authenticationResult = await CustomersModule.Authenticate(
CustomerSampleData.Email,
"invalidPass1237"
);
Assert.That(authenticationResult.Authenticated, Is.False);
Assert.That(authenticationResult.Error, Is.EqualTo("Invalid credentials"));
}
public async Task Authenticate_WithValidCredentials_ShouldSucceed()
{
await CustomersModule.ExecuteCommandAsync(new CreateCustomerCommand(
CustomerSampleData.Id,
CustomerSampleData.Email,
CustomerSampleData.Password,
CustomerSampleData.FirstName,
CustomerSampleData.LastName
));
var authenticationResult = await CustomersModule.Authenticate(
CustomerSampleData.Email,
CustomerSampleData.Password
);
Assert.That(authenticationResult.Authenticated, Is.True);
Assert.That(authenticationResult.Customer, Is.Not.Null);
Assert.That(authenticationResult.Customer.Id, Is.EqualTo(CustomerSampleData.Id));
}
public async Task CreateCustomerTest()
{
await CustomersModule.ExecuteCommandAsync(new CreateCustomerCommand(
CustomerSampleData.Id,
CustomerSampleData.Email,
CustomerSampleData.Password,
CustomerSampleData.FirstName,
CustomerSampleData.LastName
));
var customer = await CustomersModule.ExecuteQueryAsync(
new GetCustomerQuery(CustomerSampleData.Id)
);
Assert.That(customer, Is.Not.Null);
Assert.That(customer.Id, Is.EqualTo(CustomerSampleData.Id));
Assert.That(customer.Email, Is.EqualTo(CustomerSampleData.Email));
Assert.That(customer.FirstName, Is.EqualTo(CustomerSampleData.FirstName));
Assert.That(customer.LastName, Is.EqualTo(CustomerSampleData.LastName));
}
public CustomController()
{
// List<CustomersModule> customerlist = new List<CustomersModule>();
IList <CustomersModule> customerlist = new List <CustomersModule>();
IList <Staff> stafflist = new List <Staff>();
IList <ProjectModule> projectlist = new List <ProjectModule>();
IList <ProjectModule> projectlist2 = new List <ProjectModule>();
IList <TaskManModule> taskmode = new List <TaskManModule>();
IList <CategoryModule> categorylist = new List <CategoryModule>();
IList <TaskManModule> tasklist = new List <TaskManModule>();
IList <TaskManModule> timesheet = new List <TaskManModule>();
IList <TaskManModule> taskplanner = new List <TaskManModule>();
string conString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
//-------------------------------
string query = "Select * from [dbo].[customers]";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
CustomersModule sitems = new CustomersModule();
sitems.id = Convert.ToString(dataReader["id"]);
sitems.name = Convert.ToString(dataReader["name"]);
sitems.code = Convert.ToString(dataReader["code"]);
customerlist.Add(sitems);
}
// sitems.File_file = termsList.ToArray();
//-------------------------------
query = "Select * from [dbo].[staff]";
SqlCommand cmd2 = new SqlCommand(query, con);
SqlDataReader dataReader2 = cmd2.ExecuteReader();
while (dataReader2.Read())
{
Staff sitems = new Staff();
sitems.id = Convert.ToString(dataReader2["id"]);
sitems.fullname = Convert.ToString(dataReader2["fullname"]) + " " + Convert.ToString(dataReader2["lastname"]);
sitems.alias = Convert.ToString(dataReader2["alias"]);
stafflist.Add(sitems);
}
//-------------------------------
query = "Select * from [dbo].[project]";
SqlCommand cmd3 = new SqlCommand(query, con);
SqlDataReader dataReader3 = cmd3.ExecuteReader();
while (dataReader3.Read())
{
ProjectModule sitems = new ProjectModule();
sitems.id = Convert.ToString(dataReader3["id"]);
sitems.name = Convert.ToString(dataReader3["name"]);
sitems.code = Convert.ToString(dataReader3["code"]);
sitems.custid = Convert.ToString(dataReader3["custid"]);
projectlist.Add(sitems);
}
//------------------------------------------------
//string query2 = "Select * from [dbo].[project] WHERE custid=" + Request.QueryString["customerid"].ToString();
//SqlCommand cmd9 = new SqlCommand(query2, con);
//SqlDataReader dataReader9 = cmd9.ExecuteReader();
//while (dataReader9.Read())
//{
// ProjectModule sitems = new ProjectModule();
// sitems.id = Convert.ToString(dataReader9["id"]);
// sitems.name = Convert.ToString(dataReader9["name"]);
// sitems.code = Convert.ToString(dataReader9["code"]);
// sitems.custid = Convert.ToString(dataReader9["custid"]);
// projectlist2.Add(sitems);
//}
//-------------------------------
query = "Select id, description from [dbo].[taskman]";
SqlCommand cmd5 = new SqlCommand(query, con);
SqlDataReader dataReader5 = cmd5.ExecuteReader();
while (dataReader5.Read())
{
TaskManModule sitems = new TaskManModule();
sitems.id = Convert.ToInt16(dataReader5["id"]);
sitems.description = Convert.ToString(dataReader5["description"]);
tasklist.Add(sitems);
}
query = "Select id, projectid, status, code, name, description, datecreated from [dbo].[categories]";
SqlCommand cmd6 = new SqlCommand(query, con);
SqlDataReader dataReader6 = cmd6.ExecuteReader();
while (dataReader6.Read())
{
CategoryModule cat = new CategoryModule();
cat.id = Convert.ToInt16(dataReader6["id"].ToString());
cat.projectid = Convert.ToInt16(dataReader6["projectid"].ToString());
cat.code = Convert.ToString(dataReader6["code"]);
cat.name = Convert.ToString(dataReader6["name"]);
cat.description = Convert.ToString(dataReader6["description"]);
cat.status = Convert.ToString(dataReader6["status"]);
cat.datecreated = Convert.ToDateTime(dataReader6["datecreated"]);
categorylist.Add(cat);
}
//--------------------------------------------------------------------------------
query = " SELECT T.id as id, C.code as cust,P.code as proj, T.description as descr, T.dev as dev, T.note as note, (Select fullname from[timesheet].[dbo].[staff] where id = T.resource) as resc, T.pr as pr,T.start as start,T.finish as finish, T.stat as stat, T.esthours as est,T.ddate as ddate from[timesheet].[dbo].[taskman] as T,[timesheet].[dbo].[customers] as C,[timesheet].[dbo].[project] as P,[timesheet].[dbo].[staff] as S WHERE C.id=T.customerid AND P.id=T.projectid AND T.resource=S.id ORDER BY T.id DESC";
SqlCommand cmd4 = new SqlCommand(query, con);
SqlDataReader dataReader4 = cmd4.ExecuteReader();
if (dataReader4.HasRows)
{
while (dataReader4.Read())
{
TaskManModule sitems = new TaskManModule();
sitems.id = Convert.ToInt16(dataReader4["id"]);
sitems.cust = Convert.ToString(dataReader4["cust"]);
sitems.proj = Convert.ToString(dataReader4["proj"]);
sitems.description = Convert.ToString(dataReader4["descr"]);
taskmode.Add(sitems);
}
}
else
{
TaskManModule sitems = new TaskManModule();
sitems.id = Convert.ToInt16("0");
sitems.cust = Convert.ToString("no");
sitems.proj = Convert.ToString("no");
sitems.description = Convert.ToString("no");
taskmode.Add(sitems);
}
string queryday = "Select * from [dbo].[tasklist]";
SqlCommand cmdd = new SqlCommand(queryday, con);
SqlDataReader dataReaderd = cmdd.ExecuteReader();
while (dataReaderd.Read())
{
TaskManModule sitems = new TaskManModule();
string edate = Convert.ToString(dataReaderd["edate"]);
sitems.ddate = String.Format("{0:MM/dd/yyyy}", edate);
timesheet.Add(sitems);
}
con.Close();
}
// Now store it in your model
ViewData["CustomerList"] = customerlist;
ViewData["CustomerList2"] = customerlist;
ViewData["StaffList"] = stafflist;
ViewData["ProjectList"] = projectlist;
// ViewData["ProjectList2"] = projectlist2;
ViewData["Taskman"] = taskmode;
ViewData["CategoryList"] = categorylist;
ViewData["TaskList"] = tasklist;
ViewData["SystemDate"] = DateTime.Now.ToString("MM/dd/yyyy");
ViewData["dataDates"] = timesheet;
// date range -------------- here
DayOfWeek firstWeekDay = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.FirstDayOfWeek;
DateTime startDateOfWeek = DateTime.Now;
while (startDateOfWeek.DayOfWeek != firstWeekDay)
{
startDateOfWeek = startDateOfWeek.AddDays(-1d);
}
DateTime endDateOfWeek = startDateOfWeek.AddDays(6d);
//return checkDate >= startDateOfWeek && checkDate <= endDateOfWeek;
ViewData["begin"] = startDateOfWeek.ToString("MM/dd/yyyy");
ViewData["end"] = endDateOfWeek.ToString("MM/dd/yyyy");
// end of date range
}
void ICustomersRepository.Add(CustomersModule item)
{
_customers.Add(item);
}
