public ActionResult ShowData()
{
InputDate inputDate = (InputDate)TempData["inputDate"];
List <PowerConsumptionData> listOfData;
if (inputDate != null)
{
if (inputDate.From > DateTime.Now || inputDate.To > DateTime.Now)
{
TempData["ErrorMessage"] = "'From' or 'To' date can't pass the date that is now.";
return(RedirectToAction("GetData"));
}
if (inputDate.To != DateTime.MinValue)
{
if (inputDate.From > inputDate.To)
{
TempData["ErrorMessage"] = "'From' date has to be earlier than 'To' date.";
return(RedirectToAction("GetData"));
}
}
listOfData = (List <PowerConsumptionData>)_cachedData.Get(inputDate);
listOfData = listOfData.OrderBy(x => x.GeoAreaId).ThenBy(x => x.Timestamp.TimeOfDay).ToList();
return(View(listOfData));
}
else
{
return(RedirectToAction("GetData"));
}
}
public void PowerConsumptionCachedDataSameDateTwiceTestCache()
{
var inputDate = new InputDate()
{
From = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour - 1, DateTime.Now.Minute, DateTime.Now.Second),
To = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour + 1, DateTime.Now.Minute, DateTime.Now.Second),
};
var mockUnitOfWork = new Mock <UnitOfWork>();
mockUnitOfWork.Setup(m => m.PowerConsumptionDataRepository.Find(It.IsAny <Expression <Func <PowerConsumptionData, bool> > >())).Returns(() => data.Where(x => x.Timestamp >= inputDate.From && x.Timestamp <= inputDate.To).ToList());
var pccd = new PowerConsumptionCachedData(new CacheManager <PowerConsumptionData>(), mockUnitOfWork.Object);
var result = pccd.Get(inputDate);
foreach (PowerConsumptionData d in result)
{
Assert.GreaterOrEqual(d.Timestamp, inputDate.From);
Assert.LessOrEqual(d.Timestamp, inputDate.To);
}
var cachedResult = pccd.Get(inputDate);
Assert.AreEqual(cachedResult, result);
}
private void bOk_Click(object sender, EventArgs e)
{
if (currentPage == "text")
{
InputText it = (InputText)this.Owner;
it.inputResultTextByKey = tbxInputString.Text;
}
if (currentPage == "home")
{
MainForm mf = (MainForm)this.Owner;
mf.inputResult = tbxInputString.Text;
}
if (currentPage == "date")
{
InputDate id = (InputDate)this.Owner;
id.inputResult = tbxInputString.Text;
}
if (currentPage == "serial")
{
InputSerial isl = (InputSerial)this.Owner;
isl.inputResult = tbxInputString.Text;
}
if (currentPage == "column")
{
GenerateColumn gc = (GenerateColumn)this.Owner;
gc.inputResult = tbxInputString.Text;
}
if (currentPage == "param")
{
Param pa = (Param)this.Owner;
pa.inputResult = tbxInputString.Text;
}
Close();
}
private void btnOK_Click(object sender, EventArgs e)
{
if (currentPage == "text")
{
InputText it = (InputText)this.Owner;
it.inputResultTextByKey = tbxInputString.Text;
}
if (currentPage == "home")
{
MainForm mf = (MainForm)this.Owner;
mf.inputResult = tbxInputString.Text;
}
if (currentPage == "date")
{
InputDate id = (InputDate)this.Owner;
id.inputResult = tbxInputString.Text;
}
if (currentPage == "serial")
{
InputSerial isl = (InputSerial)this.Owner;
isl.inputResult = tbxInputString.Text;
}
if (currentPage == "newTemp")
{
NewTemplate nt = (NewTemplate)this.Owner;
nt.inputResult = tbxInputString.Text;
}
Close();
}
private InputDate KeyToDate(string key)
{
InputDate date = new InputDate();
DateTime from = DateTime.Parse(key.Split('_')[0]);
DateTime to = DateTime.Parse(key.Split('_')[1]);
date.From = from;
date.To = to;
return(date);
}
private string DateToKey(InputDate inputDate)
{
string key = "";
DateTime fromKeyPart = new DateTime(inputDate.From.Year, inputDate.From.Month, inputDate.From.Day, inputDate.From.Hour, 0, 0);
DateTime toKeyPart = new DateTime(inputDate.To.Year, inputDate.To.Month, inputDate.To.Day, inputDate.To.Hour, 0, 0);
key += $"{fromKeyPart}_{toKeyPart}";
return(key);
}
private ToolStripMenuItem CreateShowWayBill()
{
ToolStripMenuItem item = CreateItem("Просмотр путевого листа");
item.Click += delegate
{
InputDate inputDate = new InputDate(_dgvMain, Logic.Static.Actions.Show, WayBillType.Month);
inputDate.ShowDialog();
};
return(item);
}
public static void BusquedaEnGoogle(String texto)
{
try
{
Text.On(InputDate.BuscadorGoogle(), texto);
XLog.Message("Busqueda de " + texto + " en Google, OK");
}
catch (System.Exception)
{
XLog.Message("Busqueda de " + texto + " en Google, KO");
throw new System.Exception("Fallo la busqueda en google.");
}
Driver.TaskPrint();
}
public static void BuscarMensaje()
{
try
{
Enter.EnviarTexto(InputDate.BuscadorOutlook(), DatosDePrueba.asuntoMailPrueba);
Click.On(Button.BtnLupaOutlook());
XLog.Message("Busqueda de mensaje, OK");
}
catch (Exception)
{
XLog.Message("Busqueda de mensaje, KO");
throw new Exception("Fallo la busqueda del mensaje");
}
Driver.TaskPrint();
}
public void calculate()
{
double time = 0.2;
double tau = 0.1;
double h = 1;
for (int j = 0; j < n; j++) //left
{
u[0, j] = Convert.ToInt32(left.Text);
}
for (int i = 0; i < n; i++) //bottom
{
u[i, n - 1] = Convert.ToInt32(bottom.Text);
}
for (int j = 0; j < n; j++) //rigth
{
u[n - 1, j] = Convert.ToInt32(right.Text);
}
for (int i = 0; i < n; i++) //top
{
u[i, 0] = Convert.ToInt32(top.Text);
}
//CalcService calcservice = new CalcService();
CalcServiceClient calcservice = new CalcServiceClient();
InputDate inputdate = new InputDate();
OutputDate outputDate = new OutputDate();
inputdate.H = h;
inputdate.Tau = tau;
inputdate.Time = time;
inputdate.Mass_u = ToJagged(u);
//outputDate = calcservice.CulcTeploPosl(inputdate);
outputDate = calcservice.CulcTeploPosl(inputdate);
u = ToMultiD(outputDate.Culc_Teplo);
//отрисовка
plotting(u);
}
public void PowerConsumptionCacheDataDateOutOfBounds()
{
var inputDate = new InputDate()
{
From = new DateTime(DateTime.Now.Year + 1, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second),
To = new DateTime(DateTime.Now.Year + 1, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second)
};
var mockUnitOfWork = new Mock <UnitOfWork>();
mockUnitOfWork.Setup(m => m.PowerConsumptionDataRepository.Find(It.IsAny <Expression <Func <PowerConsumptionData, bool> > >())).Returns(() => new List <PowerConsumptionData>());
var pccd = new PowerConsumptionCachedData(new CacheManager <PowerConsumptionData>(), mockUnitOfWork.Object);
var result = pccd.Get(inputDate);
Assert.IsEmpty(result);
}
public static void LogInOutlook(String mail, String password)
{
try
{
Click.On(Texto.ResultadoOutlook());
Click.On(Button.BtnIniciarSesion());
Enter.EnviarTexto(InputDate.InputMail(), mail);
Click.On(Button.BtnSiguiente());
Enter.EnviarTexto(InputDate.InputPassWord(), password);
Click.On(Button.BtnSiguiente());
XLog.Message("LogIn en Outlook, OK");
}
catch (System.Exception)
{
XLog.Message("LogIn en Outlook, KO");
throw new System.Exception("Fallo LogIn en Outlook");
}
Driver.TaskPrint();
}
private IEnumerable <PowerConsumptionData> GetDataFromDb(string key)
{
InputDate inputDate = KeyToDate(key);
IEnumerable <PowerConsumptionData> listOfData;
if (inputDate.From == DateTime.MinValue && inputDate.To == DateTime.MinValue)
{
listOfData = (List <PowerConsumptionData>)_unitOfWork.PowerConsumptionDataRepository.GetAll();
}
else
{
if (inputDate.From == DateTime.MinValue && inputDate.To == DateTime.MinValue)
{
listOfData = _unitOfWork.PowerConsumptionDataRepository.GetAll();
}
else if (inputDate.From == DateTime.MinValue)
{
listOfData = _unitOfWork
.PowerConsumptionDataRepository
.Find(x => x.Timestamp <= inputDate.To)
.ToList();
}
else if (inputDate.To == DateTime.MinValue)
{
listOfData = _unitOfWork
.PowerConsumptionDataRepository
.Find(x => x.Timestamp >= inputDate.From)
.ToList();
}
else
{
listOfData = _unitOfWork
.PowerConsumptionDataRepository
.Find(x => x.Timestamp >= inputDate.From && x.Timestamp <= inputDate.To)
.ToList();
}
}
return(listOfData);
}
public static void EnviarMailOutlook()
{
try
{
Click.On(Button.BtnMensajeNuevo());
Enter.EnviarTexto(InputDate.Destinatario(), DatosDePrueba.mailDePrueba);
System.Threading.Thread.Sleep(4000);
Click.ActionClick(InputDate.Mensaje());
Enter.EnviarTexto(InputDate.Asunto(), DatosDePrueba.asuntoMailPrueba);
Enter.EnviarTexto(InputDate.Mensaje(), DatosDePrueba.mensajeDePrueba);
Click.On(Button.BtnEnviarMensaje());
XLog.Message("Enviar mail desde outlook, OK");
}
catch (Exception)
{
XLog.Message("Enviar mail desde outlook, KO");
throw new Exception("Fallo el envío de mail desde outlook");
}
Driver.TaskPrint();
}
public void PowerConsumptionCachedDataNoDateEnteredGetAll()
{
var inputDate = new InputDate()
{
From = DateTime.MinValue,
To = DateTime.MinValue
};
var mockUnitOfWork = new Mock <UnitOfWork>();
mockUnitOfWork.Setup(x => x.PowerConsumptionDataRepository.GetAll()).Returns(data);
var pccd = new PowerConsumptionCachedData(new CacheManager <PowerConsumptionData>(),
mockUnitOfWork.Object);
var result = pccd.Get(inputDate);
//CollectionAssert.AreEqual(data, result);
foreach (PowerConsumptionData d in result)
{
Assert.AreEqual(d, data.FirstOrDefault(x => x.Id == d.Id));
}
}
public void PowerConsumptionCachedDataNoFromDateEnteredFind()
{
var inputDate = new InputDate()
{
From = new DateTime(1, 1, 1, 0, 0, 0, 0),
To = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second + 1)
};
var mockUnitOfWork = new Mock <UnitOfWork>();
mockUnitOfWork.Setup(m => m.PowerConsumptionDataRepository.Find(It.IsAny <Expression <Func <PowerConsumptionData, bool> > >())).Returns(() => data.Where(x => x.Timestamp <= inputDate.To).ToList());
var pccd = new PowerConsumptionCachedData(new CacheManager <PowerConsumptionData>(),
mockUnitOfWork.Object);
var result = pccd.Get(inputDate);
foreach (PowerConsumptionData d in result)
{
Assert.LessOrEqual(d.Timestamp, inputDate.To);
}
}
// 날짜 입력 후엔터키를 누르면 일자 확인 후 dgv전표의 "일" 컬럼에 일자가 들어감
private void Txb일_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
input = new InputDate();
if (cbb월.SelectedItem != null)
{
input.Month = int.Parse(cbb월.SelectedItem.ToString());
}
else if (cbb월.Text != null)
{
input.Month = int.Parse(cbb월.Text);
}
else
{
return;
}
input.Year = int.Parse(lbl회계년도.Text);
if (txb일.Text.IsNullOrEmpty())
{
if (input.IsDate(input.Year, input.Month, 50) == false)
{
input.Date = new DateTime(input.Year, input.Month, int.Parse(input.DayText));
DateTime firstDate = new DateTime(input.Year, input.Month, 1);
List <전표> list = DB.전표.GetAllMatchedMonth(firstDate, input.Date);
if (list != null)
{
FillDataGridViewInList(list);
dgv전표.Focus();
bool check = IsPossibleToAddByStatement();
if (dgv전표.RowCount == 0)
{
dgv전표.Rows.Add();
}
if (check == true)
{
dgv전표.Rows.Add();
}
전표단위.LoadCnt = list.Count - 1;
전표단위.Index = dgv전표.CurrentRow.Index;
전표단위.RowCnt = dgv전표.RowCount;
dgv전표.CurrentCell = dgv전표.Rows[전표단위.Index].Cells[2];
}
else
{
return;
}
}
}
else
{
int.TryParse(txb일.Text, out int result);
if (result == 0)
{
MessageBox.Show("잘못된 입력입니다. 다시 입력하시오.");
return;
}
else
{
input.Day = result;
}
if (input.IsDate(input.Year, input.Month, input.Day) == false)
{
txb일.Text = input.DayText;
Load전표();
}
else
{
txb일.Text = input.Day.ToString();
Load전표();
}
}
}
}
// InputDate inputDate = new InputDate();
// return View(inputDate);
public ActionResult EvXML()
{
EGH01DB.RGEContext db = new EGH01DB.RGEContext();
InputDate inputDate = new InputDate();
XMLEX xmlex = new XMLEX();
xmlex.DateIncident = new DateTime(2012, 10, 3, 8, 12, 0);
xmlex.DateMessage = new DateTime(2012, 12, 8, 12, 17, 0);
xmlex.volumeNNP = 30;
xmlex.TypeNNP = "Подземный резервуар";
xmlex.Temp = 2;
xmlex.location = "Минская область, Минский район, г.Слуцк";
xmlex.area = "Минский";
xmlex.region = "Минская";
xmlex.Coordlatitudedegr = 46;
xmlex.Coordlatitudemin = 5;
xmlex.Coordlatitudesec = 2;
xmlex.Coordlongitudedegr = 53;
xmlex.Coordlongitudemin = 25;
xmlex.Coordlongitudesec = 5;
xmlex.density = "0.7-0.75 г/cм3";
xmlex.solubility = "9.0-505 мг/дм3";
xmlex.viscosity = "0.43-0.82 мм<sup>2</sup>/с";
// XmlTextWriter textWritter = new XmlTextWriter("RGE.xml", System.Text.Encoding.UTF8);
// textWritter.WriteStartDocument();
// textWritter.WriteStartElement("Модель");
// textWritter.WriteAttributeString("Дата", "25.09.2016");
// textWritter.WriteAttributeString("Имя", "Дарья");
// textWritter.WriteEndElement();
// textWritter.Close();
XDocument xdoc = new XDocument();
XElement Модель = new XElement("Модель");
XAttribute МодельИмя = new XAttribute("Имя", "Дарья");
XAttribute МодельДата = new XAttribute("Дата", "23.09.2016");
XElement ИсходныеДанные = new XElement("ИсходныеДанные");
XElement Даты = new XElement("Даты");
XAttribute происшествия = new XAttribute("происшествия", xmlex.DateIncident.ToString());
Модель.Add(МодельДата);
Модель.Add(МодельИмя);
Модель.Add(ИсходныеДанные);
ИсходныеДанные.Add(Даты);
Даты.Add(происшествия);
XElement Сообщения = new XElement("Сообщения", xmlex.DateMessage.ToString());
Даты.Add(Сообщения);
XElement Происшествия = new XElement("Происшествия", xmlex.TypeNNP);
ИсходныеДанные.Add(Происшествия);
XElement асположение = new XElement("Расположение");
ИсходныеДанные.Add(асположение);
XAttribute Объект = new XAttribute("Объект", xmlex.AccidentObj);
асположение.Add(Объект);
XElement Область = new XElement("Область", xmlex.region);
асположение.Add(Область);
XElement айон = new XElement("Район", xmlex.area);
асположение.Add(айон);
XElement ТипННП = new XElement("ТипННП", xmlex.TypeNNP2);
ИсходныеДанные.Add(ТипННП);
XElement Объем = new XElement("Объем", xmlex.volumeNNP.ToString());
ИсходныеДанные.Add(Объем);
XElement Температура = new XElement("Температура", xmlex.Temp.ToString());
ИсходныеДанные.Add(Температура);
XElement ДанныеИзБД = new XElement("ДанныеИзБД");
Модель.Add(ДанныеИзБД);
XElement Характеристики = new XElement("Характеристики");
ДанныеИзБД.Add(Характеристики);
XAttribute ОбъектБД = new XAttribute("Объект", xmlex.TypeInccident);
Характеристики.Add(ОбъектБД);
XElement Хранит = new XElement("Хранит", xmlex.TypeNNP2);
Характеристики.Add(Хранит);
XElement асположениеБД = new XElement("Расположение", xmlex.location);
Характеристики.Add(асположениеБД);
XElement ХарактеристикиННП = new XElement("ХарактеристикиННП");
ДанныеИзБД.Add(ХарактеристикиННП);
XAttribute ТипННПБД = new XAttribute("ТипННПБД", xmlex.TypeNNP2);
ХарактеристикиННП.Add(ТипННПБД);
XElement Плотность = new XElement("Плотность", xmlex.density);
ХарактеристикиННП.Add(Плотность);
XElement Вязкость = new XElement("Вязкость", xmlex.viscosity);
ХарактеристикиННП.Add(Вязкость);
XElement астворимость = new XElement("Растворимость", xmlex.solubility);
ХарактеристикиННП.Add(астворимость);
XElement КлиматическиеУсловия = new XElement("КлиматическиеУсловия");
ДанныеИзБД.Add(КлиматическиеУсловия);
XElement СредняяТемпература = new XElement("СредняяТемпература", xmlex.Temp.ToString());
КлиматическиеУсловия.Add(СредняяТемпература);
XElement ПромерзаниеПочвы = new XElement("ПромерзаниеПочвы", xmlex.Temp.ToString());
КлиматическиеУсловия.Add(ПромерзаниеПочвы);
xdoc.Add(Модель);
String xmlstr = xdoc.ToString();
return(View(inputDate));
}
public ActionResult GetData(InputDate inputDate)
{
TempData["inputDate"] = inputDate;
return(RedirectToAction("ShowData"));
}
public IEnumerable <PowerConsumptionData> Get(InputDate inputDate)
{
string key = DateToKey(inputDate);
return(GetData(key));
}
public static bool BuscadorLargoVisible()
{
return(Driver.GetIntance().FindElement(InputDate.BuscadorClarin()).Enabled&&
Driver.GetIntance().FindElement(InputDate.BuscadorClarin()).Displayed);
}
