public void CostEstimateServiceDeliveryParseTest()
{
restClient.Setup(x => x.Execute(It.IsAny <string>(), It.IsAny <RequestOptions>(), It.IsAny <Hashtable>()))
.Returns(new RestResponse()
{
StatusCode = HttpStatusCode.OK,
Content = TestHelper.GetJson(TestResource.MocksPath + "CostEstimatesServiceDelivery.json")
});
costEstimates.ExecuteObj = restClient.Object;
var acknowledgements = costEstimates.Get(param);
ServiceDelivery sd = new ServiceDelivery()
{
From = 1,
To = 3,
Period = "Years",
Type = "Uniys"
};
Assert.AreEqual(null, acknowledgements.CostEstimates[0].CostEstimateEquation.Coinsurance[0].ServiceDelivery);
Assert.AreEqual(null, acknowledgements.CostEstimates[0].CostEstimateEquation.Copayment[0].ServiceDelivery);
TestHelper.PropertyValuesAreEquals(sd, acknowledgements.CostEstimates[0].CostEstimateEquation.Deductible[0].ServiceDelivery);
TestHelper.PropertyValuesAreEquals(sd, acknowledgements.CostEstimates[0].CostEstimateAlternatives.Copayment[0].ServiceDelivery);
TestHelper.PropertyValuesAreEquals(sd, acknowledgements.CostEstimates[0].CostEstimateAlternatives.Coinsurance[0].ServiceDelivery);
TestHelper.PropertyValuesAreEquals(sd, acknowledgements.CostEstimates[0].CostEstimateAlternatives.Deductible[0].ServiceDelivery);
}
public void loadInitialData(int deliveryID)
{
//call function that will load Service Subscriptions
loadServiceSubscriptors();
//declare SQL DB context var
SmartSocialdbDataContext smartsocialDB = new SmartSocialdbDataContext();
ServiceDelivery newServiceDeliveryRow = new ServiceDelivery();
try
{
ServiceDeliveryResponse response = _deliveryService.GetServiceSDeliveryById(deliveryID);
if (response.Acknowledgment)
{
txtID.Text = response.ServiceDelivery.idServiceDelivery.ToString();
startDate.Value = (DateTime)response.ServiceDelivery.DateDelivered;
dtpTo.Value = (DateTime)response.ServiceDelivery.DeliveryDateTo;
cmb_subscription.SelectedValue = response.ServiceDelivery.IdServiceSubscription;
}
else
{
MessageBox.Show(response.Message);
}
}
catch (Exception ex)
{
//show any error message returned by the database
MessageBox.Show(ex.Message);
}
}
public ServiceDelivery GetServiceDelivery(int serviceDeliveryId)
{
ServiceDelivery serviceDelivery = null;
string queryString =
SelectString +
"WHERE ServiceDeliveryId = @ServiceDeliveryId;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = queryString;
command.Parameters.Add(new SqlParameter("@ServiceDeliveryId", serviceDeliveryId));
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
serviceDelivery = Read(reader);
}
}
}
return(serviceDelivery);
}
public void updateView()
{
serviceDelivery = new ServiceDelivery();
ActiveTechnicions.Clear();
lvActiveTechnicions.ItemsSource = null;
lvUnassignedAppointments.ItemsSource = null;
ActiveTechnicions = serviceDelivery.ActiveTechniciansList;
lvActiveTechnicions.ItemsSource = ActiveTechnicions;
lvUnassignedAppointments.ItemsSource = serviceDelivery.UnassignedAppointments;
}
public ServiceDelivery Delete(Guid identifier)
{
// Load item that will be deleted
ServiceDelivery dbEntry = context.ServiceDeliverys
.FirstOrDefault(x => x.Identifier == identifier);
if (dbEntry != null)
{
// Set activity
dbEntry.Active = false;
// Set timestamp
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
private ServiceDelivery Read(SqlDataReader reader)
{
ServiceDelivery serviceDelivery = new ServiceDelivery();
serviceDelivery.Id = Int32.Parse(reader["ServiceDeliveryId"].ToString());
serviceDelivery.Identifier = Guid.Parse(reader["ServiceDeliveryIdentifier"].ToString());
if (reader["ServiceDeliveryCode"] != DBNull.Value)
{
serviceDelivery.Code = reader["ServiceDeliveryCode"].ToString();
}
if (reader["ServiceDeliveryInternalCode"] != DBNull.Value)
{
serviceDelivery.InternalCode = reader["ServiceDeliveryInternalCode"].ToString();
}
if (reader["ServiceDeliveryName"] != DBNull.Value)
{
serviceDelivery.Name = reader["ServiceDeliveryName"].ToString();
}
if (reader["ServiceDeliveryURL"] != DBNull.Value)
{
serviceDelivery.URL = reader["ServiceDeliveryURL"].ToString();
}
serviceDelivery.Active = bool.Parse(reader["Active"].ToString());
serviceDelivery.UpdatedAt = DateTime.Parse(reader["UpdatedAt"].ToString());
if (reader["CreatedById"] != DBNull.Value)
{
serviceDelivery.CreatedBy = new User();
serviceDelivery.CreatedById = Int32.Parse(reader["CreatedById"].ToString());
serviceDelivery.CreatedBy.Id = Int32.Parse(reader["CreatedById"].ToString());
serviceDelivery.CreatedBy.FirstName = reader["CreatedByFirstName"]?.ToString();
serviceDelivery.CreatedBy.LastName = reader["CreatedByLastName"]?.ToString();
}
if (reader["CompanyId"] != DBNull.Value)
{
serviceDelivery.Company = new Company();
serviceDelivery.CompanyId = Int32.Parse(reader["CompanyId"].ToString());
serviceDelivery.Company.Id = Int32.Parse(reader["CompanyId"].ToString());
serviceDelivery.Company.Name = reader["CompanyName"].ToString();
}
return(serviceDelivery);
}
public static ServiceDeliveryViewModel ConvertToServiceDeliveryViewModelLite(this ServiceDelivery serviceDelivery)
{
ServiceDeliveryViewModel serviceDeliveryViewModel = new ServiceDeliveryViewModel()
{
Id = serviceDelivery.Id,
Identifier = serviceDelivery.Identifier,
Code = serviceDelivery.Code,
InternalCode = serviceDelivery.InternalCode,
Name = serviceDelivery.Name,
URL = serviceDelivery.URL,
IsActive = serviceDelivery.Active,
UpdatedAt = serviceDelivery.UpdatedAt,
CreatedAt = serviceDelivery.CreatedAt
};
return(serviceDeliveryViewModel);
}
public ServiceDeliveryResponse Delete(Guid identifier)
{
ServiceDeliveryResponse response = new ServiceDeliveryResponse();
try
{
ServiceDelivery deletedServiceDelivery = unitOfWork.GetServiceDeliveryRepository().Delete(identifier);
unitOfWork.Save();
response.ServiceDelivery = deletedServiceDelivery.ConvertToServiceDeliveryViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.ServiceDelivery = new ServiceDeliveryViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public ServiceDeliveryResponse Create(ServiceDeliveryViewModel re)
{
ServiceDeliveryResponse response = new ServiceDeliveryResponse();
try
{
ServiceDelivery addedServiceDelivery = unitOfWork.GetServiceDeliveryRepository().Create(re.ConvertToServiceDelivery());
unitOfWork.Save();
response.ServiceDelivery = addedServiceDelivery.ConvertToServiceDeliveryViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.ServiceDelivery = new ServiceDeliveryViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public ServiceDelivery Create(ServiceDelivery serviceDelivery)
{
if (context.ServiceDeliverys.Where(x => x.Identifier != null && x.Identifier == serviceDelivery.Identifier).Count() == 0)
{
serviceDelivery.Id = 0;
serviceDelivery.Code = GetNewCodeValue(serviceDelivery.CompanyId ?? 0);
serviceDelivery.Active = true;
serviceDelivery.UpdatedAt = DateTime.Now;
serviceDelivery.CreatedAt = DateTime.Now;
context.ServiceDeliverys.Add(serviceDelivery);
return(serviceDelivery);
}
else
{
// Load ServiceDelivery that will be updated
ServiceDelivery dbEntry = context.ServiceDeliverys
.FirstOrDefault(x => x.Identifier == serviceDelivery.Identifier && x.Active == true);
if (dbEntry != null)
{
dbEntry.CompanyId = serviceDelivery.CompanyId ?? null;
dbEntry.CreatedById = serviceDelivery.CreatedById ?? null;
// Set properties
dbEntry.Code = serviceDelivery.Code;
dbEntry.InternalCode = serviceDelivery.InternalCode;
dbEntry.Name = serviceDelivery.Name;
dbEntry.URL = serviceDelivery.URL;
// Set timestamp
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
}
public static ServiceDelivery ConvertToServiceDelivery(this ServiceDeliveryViewModel serviceDeliveryViewModel)
{
ServiceDelivery serviceDelivery = new ServiceDelivery()
{
Id = serviceDeliveryViewModel.Id,
Identifier = serviceDeliveryViewModel.Identifier,
Code = serviceDeliveryViewModel.Code,
InternalCode = serviceDeliveryViewModel.InternalCode,
Name = serviceDeliveryViewModel.Name,
URL = serviceDeliveryViewModel.URL,
Active = serviceDeliveryViewModel.IsActive,
CreatedById = serviceDeliveryViewModel.CreatedBy?.Id ?? null,
CompanyId = serviceDeliveryViewModel.Company?.Id ?? null,
CreatedAt = serviceDeliveryViewModel.CreatedAt,
UpdatedAt = serviceDeliveryViewModel.UpdatedAt,
};
return(serviceDelivery);
}
private void btnSave_Click(object sender, EventArgs e)
{
//declare SQL DB context var
SmartSocialdbDataContext smartsocialDB = new SmartSocialdbDataContext();
ServiceDelivery newServiceDeliveryRow = new ServiceDelivery();
try
{
//update selected record in ServiceSubscription table
var deliveryRow = smartsocialDB.ServiceDelivery.GetByKey(int.Parse(txtID.Text));
deliveryRow.DateDelivered = startDate.Value;
deliveryRow.IdServiceSubscription = int.Parse(cmb_subscription.SelectedValue.ToString());
smartsocialDB.SubmitChanges();
smartsocialDB.Connection.Close();
//close this window
this.Close();
}
catch (Exception ex)
{
//show any error message returned by the database
MessageBox.Show(ex.Message);
}
}
public void HoverOverServiceDelivery()
{
MoveToElementAction.Perform(ServiceDelivery);
ServiceDelivery.Click();
}
public static void Menu()
{
bool inProgress = true;
while (inProgress)
{
ConsoleColor color = Console.ForegroundColor;
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t\tКУРЬЕРСКАЯ НАКЛАДНАЯ");
Console.WriteLine(new string('-', 50));
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t\tВыберите пункт меню:");
Console.WriteLine(new string('-', 50));
Console.WriteLine("1. Создать КН");
Console.WriteLine("2. Получить список всех КН");
Console.WriteLine("3. Получить информацию о всех КН");
Console.WriteLine("4. Выход");
Console.ForegroundColor = color;
int option = Convert.ToInt32(Console.ReadLine());
switch (option)
{
case 1:
{
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t1. Создать КН");
Console.WriteLine(new string('-', 50));
//exPhoneExt phoneExt = new exPhoneExt();
//ServiceDelivery serviceDelivery = new ServiceDelivery();
//phoneExt = serviceDelivery.CreatePhone();
//AddToDB.CreatePhone(phoneExt);
//foreach (var item in AddToDB.ReturnAllPhones())
//{
// serviceDelivery.ShowPhones(item);
//}
//exAddressExt exAddressExt = new exAddressExt();
//ServiceDelivery serviceDelivery = new ServiceDelivery();
//exAddressExt = serviceDelivery.CreateAddress();
//AddToDB.CreateAddress(exAddressExt);
//foreach (var item in AddToDB.ReturnAllAddresses())
//{
// serviceDelivery.ShowAddress(item);
//}
exDelivery exDeliveryBusines = new exDelivery();
ServiceDelivery serviceDelivery = new ServiceDelivery();
exDeliveryBusines = serviceDelivery.CreateDelivery();
AddToDB.CreateExDeliveryExt(exDeliveryBusines);
foreach (exDelivery item in AddToDB.ReturnAllExDeliveryExt())
{
//serviceDelivery.ShowDelivery(item);
Console.WriteLine($"Id: {item.exDeliveryId}\n" +
$"RecipientName: {item.RecipientName}\n" +
$"SenderName: {item.SenderName}\n" +
$"RecipientContact: {item.RecipientContact}\n" +
$"SenderContact: {item.SenderContact}");
}
}
break;
case 2:
{
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t2. Получить список всех КН");
Console.WriteLine(new string('-', 50));
exDelivery exDeliveryBusines = new exDelivery();
ServiceDelivery serviceDelivery = new ServiceDelivery();
//exDeliveryBusines = serviceDelivery.CreateDelivery();
//AddToDB.CreateExDeliveryExt(exDeliveryBusines);
foreach (exDelivery item in AddToDB.ReturnAllExDeliveryExt())
{
Console.WriteLine(new string('-', 50));
//serviceDelivery.ShowDelivery(item);
Console.WriteLine($"Id Курьерских Накладных: {item.exDeliveryId}");
Console.WriteLine(new string('-', 50));
}
}
break;
case 3:
{
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t3. Получить информацию о всех КН");
Console.WriteLine(new string('-', 50));
exDelivery exDeliveryBusines = new exDelivery();
ServiceDelivery serviceDelivery = new ServiceDelivery();
//exDeliveryBusines = serviceDelivery.CreateDelivery();
//AddToDB.CreateExDeliveryExt(exDeliveryBusines);
foreach (exDelivery item in AddToDB.ReturnAllExDeliveryExt())
{
Console.WriteLine(new string('-', 50));
//serviceDelivery.ShowDelivery(item);
Console.WriteLine($"Id: {item.exDeliveryId}\n" +
$"RecipientName: {item.RecipientName}\n" +
$"SenderName: {item.SenderName}\n" +
$"RecipientContact: {item.RecipientContact}\n" +
$"SenderContact: {item.SenderContact}");
Console.WriteLine(new string('-', 50));
}
}
break;
case 4:
{
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t\t4. Выход");
Console.WriteLine(new string('-', 50));
Console.ForegroundColor = ConsoleColor.DarkYellow;
Console.WriteLine("Спасибо!");
Console.ForegroundColor = color;
inProgress = false;
Console.WriteLine(new string('-', 50));
}
break;
default:
{
Console.WriteLine("Выберите пункт меню");
}
break;
}
}
}
// GET: Deliveries
public DeliveriesController()
{
deliveriesService = new ServiceDelivery();
}
