Web Development

indian143 wrote:

Can I build an UI using .Net framework.

indian143 wrote:

If so, please advise me how can I do it.

indian143 wrote:

If possible give me some code snippet too.

indian143 wrote:

Otherwise please advise me some thing else too. Please.

if (Request.QueryString("action") == "save")
{
    var publicHoliday = Server.CreateObject("ADODB.Recordset");
    publicHoliday.ActiveConnection = MM_test_STRING;
    publicHoliday.Source = "SELECT * FROM Table1";
    publicHoliday.CursorType = 0;
    publicHoliday.CursorLocation = 2;
    publicHoliday.LockType = 1;
    publicHoliday.Open();

    var dayDate = Request.QueryString("daydate");
    var empCoid = Request.QueryString("coid");
    var Desc = Request.QueryString("desc");
    var setSave = Server.CreateObject("ADODB.Recordset");
    var getPHolidayInfo = Server.CreateObject("ADODB.Recordset");
    var indi = false;

    var getAbsentsCode = Server.CreateObject("ADODB.Recordset");
    getAbsentsCode.ActiveConnection = MM_test_STRING;
    getAbsentsCode.Source = "SELECT * FROM Table2 WHERE DESCRIPTION = "+Desc+"";
    getAbsentsCode.CursorType = 0;
    getAbsentsCode.CursorLocation = 2;
    getAbsentsCode.LockType = 1;
    getAbsentsCode.Open();
    var getCode = getAbsentsCode.Fields.Item("ABSENCECODE").Value;
    if (Request.QueryString("coid") == "" && Request.QueryString("surname") == "")
    {
        while (!publicHoliday.EOF)
        {
            var pDate = publicHoliday.Fields.Item("HOLIDAYDATE").Value; //YYYY-MM-DD
            var pDesc = publicHoliday.Fields.Item("DESCRIPTION").Value;

            if(Desc == "'Public Holiday'")
            {
                indi = false;
            }
            else
            {
                var FormPHYear = String(dayDate).substring(1,5);
                //Response.Write("FormPHYear ->"+FormPHYear);
                var DBPHYear = String(pDate).substring(0,4);
                //Response.Write("DBPHYear ->"+DBPHYear);
                //Response.Write(FormPHYear > DBPHYear);
                if (FormPHYear > DBPHYear)
                {
                    indi = false;
                }
                else
                {
                    if (Desc == "'"+pDesc+"'")
                    {
                         %>

                         <%
                         //Response.End();
                         indi = true;
                    }
                }
            }
            publicHoliday.MoveNext();
        }
        if (indi == false)
        {
            setSave.ActiveConnection = MM_test_STRING;
            setSave.Source = "INSERT INTO Table1(HOLIDAYDATE,DESCRIPTION,ABSENCECODE) VALUES("+dayDate+","+Desc+",'"+getCode+"')";
            setSave.CursorType = 0;
            setSave.CursorLocation = 2;
            setSave.LockType = 1;
            setSave.Open();

            var strOne = new String(dayDate);
            var strTwo = new String(Request.QueryString("enddate"));
            Response.Write(Request.QueryString("action"));
            Response.Write("If Statement -> "+ String(strOne == strTwo));
            Response.Write(strOne);
            Response.Write(strTwo);

            Response.End();

            if (Number(dayDate) == Number(Request.QueryString("enddate")))
            {
                Response.Write("svdvdvdvdvdv");
                Response.End();
                getPHolidayInfo.ActiveConnection = MM_test_STRING;
                getPHolidayInfo.Source = "SELECT * FROM Table2 WHERE DESCRIPTION = 'Public Holiday'";
                getPHolidayInfo.CursorType = 0;
                getPHolidayInfo.CursorLocation = 2;
                getPHolidayInfo.LockType = 1;
                getPHolidayInfo.Open();

                var PHDayDesc = getPHolidayInfo.Fields.Item("DESCRIPTION").Value;
                var PHDayCode = getPHolidayInfo.Fields.Item("ABSENCECODE").Value;

                var PHDay = String(dayDate).substring(9,11);
                PHDay = Number(PHDay)+1;
                if (PHDay < 10)
                {
                    PHDay = '0'+PHDay;
                }
                var PHMonth = String(dayDate).substring(6,8);
                /*if (PHMonth < 10)
                {
                    PHMonth = '0'+PHMonth;
                }*/
                var PHYear = String(dayDate).substring(1,5);
                var PHAll = PHYear+"-"+PHMonth+"-"+PHDay;

                setSave.ActiveConnection = MM_test_STRING;
                setSave.Source = "INSERT INTO ACTA.PHOLIDAY(HOLIDAYDATE,DESCRIPTION,ABSENCECODE) VALUES('"+PHAll+"','"+PHDayDesc+"','"+PHDayCode+"')";
                setSave.CursorType = 0;
                setSave.CursorLocation = 2;
                setSave.LockType = 1;
                setSave.Open();
            }
        }

The only programmers that are better than C programmers are those who code in 1's and 0's.....

Programm3r

Programm3r wrote:

Does this help