public cArticle(SqlString artName, SqlString artField, SqlString artMag, SqlDateTime artDate)
 {
     strName = artName;
     strField = artField;
     strMagazine = artMag;
     dtmDate = artDate;
 }

        /// <summary>
        /// full constructor 
        /// </summary>
        ///
        public TabRescenCourseInfo(String FCourseId_0, String FCourseName_1,
				String FCourseNo_2, String FParentId_3, Int32 FSortCode_4,
				String FCoursePath_5, String FCoursetypeId_6, Int32 FCourseformatId_7,
				String FSupplierId_8, String FSysuserId_9, SqlDateTime FCreateTime_10,
				String FTecherName_11, String FLevelId_12, Int32 FChapterNums_13,
				Int32 FCourseScores_14, Int32 FCourseHours_15, Double FStudyDuration_16,
				Double FCoursePrice_17, String FCourseDesc_18, Int32 FVerifyStatus_19,
				Int32 FUseStatus_20, Int32 FIsSell_21)
        {
            this.FCourseId = FCourseId_0;
            this.FCourseName = FCourseName_1;
            this.FCourseNo = FCourseNo_2;
            this.FParentId = FParentId_3;
            this.FSortCode = FSortCode_4;
            this.FCoursePath = FCoursePath_5;
            this.FCoursetypeId = FCoursetypeId_6;
            this.FCourseformatId = FCourseformatId_7;
            this.FSupplierId = FSupplierId_8;
            this.FSysuserId = FSysuserId_9;
            this.FCreateTime = FCreateTime_10;
            this.FTecherName = FTecherName_11;
            this.FLevelId = FLevelId_12;
            this.FChapterNums = FChapterNums_13;
            this.FCourseScores = FCourseScores_14;
            this.FCourseHours = FCourseHours_15;
            this.FStudyDuration = FStudyDuration_16;
            this.FCoursePrice = FCoursePrice_17;
            this.FCourseDesc = FCourseDesc_18;
            this.FVerifyStatus = FVerifyStatus_19;
            this.FUseStatus = FUseStatus_20;
            this.FIsSell = FIsSell_21;
        }

 public static object Box(SqlDateTime a)
 {
     if (a.IsNull)
         return null;
     else
         return a.Value;
 }

 public SqlDateTimeTest()
 {
     CultureInfo.CurrentCulture = new CultureInfo("en-US");
     _test1 = new SqlDateTime(2002, 10, 19, 9, 40, 0);
     _test2 = new SqlDateTime(2003, 11, 20, 10, 50, 1);
     _test3 = new SqlDateTime(2003, 11, 20, 10, 50, 1);
 }

 public SqlDateTime(int year, int month, int day, int hour, int minute, int second, double millisecond)
 {
     if (((year >= MinYear) && (year <= MaxYear)) && ((month >= 1) && (month <= 12)))
     {
         int[] numArray = IsLeapYear(year) ? DaysToMonth366 : DaysToMonth365;
         if ((day >= 1) && (day <= (numArray[month] - numArray[month - 1])))
         {
             int num2 = year - 1;
             int dayTicks = ((((((num2 * 0x16d) + (num2 / 4)) - (num2 / 100)) + (num2 / 400)) + numArray[month - 1]) + day) - 1;
             dayTicks -= DayBase;
             if (((((dayTicks >= MinDay) && (dayTicks <= MaxDay)) && ((hour >= 0) && (hour < 0x18))) && (((minute >= 0) && (minute < 60)) && ((second >= 0) && (second < 60)))) && ((millisecond >= 0.0) && (millisecond < 1000.0)))
             {
                 double num4 = (millisecond * SQLTicksPerMillisecond) + 0.5;
                 int timeTicks = (((hour * SQLTicksPerHour) + (minute * SQLTicksPerMinute)) + (second * SQLTicksPerSecond)) + ((int) num4);
                 if (timeTicks > MaxTime)
                 {
                     timeTicks = 0;
                     dayTicks++;
                 }
                 this = new SqlDateTime(dayTicks, timeTicks);
                 return;
             }
         }
     }
     throw new SqlTypeException(SQLResource.InvalidDateTimeMessage);
 }

        public string GetGroupChangeInformationBetweenDates(SqlDateTime begin, SqlDateTime end)
        {
            string blank = "";
            Collection<RequestForm> forms = GetApprovedRequestsBetweenDates(begin, end);
            List<string> groups = _dataRequest.GetAllGroups();
            Dictionary<string, int> groupCount = new Dictionary<string, int>();

            foreach (string entry in groups)
            {
                groupCount.Add(entry, 0);
            }

            foreach (RequestForm entry in forms)
            {
                if (entry != null)
                {
                    string pastGroup = entry.Current.BazookaInfo.Group;
                    string futureGroup = entry.Future.BazookaInfo.Group;
                    if (groupCount.ContainsKey(pastGroup))
                        groupCount[pastGroup]--;

                    if (groupCount.ContainsKey(futureGroup))
                        groupCount[futureGroup]++;
                }
            }

            foreach (string entry in groups)
            {
                if (groupCount[entry] != 0)
                    blank += String.Format("Group {0} changed by {1} people\n", entry, groupCount[entry]);
            }

            return blank;
        }

                public void GetReady() 
		{
			Thread.CurrentThread.CurrentCulture = new CultureInfo ("en-US");
			Test1 = new SqlDateTime (2002, 10, 19, 9, 40, 0);
			Test2 = new SqlDateTime (2003, 11, 20,10, 50, 1);
			Test3 = new SqlDateTime (2003, 11, 20, 10, 50, 1);
		}

        public static void AddContainerACL(
            SqlString accountName, SqlString sharedKey, SqlBoolean useHTTPS,
            SqlString containerName,
            SqlString containerPublicReadAccess,
            SqlString accessPolicyId,
            SqlDateTime start, SqlDateTime expiry,
            SqlBoolean canRead,
            SqlBoolean canWrite,
            SqlBoolean canDeleteBlobs,
            SqlBoolean canListBlobs,
            SqlGuid LeaseId,
            SqlInt32 timeoutSeconds,
            SqlGuid xmsclientrequestId)
        {
            Enumerations.ContainerPublicReadAccess cpraNew;
            if(!Enum.TryParse<Enumerations.ContainerPublicReadAccess>(containerPublicReadAccess.Value, out cpraNew))
            {
                StringBuilder sb = new StringBuilder("\"" + containerPublicReadAccess.Value + "\" is an invalid ContainerPublicReadAccess value. Valid values are: ");
                foreach (string s in Enum.GetNames(typeof(Enumerations.ContainerPublicReadAccess)))
                    sb.Append("\"" + s + "\" ");
                throw new ArgumentException(sb.ToString());
            }

            AzureBlobService abs = new AzureBlobService(accountName.Value, sharedKey.Value, useHTTPS.Value);
            Container cont = abs.GetContainer(containerName.Value);

            Enumerations.ContainerPublicReadAccess cpra;
            SharedAccessSignature.SharedAccessSignatureACL sasACL = cont.GetACL(out cpra,
                LeaseId.IsNull ? (Guid?)null : LeaseId.Value,
                timeoutSeconds.IsNull ? 0 : timeoutSeconds.Value,
                xmsclientrequestId.IsNull ? (Guid?)null : xmsclientrequestId.Value);

            string strPermissions = "";
            if (canRead.IsTrue)
                strPermissions += "r";
            if (canWrite.IsTrue)
                strPermissions += "w";
            if (canDeleteBlobs.IsTrue)
                strPermissions += "d";
            if (canListBlobs.IsTrue)
                strPermissions += "l";

            SharedAccessSignature.AccessPolicy ap = new SharedAccessSignature.AccessPolicy()
            {
                Start = start.Value,
                Expiry = expiry.Value,
                Permission = strPermissions
            };

            sasACL.SignedIdentifier.Add(new SharedAccessSignature.SignedIdentifier()
                {
                    AccessPolicy = ap,
                    Id = accessPolicyId.Value
                });

            cont.UpdateContainerACL(cpraNew, sasACL,
                LeaseId.IsNull ? (Guid?)null : LeaseId.Value,
                timeoutSeconds.IsNull ? 0 : timeoutSeconds.Value,
                xmsclientrequestId.IsNull ? (Guid?)null : xmsclientrequestId.Value);
        }

                public void GetReady() 
		{
            Windows.Globalization.ApplicationLanguages.PrimaryLanguageOverride = "en-US";
			Test1 = new SqlDateTime (2002, 10, 19, 9, 40, 0);
			Test2 = new SqlDateTime (2003, 11, 20,10, 50, 1);
			Test3 = new SqlDateTime (2003, 11, 20, 10, 50, 1);
		}

 public static SqlDateTime ParamDateTimeTemp(SqlXml Xml, SqlString Name)
 {
     String ValueType;
       String Value = GetValueFromXMLAttribute(Xml, Name, out ValueType);
       if (Value == null) return new SqlDateTime();
       SqlDateTime Result;
       try
       {
     Result = new SqlDateTime(XmlConvert.ToDateTime(Value, XmlDateTimeSerializationMode.RoundtripKind));
       }
       catch (Exception Error)
       {
     throw new System.Exception("Error convert Param = \"" + Name.Value.ToString() + "\" Value = \"" + Value.ToString() + "\" to DateTime: " + Error.Message);
       }
       if (ValueType != null && ValueType != "")
       {
     // year, month, day, hour, minute, second
     switch (ValueType)
     {
       case "1": return Result.Value.Date.AddDays(1);
       default: return Result;
     }
       }
       return Result;
 }

    public static SqlDateTime LocalizeDT(SqlDateTime dt)
    {
        if (dt.IsNull)
               return new SqlDateTime();

          return new SqlDateTime(dt.Value.ToLocalTime());
    }

    public static void spGetNewVestaErrands(SqlDateTime date)
    {
        DateTime d = date.Value;

        String reqStr = String.Format("http://{0}/services/internalSite/errands/sendNewVestaErrandsMails?date={1}",
                                                                                                                                UserDefinedFunctions.fGetWapServerName(), d.ToString("s"));
        SqlContext.Pipe.Send(reqStr);
        HttpWebRequest rq = (HttpWebRequest)WebRequest.Create(reqStr);
        rq.KeepAlive = false;
        XmlDocument xdoc = new XmlDocument();
        using(HttpWebResponse rs = (HttpWebResponse)rq.GetResponse())
        using(Stream stream = rs.GetResponseStream())
                xdoc.Load(stream);
        XmlNode root = xdoc["result"];

        SqlDataRecord rec = new SqlDataRecord(new SqlMetaData("id", SqlDbType.NVarChar, -1),
                                                                                                                                                                new SqlMetaData("text", SqlDbType.NVarChar, -1),
                                                                                                                                                                new SqlMetaData("creator", SqlDbType.NVarChar, -1),
                                                                                                                                                                new SqlMetaData("email", SqlDbType.NVarChar, -1)
                                                                                                                                                            );
        SqlContext.Pipe.SendResultsStart(rec);
        foreach(XmlNode ch in root.ChildNodes)
        {
            rec.SetValues(ch["id"].InnerText,
                                                                    ch["text"].InnerText,
                                                                    ch["creator"].InnerText,
                                                                    ch["email"].InnerText
                                                                    );
            SqlContext.Pipe.SendResultsRow(rec);
        }
        SqlContext.Pipe.SendResultsEnd();
    }

    public static SqlDouble HR_TimeLogs_TimeSpan(SqlDateTime startAt, SqlDateTime endAt)
    {
        if (endAt.IsNull || startAt.IsNull)
               return new SqlDouble();

          TimeSpan duration = endAt.Value.Subtract(startAt.Value);
          return new SqlDouble(duration.TotalSeconds);
    }

    public static SqlInt32 FN_GER_GetWeekOfYear(SqlDateTime _date)
    {

        System.Globalization.GregorianCalendar gc = new System.Globalization.GregorianCalendar();


        return _date.IsNull ? SqlInt32.Null : gc.GetWeekOfYear(_date.Value, System.Globalization.CalendarWeekRule.FirstFullWeek, DayOfWeek.Monday);
    }

 public static SqlInt32 DayOfWeek(SqlDateTime time) {
     if (time.IsNull) return SqlInt32.Null;
     var numb = (int) time.Value.DayOfWeek;
     if(numb==0) {
         numb = 7;
     }
     return numb;
 }

    public static SqlDateTime YearMonth(SqlDateTime dt)
    {
        if (dt.IsNull)
               return new SqlDateTime();

          System.DateTime moment = dt.Value.ToLocalTime();
          return new SqlDateTime(moment.Year, moment.Month, 1); //.ToString("yyyy-M"));
    }

 internal SqlPersistenceWorkflowInstanceDescription(Guid workflowInstanceId, WorkflowStatus status, bool isBlocked, string suspendOrTerminateDescription, SqlDateTime nextTimerExpiration)
 {
     this.workflowInstanceId = workflowInstanceId;
     this.status = status;
     this.isBlocked = isBlocked;
     this.suspendOrTerminateDescription = suspendOrTerminateDescription;
     this.nextTimerExpiration = nextTimerExpiration;
 }

 public static void FillRow(Object obj, out SqlDateTime timeWritten, out SqlChars message, out SqlChars category, out long instanceId)
 {
     EventLogEntry eventLogEntry = (EventLogEntry)obj;
     timeWritten = new SqlDateTime(eventLogEntry.TimeWritten);
     message = new SqlChars(eventLogEntry.Message);
     category = new SqlChars(eventLogEntry.Category);
     instanceId = eventLogEntry.InstanceId;
 }

    public static SqlDateTime ConvertFromUTC(SqlDateTime SourceDateTime, SqlString DestinationTimeZone)
    {
        if (SourceDateTime.IsNull)
          return SqlDateTime.Null;

        Zone  tzDestination = Database.GetZone(DestinationTimeZone.Value);

        return tzDestination.ConvertToLocal(SourceDateTime.Value);
    }

    public static SqlDateTime ConvertToUTC(SqlDateTime SourceDateTime, SqlString SourceTimeZone)
    {
        if (SourceDateTime.IsNull)
          return SqlDateTime.Null;

        Zone  tzSource      = Database.GetZone(SourceTimeZone.Value);

        return tzSource.ConvertToUtc(SourceDateTime.Value);
    }