private void RELIGIONBOX_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
DATE.Focus();
}
}
public override void Dispose()
{
if (!base._isDisposed)
{
_value = null;
GC.SuppressFinalize(this);
base._isDisposed = !base._isDisposed;
}
}
public override bool Equals(object obj)
{
var hIVTEST = obj as HIVTEST;
return(hIVTEST != null &&
DATE.IsSameAs(hIVTEST.DATE) &&
RESULT.IsSameAs(hIVTEST.RESULT) &&
TYPE.IsSameAs(hIVTEST.TYPE) &&
FACILITY.IsSameAs(hIVTEST.FACILITY) &&
STRATEGY.IsSameAs(hIVTEST.STRATEGY));
}
private void InsertData(object sender, EventArgs e)
{
if (ScheduleFix)
{
if ("".Equals(cboUser.ValueList))
{
ViewMessage.Info("담당자와 내용을 선택해 주시기 바랍니다.");
}
else
{
ClearSearchData();
SetSearchData("DOC_ID", DOC_ID);
SetSearchData("ACCEPT_TM", DATE.ToString("yyyy-MM-dd HH:mm:ss"));
SetSearchData("PROC_TM", dtCreateTime.Value.ToString("yyyy-MM-dd HH:mm:ss"));
SetSearchData("USER_ID_LST", cboUser.ValueList);
SetSearchData("CRT_USER_ID", DTOFactory.UserId);
SetServiceId("SetScheduleManager");
DTOFactory.Transaction(new ReportDTO());
ViewMessage.Info("일정 수정을 완료 하였습니다.");
DialogResult = DialogResult.OK;
Close();
}
}
else
{
if ("".Equals(cboUser.ValueList) || "".Equals(cboPlan.ValueList))
{
ViewMessage.Info("담당자와 내용을 선택해 주시기 바랍니다.");
}
else
{
ClearSearchData();
SetSearchData("DOC_ID", DOC_ID);
SetSearchData("ACCEPT_TM", dtCreateTime.Value.ToString("yyyy-MM-dd HH:mm:ss"));
SetSearchData("USER_ID_LST", cboUser.ValueList);
SetSearchData("DESC", cboPlan.ValueList);
SetSearchData("CRT_USER_ID", DTOFactory.UserId);
SetServiceId("SetScheduleManager");
DTOFactory.Transaction(new ReportDTO());
ViewMessage.Info("일정 등록을 완료 하였습니다.");
DialogResult = DialogResult.OK;
Close();
}
}
}
public void T1()
{
#region T1
var name = "2018 Summer Promotion";
var discount = 0.15M;
var startDate = "20180601";
var expiredDate = "20180901";
var rows = DbContext.Database.Execute((Promotions promo) => {
var set = promo.@using((promo.PromotionName, promo.Discount, promo.StartDate, promo.ExpiredDate));
INSERT().INTO(set);
VALUES(set.Row((name, discount, DataTypes.DATE.Raw(startDate), DataTypes.DATE.Raw(expiredDate))));
});
Console.WriteLine($"{rows} rows affected");
#endregion
}
/// <summary>
/// record answers from survey filled by guest by incrementing the count of each option selected.
/// by default, if no option is chosen, the first choice will be recorded.
/// </summary>
/// <param name="_surv"></param>
/// <returns></returns>
//public bool InsertAnswers(Survey _surv)
//{
// bool Date = Rec_Date(_surv);
// bool FirstTimeVisit = Rec_FirstTime(_surv);
// bool FoodImpression = Rec_Food(_surv);
// bool FutureAttendence = Rec_FutureAttendence(_surv);
// bool LocationImpression = Rec_Location(_surv);
// bool LongQuiz = Rec_Long_Quiz(_surv);
// bool Overall = Rec_Overall_Satisfaction(_surv);
// bool recomment = Rec_Recommendation(_surv);
// bool isSession = Rec_Session(_surv);
// if(Date == true && FirstTimeVisit == true && FoodImpression == true
// && FutureAttendence == true && LocationImpression == true
// && LongQuiz == true && Overall == true && recomment == true && isSession == true)
// {
// return true;
// }else
// {
// return false;
// }
//}
public bool Rec_Date(Survey _surv)
{
int surveyID = Convert.ToInt32(_surv.S_ID);
// int Q_ID = Convert.ToInt32(_surv.ID);
using (EventrixDBDataContext db = new EventrixDBDataContext())
{
try
{
int _query = (from res in db.DATEs
where res.S_Id.Equals(surveyID)
select res).Count();
if (_query == 0) //Create New Answer
{
DATE toinsert = new DATE();
toinsert.S_Id = _surv.S_ID;
toinsert.Very_Dissatisfied = _surv.veryDissatisfied;
toinsert.Dissatisfied = _surv.Dissatisfied;
toinsert.Neutral = _surv.Neutral;
toinsert.Very_Satisfied = _surv.VerySatisfied;
toinsert.Satisfied = _surv.Satisfied;
db.DATEs.InsertOnSubmit(toinsert);
db.SubmitChanges();
return(true);
}
else //Update Record
{
DATE query = (from res in db.DATEs
where res.S_Id.Equals(surveyID)
select res).First();
query.Very_Dissatisfied += _surv.veryDissatisfied;
query.Dissatisfied += _surv.Dissatisfied;
query.Neutral += _surv.Neutral;
query.Satisfied += _surv.Neutral;
query.Very_Satisfied += _surv.VerySatisfied;
db.SubmitChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
};
}
public static DateTime OleDateDecode(DATE dtSrc)
{
tm tmDest = new tm();
if (!OleDateDecode(dtSrc, ref tmDest, false))
{
return(new DateTime(1899, 12, 30));//0
}
else if (dtSrc > 0.000001)
{
DateTime dtDest = new DateTime(tmDest.tm_year, tmDest.tm_mon, tmDest.tm_mday, tmDest.tm_hour, tmDest.tm_min, tmDest.tm_sec, tmDest.tm_msec);
return(dtDest);
}
else
{
DateTime dtDest = DateTime.Now;
return(dtDest);
}
}
public IHttpActionResult PostDate(DATE data)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
db.DATEs.Add(data);
db.SaveChanges();
}
catch (Exception)
{
dynamic User = new ExpandoObject();
User.Message = "Something went wrong !";
return(null);
}
return(Ok(data));
}
public void GetPropertyError(string propertyName, ErrorInfo info)
{
//throw new NotImplementedException();
if (propertyName == "DATE")
{
if (string.IsNullOrWhiteSpace(DATE.ToString()))
{
info.ErrorText = string.Format("The {0} field cannot be empty", propertyName);
}
else if (!FrmImport.IsDateTime(DATE.ToString()))
{
info.ErrorText = "Invalid Date";
}
else if (!FrmImport.CheckDateRange(startDate, endtDate, Convert.ToDateTime(DATE)))
{
info.ErrorText = "Date not within the specified date range";
}
}
if (propertyName == "CREDIT")
{
if (!FrmImport.IsNumeric(CREDIT))
{
info.ErrorText = "Credit is not in the right format";
}
else if (CREDIT < 0)
{
info.ErrorText = "Credit is negative ";
}
}
//if (propertyName == "DEBIT")
//{
// info.ErrorText = "Debit is not in the right format";
//}
//if (propertyName == "BALANCE")
//{
// info.ErrorText = "Balance is not in the right format";
//}
}
public async Task WriteAsync(TProtocol oprot, CancellationToken cancellationToken)
{
oprot.IncrementRecursionDepth();
try
{
var struc = new TStruct("LogicalType");
await oprot.WriteStructBeginAsync(struc, cancellationToken);
var field = new TField();
if (STRING != null && __isset.@STRING)
{
field.Name = "STRING";
field.Type = TType.Struct;
field.ID = 1;
await oprot.WriteFieldBeginAsync(field, cancellationToken);
await STRING.WriteAsync(oprot, cancellationToken);
await oprot.WriteFieldEndAsync(cancellationToken);
}
if (MAP != null && __isset.MAP)
{
field.Name = "MAP";
field.Type = TType.Struct;
field.ID = 2;
await oprot.WriteFieldBeginAsync(field, cancellationToken);
await MAP.WriteAsync(oprot, cancellationToken);
await oprot.WriteFieldEndAsync(cancellationToken);
}
if (LIST != null && __isset.LIST)
{
field.Name = "LIST";
field.Type = TType.Struct;
field.ID = 3;
await oprot.WriteFieldBeginAsync(field, cancellationToken);
await LIST.WriteAsync(oprot, cancellationToken);
await oprot.WriteFieldEndAsync(cancellationToken);
}
if (ENUM != null && __isset.@ENUM)
{
field.Name = "ENUM";
field.Type = TType.Struct;
field.ID = 4;
await oprot.WriteFieldBeginAsync(field, cancellationToken);
await ENUM.WriteAsync(oprot, cancellationToken);
await oprot.WriteFieldEndAsync(cancellationToken);
}
if (DECIMAL != null && __isset.@DECIMAL)
{
field.Name = "DECIMAL";
field.Type = TType.Struct;
field.ID = 5;
await oprot.WriteFieldBeginAsync(field, cancellationToken);
await DECIMAL.WriteAsync(oprot, cancellationToken);
await oprot.WriteFieldEndAsync(cancellationToken);
}
if (DATE != null && __isset.DATE)
{
field.Name = "DATE";
field.Type = TType.Struct;
field.ID = 6;
await oprot.WriteFieldBeginAsync(field, cancellationToken);
await DATE.WriteAsync(oprot, cancellationToken);
await oprot.WriteFieldEndAsync(cancellationToken);
}
if (TIME != null && __isset.TIME)
{
field.Name = "TIME";
field.Type = TType.Struct;
field.ID = 7;
await oprot.WriteFieldBeginAsync(field, cancellationToken);
await TIME.WriteAsync(oprot, cancellationToken);
await oprot.WriteFieldEndAsync(cancellationToken);
}
if (TIMESTAMP != null && __isset.TIMESTAMP)
{
field.Name = "TIMESTAMP";
field.Type = TType.Struct;
field.ID = 8;
await oprot.WriteFieldBeginAsync(field, cancellationToken);
await TIMESTAMP.WriteAsync(oprot, cancellationToken);
await oprot.WriteFieldEndAsync(cancellationToken);
}
if (INTEGER != null && __isset.INTEGER)
{
field.Name = "INTEGER";
field.Type = TType.Struct;
field.ID = 10;
await oprot.WriteFieldBeginAsync(field, cancellationToken);
await INTEGER.WriteAsync(oprot, cancellationToken);
await oprot.WriteFieldEndAsync(cancellationToken);
}
if (UNKNOWN != null && __isset.UNKNOWN)
{
field.Name = "UNKNOWN";
field.Type = TType.Struct;
field.ID = 11;
await oprot.WriteFieldBeginAsync(field, cancellationToken);
await UNKNOWN.WriteAsync(oprot, cancellationToken);
await oprot.WriteFieldEndAsync(cancellationToken);
}
if (JSON != null && __isset.JSON)
{
field.Name = "JSON";
field.Type = TType.Struct;
field.ID = 12;
await oprot.WriteFieldBeginAsync(field, cancellationToken);
await JSON.WriteAsync(oprot, cancellationToken);
await oprot.WriteFieldEndAsync(cancellationToken);
}
if (BSON != null && __isset.BSON)
{
field.Name = "BSON";
field.Type = TType.Struct;
field.ID = 13;
await oprot.WriteFieldBeginAsync(field, cancellationToken);
await BSON.WriteAsync(oprot, cancellationToken);
await oprot.WriteFieldEndAsync(cancellationToken);
}
await oprot.WriteFieldStopAsync(cancellationToken);
await oprot.WriteStructEndAsync(cancellationToken);
}
finally
{
oprot.DecrementRecursionDepth();
}
}
public IDATEBuilder Clear()
{
_value = base.ResetValue <DATE>();
return(this);
}
static bool OleDateDecode(DATE dtSrc, ref tm tmDest, bool bRoundSecond = true)
{
const int MIN_DATE = -657434, MAX_DATE = 2958465;
const double HALF_SECOND = 1.0 / 172800.0;
// The legal range does not actually span year 0 to 9999.
if (dtSrc > MAX_DATE || dtSrc < MIN_DATE) // about year 100 to about 9999
{
return(false);
}
int[] _afxMonthDays = new int[13] {
0, 31, 59, 90, 120, 151, 181, 212, 243, 273, 304, 334, 365
};
int nDays; // Number of days since Dec. 30, 1899
int nDaysAbsolute; // Number of days since 1/1/0
int nSecsInDay; // Time in seconds since midnight
int nMinutesInDay; // Minutes in day
int n400Years; // Number of 400 year increments since 1/1/0
int n400Century; // Century within 400 year block (0,1,2 or 3)
int n4Years; // Number of 4 year increments since 1/1/0
int n4Day; // Day within 4 year block
// (0 is 1/1/yr1, 1460 is 12/31/yr4)
int n4Yr; // Year within 4 year block (0,1,2 or 3)
bool bLeap4 = true; // TRUE if 4 year block includes leap year
double dblDate = dtSrc; // tempory serial date
// If a valid date, then this conversion should not overflow
nDays = (int)dblDate;
// Round to the second
if (bRoundSecond)
{
dblDate += ((dtSrc > 0.0) ? HALF_SECOND : -HALF_SECOND);
}
nDaysAbsolute = (int)dblDate + 693959; // Add days from 1/1/0 to 12/30/1899
dblDate = Math.Abs(dblDate);
int nMSecsInDay = (int)((dblDate - Math.Floor(dblDate)) * 86400000);
nSecsInDay = nMSecsInDay / 1000;
nMSecsInDay = nMSecsInDay % 1000;
tmDest.tm_msec = nMSecsInDay;
// Calculate the day of week (sun=1, mon=2...)
// -1 because 1/1/0 is Sat. +1 because we want 1-based
tmDest.tm_wday = (int)((nDaysAbsolute - 1) % 7L) + 1;
// Leap years every 4 yrs except centuries not multiples of 400.
n400Years = (int)(nDaysAbsolute / 146097L);
// Set nDaysAbsolute to day within 400-year block
nDaysAbsolute %= 146097;
// -1 because first century has extra day
n400Century = (int)((nDaysAbsolute - 1) / 36524);
// Non-leap century
if (n400Century != 0)
{
// Set nDaysAbsolute to day within century
nDaysAbsolute = (nDaysAbsolute - 1) % 36524;
// +1 because 1st 4 year increment has 1460 days
n4Years = (int)((nDaysAbsolute + 1) / 1461);
if (n4Years != 0)
{
n4Day = (int)((nDaysAbsolute + 1) % 1461);
}
else
{
bLeap4 = false;
n4Day = (int)nDaysAbsolute;
}
}
else
{
// Leap century - not special case!
n4Years = (int)(nDaysAbsolute / 1461L);
n4Day = (int)(nDaysAbsolute % 1461L);
}
if (bLeap4)
{
// -1 because first year has 366 days
n4Yr = (n4Day - 1) / 365;
if (n4Yr != 0)
{
n4Day = (n4Day - 1) % 365;
}
}
else
{
n4Yr = n4Day / 365;
n4Day %= 365;
}
// n4Day is now 0-based day of year. Save 1-based day of year, year number
tmDest.tm_yday = (int)n4Day + 1;
tmDest.tm_year = n400Years * 400 + n400Century * 100 + n4Years * 4 + n4Yr;
// Handle leap year: before, on, and after Feb. 29.
if (n4Yr == 0 && bLeap4)
{
// Leap Year
if (n4Day == 59)
{
/* Feb. 29 */
tmDest.tm_mon = 2;
tmDest.tm_mday = 29;
goto DoTime;
}
// Pretend it's not a leap year for month/day comp.
if (n4Day >= 60)
{
--n4Day;
}
}
// Make n4DaY a 1-based day of non-leap year and compute
// month/day for everything but Feb. 29.
++n4Day;
// Month number always >= n/32, so save some loop time */
for (tmDest.tm_mon = (n4Day >> 5) + 1;
n4Day > _afxMonthDays[tmDest.tm_mon]; tmDest.tm_mon++)
{
;
}
tmDest.tm_mday = (int)(n4Day - _afxMonthDays[tmDest.tm_mon - 1]);
DoTime:
if (nSecsInDay == 0)
{
tmDest.tm_hour = tmDest.tm_min = tmDest.tm_sec = 0;
}
else
{
tmDest.tm_sec = (int)nSecsInDay % 60;
nMinutesInDay = nSecsInDay / 60;
tmDest.tm_min = (int)nMinutesInDay % 60;
tmDest.tm_hour = (int)nMinutesInDay / 60;
}
return(true);
}
static void Main(string[] args)
{
Console.WriteLine("Welcome To The Console");
Console.WriteLine("Please use the options below");
Console.WriteLine("Enter 1 for GetAverage");
Console.WriteLine("Enter 2 for GetFibonacciSeries");
Console.WriteLine("Enter 3 for Currency Converter");
Console.WriteLine("Enter 4 for The Chase Assessment Solution Problem");
Console.WriteLine("Enter 5 for Character Counter");
string action = Console.ReadLine();
if (action == "1")
{
Console.WriteLine("How many numbers will you be providing ?");
string numberOfItems = Console.ReadLine();
int.TryParse(numberOfItems, out int numItems);
List <float> averageList = new List <float>();
for (int i = 1; i <= numItems; i++)
{
Console.WriteLine("Please enter number " + i);
string currentNumber = Console.ReadLine();
float.TryParse(currentNumber, out float currentNum);
averageList.Add(currentNum);
}
try
{
DATE timer = new DATE();
string average = Numbers.GetAverage(averageList);
Console.WriteLine("Calculated Average is " + average);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
//Console.WriteLine("Enter 3 Numbers");
}
}
if (action == "2")
{
Console.WriteLine("Please enter the number of elements in the sequence");
string numberOfItems = Console.ReadLine();
int.TryParse(numberOfItems, out int numItems);
if (numItems <= 0)
{
Console.WriteLine("Please enter a number greater than 0");
}
if (numItems > 0)
{
List <int> series = Numbers.GetFibonacciSeries(numItems);
string seriesString = "";
//Build String from List
for (int i = 0; i < series.Count; i++)
{
seriesString += series[i];
if (i <= (series.Count - 2))
{
seriesString += ", ";
}
if (i == (series.Count - 1))
{
seriesString += ".";
}
}
Console.WriteLine("================== RESULT =======================");
Console.WriteLine();
Console.WriteLine(seriesString);
Console.WriteLine();
Console.WriteLine("==================== END ========================");
}
}
if (action == "3")
{
Console.WriteLine("Press 1 to enter Dollar amount");
Console.WriteLine("Press 2 to enter Naira amount");
string currencyOption = Console.ReadLine();
string currency = "Naira";
string nairaSign = "N";
string dollarSign = "$";
if (currencyOption == "1")
{
currency = "Dollar";
}
Console.WriteLine("Enter " + currency + " amount");
string amountSupplied = Console.ReadLine();
float.TryParse(amountSupplied, out float amount);
float result = Numbers.CurrencyConverter(currency, amount);
Console.WriteLine();
Console.WriteLine("================== RESULT =======================");
Console.WriteLine();
Console.WriteLine("Rate used N460 to $1");
if (currencyOption == "1")
{
Console.WriteLine(dollarSign + amount.ToString("#,##0") + " is " + nairaSign + result.ToString("#,##0.00") + " in Naira");
}
else
{
Console.WriteLine(nairaSign + amount.ToString("#,##0") + " is " + dollarSign + result.ToString("#,##0.00") + " in Dollars");
}
Console.WriteLine();
Console.WriteLine("==================== END ========================");
}
if (action == "4")
{
//Assessment Problem
Console.WriteLine("Welcome To The AlgoSection.");
Console.WriteLine("I Accept a list of numbers in this format { 2,3,4,5,6 ; 7,8,9,3,2 }");
Console.WriteLine("Returns a sorted array with odd numbers first");
Console.WriteLine("Please enter the numbers");
string inputString = Console.ReadLine();
string[] inputStringArray = inputString.Split(";");
List <int> outputArrayEven = new List <int>();
List <int> outputArrayOdd = new List <int>();
string[] oneArray = inputStringArray[0].Split(",");
string[] twoArray = inputStringArray[1].Split(",");
foreach (var item in oneArray)
{
int.TryParse(item.ToString(), out int itemInt);
if (itemInt % 2 == 0)
{
outputArrayEven.Add(itemInt);
}
else
{
outputArrayOdd.Add(itemInt);
}
}
foreach (var item in twoArray)
{
int.TryParse(item.ToString(), out int itemInt);
if (itemInt % 2 == 0)
{
outputArrayEven.Add(itemInt);
}
else
{
outputArrayOdd.Add(itemInt);
}
}
outputArrayEven.Sort();
outputArrayOdd.Sort();
outputArrayOdd.AddRange(outputArrayEven);
Console.WriteLine(string.Join(",", outputArrayOdd));
}
if (action == "5")
{
Console.WriteLine("Welcome To Character Count.");
Console.WriteLine("Please Enter a String");
string inputString = Console.ReadLine();
Dictionary <char, int> characterCount = new Dictionary <char, int>();
foreach (var character in inputString)
{
if (character != ' ')
{
if (!characterCount.ContainsKey(character))
{
characterCount.Add(character, 1);
}
else
{
characterCount[character]++;
}
}
}
characterCount.ToList().ForEach(x => Console.WriteLine(x.Key));
}
}
public void Write(TProtocol oprot)
{
oprot.IncrementRecursionDepth();
try
{
TStruct struc = new TStruct("LogicalType");
oprot.WriteStructBegin(struc);
TField field = new TField();
if (STRING != null && __isset.@STRING)
{
field.Name = "STRING";
field.Type = TType.Struct;
field.ID = 1;
oprot.WriteFieldBegin(field);
STRING.Write(oprot);
oprot.WriteFieldEnd();
}
if (MAP != null && __isset.MAP)
{
field.Name = "MAP";
field.Type = TType.Struct;
field.ID = 2;
oprot.WriteFieldBegin(field);
MAP.Write(oprot);
oprot.WriteFieldEnd();
}
if (LIST != null && __isset.LIST)
{
field.Name = "LIST";
field.Type = TType.Struct;
field.ID = 3;
oprot.WriteFieldBegin(field);
LIST.Write(oprot);
oprot.WriteFieldEnd();
}
if (ENUM != null && __isset.@ENUM)
{
field.Name = "ENUM";
field.Type = TType.Struct;
field.ID = 4;
oprot.WriteFieldBegin(field);
ENUM.Write(oprot);
oprot.WriteFieldEnd();
}
if (DECIMAL != null && __isset.@DECIMAL)
{
field.Name = "DECIMAL";
field.Type = TType.Struct;
field.ID = 5;
oprot.WriteFieldBegin(field);
DECIMAL.Write(oprot);
oprot.WriteFieldEnd();
}
if (DATE != null && __isset.DATE)
{
field.Name = "DATE";
field.Type = TType.Struct;
field.ID = 6;
oprot.WriteFieldBegin(field);
DATE.Write(oprot);
oprot.WriteFieldEnd();
}
if (TIME != null && __isset.TIME)
{
field.Name = "TIME";
field.Type = TType.Struct;
field.ID = 7;
oprot.WriteFieldBegin(field);
TIME.Write(oprot);
oprot.WriteFieldEnd();
}
if (TIMESTAMP != null && __isset.TIMESTAMP)
{
field.Name = "TIMESTAMP";
field.Type = TType.Struct;
field.ID = 8;
oprot.WriteFieldBegin(field);
TIMESTAMP.Write(oprot);
oprot.WriteFieldEnd();
}
if (INTEGER != null && __isset.INTEGER)
{
field.Name = "INTEGER";
field.Type = TType.Struct;
field.ID = 10;
oprot.WriteFieldBegin(field);
INTEGER.Write(oprot);
oprot.WriteFieldEnd();
}
if (UNKNOWN != null && __isset.UNKNOWN)
{
field.Name = "UNKNOWN";
field.Type = TType.Struct;
field.ID = 11;
oprot.WriteFieldBegin(field);
UNKNOWN.Write(oprot);
oprot.WriteFieldEnd();
}
if (JSON != null && __isset.JSON)
{
field.Name = "JSON";
field.Type = TType.Struct;
field.ID = 12;
oprot.WriteFieldBegin(field);
JSON.Write(oprot);
oprot.WriteFieldEnd();
}
if (BSON != null && __isset.BSON)
{
field.Name = "BSON";
field.Type = TType.Struct;
field.ID = 13;
oprot.WriteFieldBegin(field);
BSON.Write(oprot);
oprot.WriteFieldEnd();
}
if (UUID != null && __isset.UUID)
{
field.Name = "UUID";
field.Type = TType.Struct;
field.ID = 14;
oprot.WriteFieldBegin(field);
UUID.Write(oprot);
oprot.WriteFieldEnd();
}
oprot.WriteFieldStop();
oprot.WriteStructEnd();
}
finally
{
oprot.DecrementRecursionDepth();
}
}
public override string ToString()
{
StringBuilder __sb = new StringBuilder("LogicalType(");
bool __first = true;
if (STRING != null && __isset.@STRING)
{
if (!__first)
{
__sb.Append(", ");
}
__first = false;
__sb.Append("STRING: ");
__sb.Append(STRING == null ? "<null>" : STRING.ToString());
}
if (MAP != null && __isset.MAP)
{
if (!__first)
{
__sb.Append(", ");
}
__first = false;
__sb.Append("MAP: ");
__sb.Append(MAP == null ? "<null>" : MAP.ToString());
}
if (LIST != null && __isset.LIST)
{
if (!__first)
{
__sb.Append(", ");
}
__first = false;
__sb.Append("LIST: ");
__sb.Append(LIST == null ? "<null>" : LIST.ToString());
}
if (ENUM != null && __isset.@ENUM)
{
if (!__first)
{
__sb.Append(", ");
}
__first = false;
__sb.Append("ENUM: ");
__sb.Append(ENUM == null ? "<null>" : ENUM.ToString());
}
if (DECIMAL != null && __isset.@DECIMAL)
{
if (!__first)
{
__sb.Append(", ");
}
__first = false;
__sb.Append("DECIMAL: ");
__sb.Append(DECIMAL == null ? "<null>" : DECIMAL.ToString());
}
if (DATE != null && __isset.DATE)
{
if (!__first)
{
__sb.Append(", ");
}
__first = false;
__sb.Append("DATE: ");
__sb.Append(DATE == null ? "<null>" : DATE.ToString());
}
if (TIME != null && __isset.TIME)
{
if (!__first)
{
__sb.Append(", ");
}
__first = false;
__sb.Append("TIME: ");
__sb.Append(TIME == null ? "<null>" : TIME.ToString());
}
if (TIMESTAMP != null && __isset.TIMESTAMP)
{
if (!__first)
{
__sb.Append(", ");
}
__first = false;
__sb.Append("TIMESTAMP: ");
__sb.Append(TIMESTAMP == null ? "<null>" : TIMESTAMP.ToString());
}
if (INTEGER != null && __isset.INTEGER)
{
if (!__first)
{
__sb.Append(", ");
}
__first = false;
__sb.Append("INTEGER: ");
__sb.Append(INTEGER == null ? "<null>" : INTEGER.ToString());
}
if (UNKNOWN != null && __isset.UNKNOWN)
{
if (!__first)
{
__sb.Append(", ");
}
__first = false;
__sb.Append("UNKNOWN: ");
__sb.Append(UNKNOWN == null ? "<null>" : UNKNOWN.ToString());
}
if (JSON != null && __isset.JSON)
{
if (!__first)
{
__sb.Append(", ");
}
__first = false;
__sb.Append("JSON: ");
__sb.Append(JSON == null ? "<null>" : JSON.ToString());
}
if (BSON != null && __isset.BSON)
{
if (!__first)
{
__sb.Append(", ");
}
__first = false;
__sb.Append("BSON: ");
__sb.Append(BSON == null ? "<null>" : BSON.ToString());
}
if (UUID != null && __isset.UUID)
{
if (!__first)
{
__sb.Append(", ");
}
__first = false;
__sb.Append("UUID: ");
__sb.Append(UUID == null ? "<null>" : UUID.ToString());
}
__sb.Append(")");
return(__sb.ToString());
}
public static Record FromDatarow(DataRow dr)
{
var rec = new Record();
var i = -1;
rec.Id = (int)dr[++i];
var date = new DATE((DateTime)dr[++i]);
rec.Date = date;
var frame = new double[6];
var axis = new double[6];
frame[0] = (double)dr[++i];
frame[1] = (double)dr[++i];
frame[2] = (double)dr[++i];
frame[3] = (double)dr[++i];
frame[4] = (double)dr[++i];
frame[5] = (double)dr[++i];
axis[0] = (double)dr[++i];
axis[1] = (double)dr[++i];
axis[2] = (double)dr[++i];
axis[3] = (double)dr[++i];
axis[4] = (double)dr[++i];
axis[5] = (double)dr[++i];
var s = (int)dr[++i];
var t = (int)dr[++i];
rec.POS_ACT = new E6POS(frame, axis, s, t);
frame[0] = (double)dr[++i];
frame[1] = (double)dr[++i];
frame[2] = (double)dr[++i];
frame[3] = (double)dr[++i];
frame[4] = (double)dr[++i];
frame[5] = (double)dr[++i];
axis[0] = (double)dr[++i];
axis[1] = (double)dr[++i];
axis[2] = (double)dr[++i];
axis[3] = (double)dr[++i];
axis[4] = (double)dr[++i];
axis[5] = (double)dr[++i];
rec.AXIS_ACT = new E6AXIS(frame, axis);
frame[0] = (double)dr[++i];
frame[1] = (double)dr[++i];
frame[2] = (double)dr[++i];
frame[3] = (double)dr[++i];
frame[4] = (double)dr[++i];
frame[5] = (double)dr[++i];
rec.BASE = new FRAME(frame);
frame[0] = (double)dr[++i];
frame[1] = (double)dr[++i];
frame[2] = (double)dr[++i];
frame[3] = (double)dr[++i];
frame[4] = (double)dr[++i];
frame[5] = (double)dr[++i];
rec.TOOL = new FRAME(frame);
return(rec);
}
public static extern bool EnumDateFormats(DATEFMT_ENUMPROC lpDateFmtEnumProc, uint Locale, DATE dwFlags);
public dynamic GetDate()
{
db.Configuration.ProxyCreationEnabled = false;
try
{
DateTime startOfWeek = DateTime.Today.AddDays(
(int)CultureInfo.CurrentCulture.DateTimeFormat.FirstDayOfWeek -
(int)DateTime.Today.DayOfWeek);
string result = string.Join(",",Enumerable
.Range(7,7)
.Select(i => startOfWeek
.AddDays(i)
.ToString("d MMMM")));
var dates = db.DATEs.ToList();
var selected = (from pd in dates
join od in result.Split(',').ToList() on pd.DATEDESCRIPTION equals od.ToString()
select new
{
DATEDESCRIPTION = pd.DATEDESCRIPTION,
DATEID = pd.DATEID,
}).ToList();
List <DATE> date = new List <DATE>();
foreach (var xx in selected)
{
var fulldate = Convert.ToDateTime(xx.DATEDESCRIPTION + " " + DateTime.Today.Year).ToString("yyyy-MM-dd");
if (Convert.ToDateTime(fulldate) > DateTime.Today)
{
DATE day = new DATE();
day.DATEDESCRIPTION = xx.DATEDESCRIPTION;
day.DATEID = xx.DATEID;
date.Add(day);
}
}
//List<DATE> dates = new List<DATE>();
//List<DATE> da = result.Split(',').ToList();
//foreach (var x in result.ToList())
//{
// DATE date = new DATE();
// date.DATEDESCRIPTION=db.DATEs.Where(jj=>jj.DATEDESCRIPTION==x)
// dates.Add(date);
//}
// var query = db.DATEs
//.Where(item => item.DATEDESCRIPTION.Any(j => dates.Contains(j.ToString())));
return(date);
}
catch (Exception)
{
dynamic User = new ExpandoObject();
User.Message = "Something went wrong !";
return(null);
}
}
/// <summary>
/// Initializes a new instance of the <see cref="TIMESTAMP"/> structure with an <see
/// cref="IDATE"/> instance.
/// </summary>
/// <param name="other">The <see cref="IDATE"/> instance that initializes this instance.</param>
public TIMESTAMP(DATE other) : this(other.FULLYEAR, other.MONTH, other.MDAY, 0, 0, 0)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="DATE_TIME"/> structure with an <see
/// cref="IDATE"/> instance.
/// </summary>
/// <param name="other">The <see cref="IDATE"/> instance that initializes this instance.</param>
public DATE_TIME(DATE other) : this(other.FULLYEAR, other.MONTH, other.MDAY, 0, 0, 0)
{
}
public Stack(string name, string organization) : this()
{
owner = new Owner(name, organization);
date = new DATE();
}
public AdsErrorCode ReadAny(uint indexGroup, uint indexOffset, Type type, bool throwAdsException, out object value)
{
AdsErrorCode code;
if (!type.IsPrimitive)
{
if (type == typeof(string))
{
throw new ArgumentException("Use overload ReadAnyString(uint indexGroup, uint indexOffset, Type type, int characters) for strings.", "type");
}
if (type.IsArray)
{
throw new ArgumentException("Use overload ReadAny(uint indexGroup, uint indexOffset, Type type, int[] args) for arrays.", "type");
}
if (type == typeof(TimeSpan))
{
uint milliseconds = base.ReadUInt32(indexGroup, indexOffset, throwAdsException, out code);
value = PlcOpenTimeConverter.MillisecondsToTimeSpan(milliseconds);
}
else if (type == typeof(DateTime))
{
uint dateValue = base.ReadUInt32(indexGroup, indexOffset, throwAdsException, out code);
value = PlcOpenDateConverterBase.ToDateTime(dateValue);
}
else if (type == typeof(TIME))
{
uint timeValue = base.ReadUInt32(indexGroup, indexOffset, throwAdsException, out code);
value = new TIME(timeValue);
}
else if (type == typeof(LTIME))
{
ulong timeValue = base.ReadUInt64(indexGroup, indexOffset, throwAdsException, out code);
value = new LTIME(timeValue);
}
else if (type == typeof(TOD))
{
uint time = base.ReadUInt32(indexGroup, indexOffset, throwAdsException, out code);
value = new TOD(time);
}
else if (type == typeof(DATE))
{
uint dateValue = base.ReadUInt32(indexGroup, indexOffset, throwAdsException, out code);
value = new DATE(dateValue);
}
else if (type != typeof(DT))
{
value = base.ReadStruct(indexGroup, indexOffset, type, throwAdsException, out code);
}
else
{
uint dateValue = base.ReadUInt32(indexGroup, indexOffset, throwAdsException, out code);
value = new DT(dateValue);
}
}
else if (type == typeof(bool))
{
value = base.ReadBoolean(indexGroup, indexOffset, throwAdsException, out code);
}
else if (type == typeof(int))
{
value = base.ReadInt32(indexGroup, indexOffset, throwAdsException, out code);
}
else if (type == typeof(short))
{
value = base.ReadInt16(indexGroup, indexOffset, throwAdsException, out code);
}
else if (type == typeof(byte))
{
value = base.ReadUInt8(indexGroup, indexOffset, throwAdsException, out code);
}
else if (type == typeof(float))
{
value = base.ReadReal32(indexGroup, indexOffset, throwAdsException, out code);
}
else if (type == typeof(double))
{
value = base.ReadReal64(indexGroup, indexOffset, throwAdsException, out code);
}
else if (type == typeof(long))
{
value = base.ReadInt64(indexGroup, indexOffset, throwAdsException, out code);
}
else if (type == typeof(uint))
{
value = base.ReadUInt32(indexGroup, indexOffset, throwAdsException, out code);
}
else if (type == typeof(ushort))
{
value = base.ReadUInt16(indexGroup, indexOffset, throwAdsException, out code);
}
else if (type == typeof(ulong))
{
value = base.ReadUInt64(indexGroup, indexOffset, throwAdsException, out code);
}
else
{
if (type != typeof(sbyte))
{
throw new ArgumentException("Unable to marshal type.", "type");
}
value = base.ReadInt8(indexGroup, indexOffset, throwAdsException, out code);
}
return(code);
}
public static extern int GetDateFormat(
uint Locale, DATE dwFlags, [In] IntPtr lpDate, [In] [MarshalAs(UnmanagedType.LPTStr)] string lpFormat,
[Out] [MarshalAs(UnmanagedType.LPTStr)] StringBuilder lpDateStr, int cchDate);
public string OutString(Doct_shedule ds)
{
return(ds.DCODE + ";" + ds.CHAIR + ";" + DATE.ToString("yyyy-MM-dd HH:mm:ss.fff") + ";" + ST_HOUR + ";" + ST_MIN + ";" + END_HOUR + ";" + END_MIN + ";" + INTERVAL + ";" + ds.FILID);
}
