protected override void RefreshData()
{
DiscountFactory discountFactory = new DiscountFactory();
DiscountGateway <DiscountCard> dg = (DiscountGateway <DiscountCard>)discountFactory.GetCard();
Collection <DiscountCard> cards = dg.Select();
Collection <ExtendedCard> ecards = new Collection <ExtendedCard>();
foreach (DiscountCard dc in cards)
{
ExtendedCard ec = new ExtendedCard();
ec.CardId = dc.RecordId;
ec.Credit = dc.Credit;
if (dc.ClientId != null)
{
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
Client c = cg.Select((int)dc.ClientId);
ec.Name = c.Name + " " + c.Surname;
ec.ClientId = (int)dc.ClientId;
}
ecards.Add(ec);
}
BindingList <ExtendedCard> bindingList = new BindingList <ExtendedCard>(ecards);
cardsGrid.AutoGenerateColumns = false;
cardsGrid.DataSource = bindingList;
}
public void firstInitialize()
{
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
TrainingFactory trainingFactory = new TrainingFactory();
TrainingGateway <Training> tg = (TrainingGateway <Training>)trainingFactory.GetTraining();
DiscountFactory discountFactory = new DiscountFactory();
DiscountGateway <DiscountCard> dg = (DiscountGateway <DiscountCard>)discountFactory.GetCard();
PurchaseFactory purchaseFactory = new PurchaseFactory();
PurchaseGateway <Purchase> pg = (PurchaseGateway <Purchase>)purchaseFactory.GetPurchase();
TicketFactory ticketFactory = new TicketFactory();
TicketGateway <Ticket> ticketg = (TicketGateway <Ticket>)ticketFactory.GetTicket();
Client client = cg.Select(tg.SelectLast().ClientId);
clientName.Text = client.ToString();
if (client.CardId != null)
{
int toSetId = client.CardId ?? default(int);
card = dg.Select(toSetId);
}
Ticket t = ticketg.Select(pg.SelectLast(card.RecordId).TicketId);
ticketType.Text = t.Type;
credit.Text = card.Credit.ToString();
}
/// <summary>
/// Fill up client drop down list
/// </summary>
private void FillClientDropmDownList()
{
try
{
//ClientGateway ClientGatewayObject = new ClientGateway();
//clientNameDropDownList.DataSource = ClientGatewayObject.GetAllClient();
ClientGateway ClientGatewayObject = new ClientGateway();
clientNameDropDownList.DataSource = ClientGatewayObject.GetClientTable();
clientNameDropDownList.DataTextField = "client_CompanyName";
clientNameDropDownList.DataValueField = "client_ID";
clientNameDropDownList.DataBind();
//if (ClientGatewayObject.GetAllClient().Count == 0)
if (ClientGatewayObject.GetClientTable().Rows.Count == 0)
{
errorLabel.Text = "No client is created.";
}
}
catch (SqlException sqlExceptionObj)
{
errorLabel.Text = sqlExceptionObj.Message;
}
catch (Exception exceptionObj)
{
errorLabel.Text = exceptionObj.Message;
}
}
public IActionResult Client()
{
ClientGateway clientGateway = new ClientGateway();
ClientCollection clients = clientGateway.GetClients();
return(View("Client", clients));
}
public void GivenNullResponse_ThenResponseIsNotValid()
{
//Act
var actual = new ClientGateway().HasErrorOccured(null);
//Assert
Assert.IsTrue(actual);
}
public IActionResult Index()
{
ViewData["CompanyName"] = "Document Doctors Ltd.";
ClientGateway clientGateway = new ClientGateway();
ClientCollection clients = clientGateway.GetClients();
return(View("Index", clients));
}
protected void saveFavouriteLockerClick(object sender, EventArgs e)
{
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
client.Favourite_locker = lockers[lockerDropdown.SelectedIndex].RecordId;
cg.Update(client);
Response.Redirect("~/ChangeProfile.aspx");
}
public ClientService()
{
_gateway = new ClientGateway();
var mapperConfig = new MapperConfiguration(cfg => {
cfg.CreateMap <Client, ClientDto>();
cfg.CreateMap <ClientDataSetResponse, Client>();
});
_mapper = mapperConfig.CreateMapper();
}
protected override void RefreshData()
{
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
Collection <ExtendedClient> clients = cg.SelectAll();
BindingList <ExtendedClient> bindingList = new BindingList <ExtendedClient>(clients);
clientsGrid.AutoGenerateColumns = false;
clientsGrid.DataSource = bindingList;
}
public HiddenOptionsDto ShowTrivia(AppName appName, string popUpTitle, DateTime lastPopUpDateTime, int popUpCountToday, int timeOutInMilliSeconds, string optionsName)
{
HiddenOptionsDto hiddenOptionsDto = null;
var clientGateway = new ClientGateway();
var gatewayResponse = clientGateway.GetGatewayResponse(appName, timeOutInMilliSeconds, CommonConstants.TimeOutInMilliSecondsOptionLabel, optionsName);
var somethingToShow = false;
var triviaDialogDto = new TriviaDialogDto
{
AppName = appName,
OptionsName = optionsName,
PopUpTitle = popUpTitle
};
if (!string.IsNullOrEmpty(gatewayResponse.ErrorDetails))
{
triviaDialogDto.ErrorDetails = gatewayResponse.ErrorDetails;
somethingToShow = !string.IsNullOrEmpty(triviaDialogDto.ErrorDetails);
}
else
{
switch (appName)
{
case AppName.Jeopardy:
var gatewayResponseJeopardy = (GatewayResponseJeopardy)gatewayResponse;
triviaDialogDto.Answer = "A. " + gatewayResponseJeopardy.Answer;
triviaDialogDto.Question = "Q. " + gatewayResponseJeopardy.Question;
somethingToShow = !string.IsNullOrEmpty(triviaDialogDto.Question);
break;
case AppName.NumericTrivia:
var gatewayResponseNumeric = (GatewayResponseNumericTrivia)gatewayResponse;
triviaDialogDto.Fact = gatewayResponseNumeric.NumericFact;
somethingToShow = !string.IsNullOrEmpty(triviaDialogDto.Fact);
break;
case AppName.TrumpQuotes:
var gatewayResponseTrump = (GatewayResponseTrumpQuotes)gatewayResponse;
triviaDialogDto.HyperLinkUri = gatewayResponseTrump.HyperLinkUri;
triviaDialogDto.Quotation = gatewayResponseTrump.TrumpQuote;
triviaDialogDto.Attribution = gatewayResponseTrump.QuotationAuthor + spacer + gatewayResponseTrump.QuotationDate + spacer;
somethingToShow = !string.IsNullOrEmpty(triviaDialogDto.Quotation);
break;
}
}
if (somethingToShow)
{
DisplayPopUpMessage(triviaDialogDto);
hiddenOptionsDto = GetHiddenOptionsDto(lastPopUpDateTime, popUpCountToday);
}
return(hiddenOptionsDto);
}
public void GivenEmptyResponse_ThenResponseIsNotValid()
{
//Arrange
IRestResponse response = new RestResponse();
//Act
var actual = new ClientGateway().HasErrorOccured(response);
//Assert
Assert.IsFalse(actual);
}
protected void Page_Load(object sender, EventArgs e)
{
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
if (Session["ID"] == null)
{
Response.Redirect("~/Login.aspx");
}
trainings = cg.SelectTrainings(int.Parse(Session["ID"].ToString()));
if (Session["filter"] != null)
{
Session["filter"] = null;
const string FMT = "O";
DateTime from = DateTime.ParseExact(Session["dateFrom"].ToString(), FMT, CultureInfo.InvariantCulture);
DateTime to = DateTime.ParseExact(Session["dateTo"].ToString(), FMT, CultureInfo.InvariantCulture);
foreach (ClientTraining ct in trainings)
{
if (ct.TimeTo != null)
{
DateTime dateTimeTo = (DateTime)ct.TimeTo;
if (DateTime.Compare(ct.TimeFrom, from) > 0 && DateTime.Compare(dateTimeTo, to) < 0)
{
filteredTrainings.Add(ct);
}
}
}
filtered = true;
filterLabel.Style.Add("display", "inline-block");
filterLabel.Text = "Filter: " + Session["dateFrom"].ToString().Substring(0, 10) + " - " + Session["dateTo"].ToString().Substring(0, 10);
}
else
{
filterLabel.Style.Add("display", "none");
}
if (!IsPostBack)
{
if (filtered)
{
trainingsGridView.DataSource = filteredTrainings;
trainingsGridView.DataBind();
}
else
{
trainingsGridView.DataSource = trainings;
trainingsGridView.DataBind();
}
}
}
public void GivenErrorExceptionResponse_ThenResponseIsNotValid()
{
//Arrange
IRestResponse response = new RestResponse {
ErrorException = new ApplicationException()
};
//Act
var actual = new ClientGateway().HasErrorOccured(response);
//Assert
Assert.IsTrue(actual);
}
public void GivenErrorMessageResponse_ThenResponseIsNotValid()
{
//Arrange
IRestResponse response = new RestResponse {
ErrorMessage = "any"
};
//Act
var actual = new ClientGateway().HasErrorOccured(response);
//Assert
Assert.IsTrue(actual);
}
public void GivenPopulatedResponse_ThenResponseIsValid()
{
//Arrange
IRestResponse response = new RestResponse {
Content = "any"
};
//Act
var actual = new ClientGateway().HasErrorOccured(response);
//Assert
Assert.IsFalse(actual);
}
protected void profileConfirmButton_Click1(object sender, EventArgs e)
{
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
bool toInsert = true;
string errorMessage = "";
if (!string.IsNullOrWhiteSpace(nameElement.Text))
{
newClient.Name = nameElement.Text;
}
if (!string.IsNullOrWhiteSpace(surnameElement.Text))
{
newClient.Surname = surnameElement.Text;
}
if (!string.IsNullOrWhiteSpace(mailElement.Text))
{
if (Functions.IsValidEmail(mailElement.Text))
{
newClient.Mail = mailElement.Text;
}
else
{
toInsert = false;
errorMessage = "Entered Mail is invalid.";
}
}
if (!string.IsNullOrWhiteSpace(password1.Text) && !string.IsNullOrWhiteSpace(password2.Text))
{
if (password1.Text == password2.Text && password1.Text.Length > 7 && oldPassword.Text == client.Password)
{
newClient.Password = password1.Text;
}
else
{
errorMessage = "An error occured, password is too short or does not match.";
toInsert = false;
}
}
if (toInsert)
{
cg.Update(newClient);
Response.Redirect("~/ChangeProfile.aspx");
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('" + errorMessage + "');window.location ='ChangeProfile.aspx';", true);
}
}
public void firstInitialize()
{
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
clients = cg.SelectForTrainingStartEnd(false);
Collection <string> clientNames = new Collection <string>();
foreach (Client c in clients)
{
clientNames.Add(c.ToString());
}
comboClient.DataSource = clientNames;
}
protected override bool DeleteRecord()
{
DiscountFactory discountFactory = new DiscountFactory();
DiscountGateway <DiscountCard> dg = (DiscountGateway <DiscountCard>)discountFactory.GetCard();
DiscountCard c = dg.Select((int)client.CardId);
c.ClientId = null;
dg.Update(c);
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
cg.Delete(client.RecordId);
return(true);
}
/// <summary>
/// Loads all clients information in dataGridView
/// </summary>
private void LoadClientData()
{
try
{
ClientGateway ClientGatewayObject = new ClientGateway();
clientGridView.DataSource = ClientGatewayObject.GetClientTable();
clientGridView.DataBind();
}
catch (SqlException sqlExceptionObj)
{
errorLabel.Text = sqlExceptionObj.Message;
}
catch (Exception exceptionObj)
{
errorLabel.Text = exceptionObj.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
LockerFactory lockerFactory = new LockerFactory();
LockerXMLGateway <Locker> lg = (LockerXMLGateway <Locker>)lockerFactory.GetLocker();
if (Session["ID"] == null)
{
Response.Redirect("~/Login.aspx");
}
client = cg.Select(int.Parse((Session["ID"].ToString())));
newClient = client;
nameElement.Attributes.Add("placeholder", client.Name);
surnameElement.Attributes.Add("placeholder", client.Surname);
mailElement.Attributes.Add("placeholder", client.Mail);
genderElement.Text = client.Gender;
cardElement.Text = client.CardId.ToString();
lockerElement.Text = client.Favourite_locker.ToString();
password1.Attributes.Add("placeholder", "********");
password2.Attributes.Add("placeholder", "********");
oldPassword.Attributes.Add("placeholder", "********");
oldFavouriteLocker.Text = client.Favourite_locker.ToString();
int locker = (int)client.Favourite_locker;
peopleWithLocker.Text = cg.SelectLockerNumb((client.Favourite_locker != null) ? locker : 1).ToString();
lockers = lg.Select(client.Gender);
Collection <string> lockerStrings = new Collection <string>();
foreach (Locker l in lockers)
{
lockerStrings.Add(" " + l.RecordId.ToString() + " ");
}
if (!IsPostBack)
{
lockerDropdown.DataSource = lockerStrings;
lockerDropdown.DataBind();
}
}
public void firstInitialize()
{
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
TrainerFactory trainerFactory = new TrainerFactory();
TrainerGateway <Trainer> trainerg = (TrainerGateway <Trainer>)trainerFactory.GetTrainer();
LockerFactory lockerFactory = new LockerFactory();
LockerGateway <Locker> lg = (LockerGateway <Locker>)lockerFactory.GetLocker();
clients = cg.SelectForTrainingStartEnd(true);
trainers = trainerg.Select();
lockers = lg.Select();
Collection <string> clientNames = new Collection <string>();
foreach (Client c in clients)
{
clientNames.Add(c.ToString());
}
comboClient.DataSource = clientNames;
Collection <Locker> filteredLockers = new Collection <Locker>();
Collection <string> lockerNames = new Collection <string>();
foreach (Locker l in lockers)
{
if (l.Status != "taken")
{
filteredLockers.Add(l);
}
}
foreach (Locker l in filteredLockers)
{
lockerNames.Add(l.ToString());
}
comboLocker.DataSource = lockerNames;
Collection <string> trainerNames = new Collection <string>();
foreach (Trainer t in trainers)
{
trainerNames.Add(t.ToString());
}
comboTrainer.DataSource = trainerNames;
}
public override bool OpenRecord(object primaryKey)
{
if (primaryKey != null)
{
int idClient = (int)primaryKey;
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
client = cg.Select(idClient);
newRecord = false;
}
else
{
client = new Client();
newRecord = true;
}
BindData();
return(true);
}
protected void RefreshData()
{
TrainingFactory trainingFactory = new TrainingFactory();
TrainingGateway <Training> tg = (TrainingGateway <Training>)trainingFactory.GetTraining();
TicketFactory ticketFactory = new TicketFactory();
TicketGateway <Ticket> ticketg = (TicketGateway <Ticket>)ticketFactory.GetTicket();
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
TrainerFactory trainerFactory = new TrainerFactory();
TrainerGateway <Trainer> trainerg = (TrainerGateway <Trainer>)trainerFactory.GetTrainer();
Collection <Training> trainings = tg.Select();
Collection <TrainGrid> trainGrid = new Collection <TrainGrid>();
foreach (Training t in trainings)
{
TrainGrid tgrid = new TrainGrid();
tgrid.LockerId = t.LockerId;
tgrid.ToGender = t.ToGender;
tgrid.Start = t.TimeFrom;
tgrid.End = t.TimeTo;
// using factory to get data
Client c = cg.Select(t.ClientId);
tgrid.ClientName = c.Name + " " + c.Surname;
int tempId;
if (t.TrainerId.HasValue)
{
tempId = t.TrainerId.Value;
Trainer tr = trainerg.Select(tempId);
tgrid.TrainerName = tr.Name + " " + tr.Surname;
}
else
{
tgrid.TrainerName = "";
}
trainGrid.Add(tgrid);
}
BindingList <TrainGrid> bindingList = new BindingList <TrainGrid>(trainGrid);
trainingsGrid.AutoGenerateColumns = false;
trainingsGrid.DataSource = bindingList;
}
/// <summary>
/// Fills up clientNameDropDownList DDL
/// </summary>
private void FillClientDropmDownList()
{
try
{
ClientGateway ClientGatewayObject = new ClientGateway();
clientNameDropDownList.DataSource = ClientGatewayObject.GetClientTable();
clientNameDropDownList.DataTextField = "client_CompanyName";
clientNameDropDownList.DataValueField = "client_ID";
clientNameDropDownList.DataBind();
}
catch (SqlException sqlExceptionObj)
{
errorLabel.Text = sqlExceptionObj.Message;
}
catch (Exception exceptionObj)
{
errorLabel.Text = exceptionObj.Message;
}
}
public IList <object> GetAllClients()
{
var reader = new ClientGateway().GetAllClients();
var clientsList = new List <object>();
while (reader.Read())
{
clientsList.Add(new
{
Id = Convert.ToInt32(reader.GetValue(0)),
Name = reader.GetValue(1).ToString(),
Cnp = reader.GetValue(2).ToString(),
Address = reader.GetValue(3).ToString(),
Phone = reader.GetValue(4).ToString()
});
}
return(clientsList);
}
private void acceptButton_Click(object sender, EventArgs e)
{
Training t = new Training();
t.LockerId = lockers[comboLocker.SelectedIndex].RecordId;
t.ClientId = clients[comboClient.SelectedIndex].RecordId;
t.TrainerId = trainers[comboTrainer.SelectedIndex].RecordId;
t.ToGender = clients[comboClient.SelectedIndex].Gender;
t.TimeFrom = DateTime.Now;
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
Client c = cg.Select(t.ClientId);
DiscountFactory discountFactory = new DiscountFactory();
DiscountGateway <DiscountCard> dg = (DiscountGateway <DiscountCard>)discountFactory.GetCard();
DiscountCard card = new DiscountCard();
if (c.CardId != null)
{
int toSetId = c.CardId ?? 0;
card = dg.Select(toSetId);
}
TrainingFactory trainingFactory = new TrainingFactory();
TrainingGateway <Training> tg = (TrainingGateway <Training>)trainingFactory.GetTraining();
tg.Insert(t);
if (card != null && card.Credit > 0)
{
Forms.ChangeCredit form = new Forms.ChangeCredit();
form.ShowDialog();
}
else
{
MessageBox.Show("Training was added successfully but client " + c.Name + " " + c.Surname + " has no credit on card!", "Warning", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
}
this.Dispose();
}
protected void updateButton_Click(object sender, EventArgs e)
{
string message = null;
if (!CheckInputValues())
{
return;
}
Client clientObject = new Client();
clientObject.Id = clientIdDropDownList.SelectedItem.Text;
clientObject.CompanyName = companyNameTextBox.Text;
clientObject.ContactPerson = contactPersonTextBox.Text;
clientObject.ContactDate = Convert.ToDateTime(contactDateTextBox.Text);
clientObject.Address = addressTextBox.Text;
clientObject.PhoneNo = phoneNoTextBox.Text;
clientObject.Email = emailTextBox.Text;
try
{
ClientGateway ClientGatewayObject = new ClientGateway();
message = ClientGatewayObject.UpdateClient(clientObject).ToString();
if (message == "True")
{
message = "Data has been updated successfully";
}
}
catch (SqlException sqlExceptionObj)
{
errorLabel.Text = sqlExceptionObj.Message;
}
catch (Exception exceptionObj)
{
errorLabel.Text = exceptionObj.Message;
}
successLabel.Text = message;
errorLabel.Text = "";
}
protected void Button1_Click(object sender, EventArgs e)
{
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
string login = String.Format("{0}", Request.Form["loginInput"]);
string password = String.Format("{0}", Request.Form["passwordInput"]);
Client client = new Client();
client.Password = password;
client.Mail = login;
if (string.IsNullOrWhiteSpace(login))
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('No mail was entered');window.location ='ChangeProfile.aspx';", true);
}
else if (!Functions.IsValidEmail(login))
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('You entered non-valid email address');window.location ='ChangeProfile.aspx';", true);
}
else if (string.IsNullOrWhiteSpace(password))
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('You entered non-valid password');window.location ='ChangeProfile.aspx';", true);
}
else
{
Client cl = cg.CheckPassword(client);
if (cl != null)
{
Session["ID"] = cl.RecordId;
Session["login"] = cl.Mail;
Response.Redirect("~/TrainerRate.aspx");
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Wrong credentials!');window.location ='ChangeProfile.aspx';", true);
}
}
}
protected override bool SaveRecord()
{
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
if (GetData())
{
if (newRecord)
{
cg.Insert(client);
}
else
{
cg.Update(client);
}
return(true);
}
else
{
return(false);
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
Client clientObj = null;
ClientGateway ClientGatewayObject = null;
string message = null;
try
{
clientObj = new Client();
clientObj.Id = idLabel.Text;
clientObj.CompanyName = nameLabel.Text;
clientObj.ContactPerson = contactPersonLabel.Text;
clientObj.ContactDate = Convert.ToDateTime(contactDateLabel.Text);
clientObj.Address = addressLabel.Text;
clientObj.PhoneNo = phoneLabel.Text;
clientObj.Email = emailLabel.Text;
ClientGatewayObject = new ClientGateway();
message = ClientGatewayObject.InsertClient(clientObj).ToString();
if (message == "True")
{
message = "Data has been saved successfully";
Response.Redirect("ClientCreateUIPage.aspx?" + "&message=" + Server.UrlEncode(message));
}
}
catch (PrimaryKeyException primaryKeyExceptionObj)
{
errorMessageLabel.Text = primaryKeyExceptionObj.Message;
}
catch (SqlException sqlExceptionObj)
{
errorMessageLabel.Text = sqlExceptionObj.Message;
}
catch (Exception exceptionObj)
{
errorMessageLabel.Text = exceptionObj.Message;
}
}
