Esempio n. 1
0
 protected void btn_ftype_add_Click(object sender, EventArgs e)
 {
     try {
         SqlCommand CheckSub = new SqlCommand();
         CheckSub.Connection  = conn;
         CheckSub.CommandType = CommandType.Text;
         CheckSub.CommandText = "SELECT COUNT(*) FROM FEETYPEFILE WHERE FEETYPE = '" + txt_fee_type.Text + "' and school_code ='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'";
         int SubExists = (int)CheckSub.ExecuteScalar();
         if (SubExists > 0)
         {
             ShowMessage("This Fee Type with id ='" + txt_fee_code.Text + "' is already exists.");
         }
         else
         {
             SqlCommand cmd = new SqlCommand();
             cmd.Connection  = conn;
             cmd.CommandType = CommandType.Text;
             cmd.CommandText = "INSERT INTO FEETYPEFILE (FEECODE,FEETYPE,school_code,branch) VALUES('" + txt_fee_code.Text + "','" + txt_fee_type.Text + "','" + Session["schoolcode"].ToString() + "','" + Session["Branch"].ToString() + "')";
             cmd.ExecuteNonQuery();
             ShowMessage("Recorded To The System Successfully");
             txt_fee_type.Text = "";
             txt_fee_code.Text = Global_Class.GenerateID("select count(*) from FEETYPEFILE where school_code ='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", "FEE#0");
         }
     }
     catch (Exception ex) { ex.ToString(); }
 }
Esempio n. 2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (conn.State == ConnectionState.Open)
            {
                conn.Close();
            }
            conn.Open();
            txt_sub_code.Attributes.Add("readonly", "readonly");
            btn_std_add.Style.Add("background-color", Session["ColorTheme"].ToString());
            txt_sub_code.Text = Global_Class.GenerateID("select count(*) from SUBJECTFILE where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/SUB/");
            //SqlCommand CheckSub = new SqlCommand();
            //CheckSub.Connection = conn;
            //CheckSub.CommandType = CommandType.Text;
            //CheckSub.CommandText = "SELECT COUNT(*) FROM SUBJECTFILE ";
            //int SubExists = (int)CheckSub.ExecuteScalar();

            //if (SubExists == 0)
            //{
            //    lblcount.Visible = true;
            //    lblcount.Text = "No Record Found";
            //}
            //else
            //{
            //    lblcount.Visible = false;
            //    bindGrid();
            //}
        }
Esempio n. 3
0
        protected void btn_add_stream_Click(object sender, EventArgs e)
        {
            try {
                conn.Open();
                SqlCommand CheckSub = new SqlCommand();
                CheckSub.Connection  = conn;
                CheckSub.CommandType = CommandType.Text;
                CheckSub.CommandText = "SELECT COUNT(*) FROM STREAMLIST WHERE ([STREAMNAME] = @STREAMLIST and school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "')";
                CheckSub.Parameters.AddWithValue("@STREAMLIST", txt_stream_name.Text);
                int SubExists = (int)CheckSub.ExecuteScalar();

                if (SubExists > 0)
                {
                    ShowMessage("This Class with name ='" + txt_stream_name.Text + "' is already exists.");
                }

                else
                {
                    SqlCommand cmd = new SqlCommand();
                    cmd.Connection  = conn;
                    cmd.CommandType = CommandType.Text;
                    cmd.CommandText = "insert into STREAMLIST (STREAMCODE,STREAMNAME,school_code,branch) VALUES('" + txt_stram_code.Text + "','" + txt_stream_name.Text + "','" + Session["schoolcode"].ToString() + "','" + Session["Branch"].ToString() + "')";
                    cmd.ExecuteNonQuery();

                    ShowMessage("Recorded To The System Successfully");
                    txt_stream_name.Text = "";
                    txt_stram_code.Text  = Global_Class.GenerateID("select count(*) from STREAMLIST where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/STREAM/");
                }
                conn.Close();
            }
            catch (Exception ex) { ex.ToString(); }
        }
Esempio n. 4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                }
                conn.Open();
                txt_empid.Attributes.Add("readonly", "readonly");
                txt_empid.Text = Global_Class.GenerateID("select count(*) from ADDEMPLOYEE where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/EMP/");

                var gender = new List <string> {
                    "Male",
                    "Female"
                };
                gender.Sort();

                var jtyp = new List <string> {
                    "Full Time",
                    "Part Time",
                    "Freelancer"
                };
                jtyp.Sort();

                lst_gender.DataSource = gender;
                lst_gender.DataBind();

                lst_toe.DataSource = jtyp;
                lst_toe.DataBind();
            }
        }
Esempio n. 5
0
 protected void Unnamed1_Click(object sender, EventArgs e)
 {
     try
     {
         SqlCommand check_User_Name = new SqlCommand("SELECT COUNT(*) FROM [tbl_UserFIle] WHERE ([USERID] = @USERID and school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "')", conn);
         check_User_Name.Parameters.AddWithValue("@USERID", txt_user_id.Text);
         int UserExist = (int)check_User_Name.ExecuteScalar();
         if (UserExist > 0)
         {
             ShowMessage("UserID Already Exists");
         }
         else
         {
             SqlCommand cmd_user = new SqlCommand();
             cmd_user.Connection = conn;
             if (conn.State == ConnectionState.Open)
             {
                 conn.Close();
             }
             conn.Open();
             cmd_user.CommandType = CommandType.Text;
             cmd_user.CommandText = "INSERT INTO tbl_UserFile (USERID,USERTYPE,EMPID,USERNAME,LOGINID,LOGINPSWD,CREATEDBY,DATEANDTIME,MAC,school_code,branch) VALUES('" + txt_user_id.Text.ToString() + "','" + drp_user_type.SelectedItem.ToString() + "','" + emp_id_list.SelectedItem.ToString() + "','" + txt_user_name.Text + "','" + txt_login_id.Text + "','" + txt_user_password.Text + "','" + Session["uname"].ToString() + "','" + System.DateTime.Now.ToString() + "','" + Global_Class.getFormatMac(Global_Class.GetMACAddress()).ToString() + "','" + Session["schoolcode"].ToString() + "','" + Session["Branch"].ToString() + "')";
             int i = cmd_user.ExecuteNonQuery();
             if (i > 0)
             {
                 ShowMessage("User Created.");
                 txt_user_id.Text = txt_user_name.Text = txt_login_id.Text = txt_user_password.Text = String.Empty;
                 txt_user_id.Text = Global_Class.GenerateID("select count(*) from tbl_UserFile where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/USER/");
             }
         }
     }
     catch (Exception ex) { ex.ToString(); }
 }
Esempio n. 6
0
        protected void btn_std_add_Click(object sender, EventArgs e)
        {
            try {
                SqlCommand CheckSub = new SqlCommand();
                CheckSub.Connection  = conn;
                CheckSub.CommandType = CommandType.Text;
                CheckSub.CommandText = "SELECT COUNT(*) FROM SUBJECTFILE WHERE ([SUBJECTNAME] = @subjectcode and school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "')";
                CheckSub.Parameters.AddWithValue("@subjectcode", txt_sub_name.Text);
                int SubExists = (int)CheckSub.ExecuteScalar();

                if (SubExists > 0)
                {
                    ShowMessage("This subject with id ='" + txt_sub_code.Text + "' is already exists.");
                }

                else
                {
                    SqlCommand cmd = new SqlCommand("addsubject", conn);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.Add("@SUBJECTCODE", SqlDbType.VarChar, 50).Value  = txt_sub_code.Text.ToString();
                    cmd.Parameters.Add("@SUBJECTNAME", SqlDbType.VarChar, 50).Value  = txt_sub_name.Text.ToString();
                    cmd.Parameters.Add("@school_code", SqlDbType.VarChar, 100).Value = Session["schoolcode"].ToString();
                    cmd.Parameters.Add("@branch", SqlDbType.VarChar, 100).Value      = Session["Branch"].ToString();
                    cmd.ExecuteNonQuery();
                    ShowMessage("Recorded To The System Successfully");

                    txt_sub_name.Text = "";
                    txt_sub_code.Text = Global_Class.GenerateID("select count(*) from SUBJECTFILE where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/SUB/");
                }
            }
            catch (Exception ex) { ex.ToString(); }
        }
Esempio n. 7
0
        protected void btn_section_add_Click(object sender, EventArgs e)
        {
            try
            {
                SqlCommand CheckSub = new SqlCommand();
                CheckSub.Connection  = conn;
                CheckSub.CommandType = CommandType.Text;
                CheckSub.CommandText = "SELECT COUNT(*) FROM sections WHERE ([section_name] = @section_name and school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "' )";
                CheckSub.Parameters.AddWithValue("@section_name", txt_section_name.Text);
                int SubExists = (int)CheckSub.ExecuteScalar();

                if (SubExists > 0)
                {
                    ShowMessage("This section with id ='" + txt_section_name.Text + "' is already exists.");
                }

                else
                {
                    SqlCommand cmd = new SqlCommand();
                    cmd.Connection  = conn;
                    cmd.CommandType = CommandType.Text;
                    cmd.CommandText = "insert into sections (section_id,section_name,school_code,branch) VALUES('" + txt_section_id.Text + "','" + txt_section_name.Text + "','" + Session["schoolcode"].ToString() + "','" + Session["Branch"].ToString() + "')";
                    cmd.ExecuteNonQuery();
                    ShowMessage("Recorded To The System Successfully");
                    txt_section_id.Text   = Global_Class.GenerateID("select count(*) from sections where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/SEC/");
                    txt_section_name.Text = "";
                }
            }
            catch (Exception ex) { ex.ToString(); }
        }
Esempio n. 8
0
        //string GenRoleID()
        //{
        //    string str = "select count(*) from tbl_RoleName where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'";
        //    SqlCommand com = new SqlCommand();
        //    com.Connection = conn;
        //    if (conn.State==ConnectionState.Open)
        //    {
        //        conn.Close();
        //    }
        //    conn.Open();
        //    com.CommandType = CommandType.Text;
        //    com.CommandText = str;
        //    int count = Convert.ToInt32(com.ExecuteScalar()) + 1;
        //    txt_role_id.Text = "Role00" + count.ToString();
        //    txt_role_id.Attributes.Add("readonly", "readonly");
        //    return "Role00" + count.ToString();
        //}

        protected void btn_ok_Click(object sender, EventArgs e)
        {
            try {
                SqlCommand cmd_Roles = new SqlCommand();
                cmd_Roles.Connection = conn;
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                }
                conn.Open();
                cmd_Roles.CommandType = CommandType.Text;
                cmd_Roles.CommandText = "INSERT INTO tbl_RoleName" +
                                        " (role_id,role_name,created_by,creation_dt,client_mac,school_code,branch)" +
                                        " values('" + txt_role_id.Text.ToString() + "'," +
                                        "'" + txt_name.Text + "'," +
                                        "'" + Session["uname"].ToString() + "'," +
                                        "'" + System.DateTime.Now.ToString() + "'," +
                                        "'" + Global_Class.getFormatMac(Global_Class.GetMACAddress()).ToString() + "'," +
                                        "'" + Session["schoolcode"].ToString() + "'," +
                                        "'" + Session["Branch"].ToString() + "')";
                int i = cmd_Roles.ExecuteNonQuery();
                if (i > 0)
                {
                    ShowMessage("New role created.");
                    txt_name.Text    = String.Empty;
                    txt_role_id.Text = Global_Class.GenerateID("select count(*) from tbl_RoleName where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/Role00/");
                }
                else
                {
                    ShowMessage("Something went worng. Please Try Again.");
                    txt_role_id.Text = Global_Class.GenerateID("select count(*) from tbl_RoleName where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/Role00/");
                }
            }
            catch (Exception ex) { ex.ToString(); }
        }
Esempio n. 9
0
 protected void Page_Load(object sender, EventArgs e)
 {
     txt_id.Attributes.Add("readonly", "readonly");
     txt_id.Text = Global_Class.GenerateID("select count(*) from tbl_Buildings where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "' ", Session["schoolcode"] + "/Build/");
     if (!IsPostBack)
     {
         FillCountry();
     }
 }
Esempio n. 10
0
 protected void btn_add_Click(object sender, EventArgs e)
 {
     try {
         //ShowMessage("Hello");
         SqlCommand CheckBuild = new SqlCommand();
         CheckBuild.Connection = conn;
         if (conn.State == ConnectionState.Open)
         {
             conn.Close();
         }
         conn.Open();
         CheckBuild.CommandType = CommandType.Text;
         CheckBuild.CommandText = "SELECT COUNT (*) FROM tbl_Buildings where build_name='" + txt_building.Text + "' and school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "' ";
         int i = (int)CheckBuild.ExecuteScalar();
         if (i > 0)
         {
             ShowMessage("This building is already registered.");
         }
         else
         {
             SqlCommand insBuild = new SqlCommand();
             insBuild.Connection = conn;
             if (conn.State == ConnectionState.Open)
             {
                 conn.Close();
             }
             conn.Open();
             insBuild.CommandType = CommandType.StoredProcedure;
             insBuild.CommandText = "InsertBuild";
             insBuild.Parameters.Add("@build_id", SqlDbType.VarChar, 100).Value       = txt_id.Text.ToString();
             insBuild.Parameters.Add("@build_for", SqlDbType.VarChar, 100).Value      = drp_hostel_for.SelectedItem.ToString();
             insBuild.Parameters.Add("@build_name", SqlDbType.VarChar, 50).Value      = txt_building.Text.ToString();
             insBuild.Parameters.Add("@build_no", SqlDbType.VarChar, 100).Value       = txt_buildingno.Text.ToString();
             insBuild.Parameters.Add("@build_area", SqlDbType.VarChar, 100).Value     = txt_locality.Text.ToString();
             insBuild.Parameters.Add("@build_landmark", SqlDbType.VarChar, 100).Value = txt_landmark.Text.ToString();
             insBuild.Parameters.Add("@build_country", SqlDbType.VarChar, 100).Value  = country_list.SelectedItem.ToString();
             insBuild.Parameters.Add("@build_state", SqlDbType.VarChar, 100).Value    = state_list.SelectedItem.Text.ToString();
             insBuild.Parameters.Add("@build_city", SqlDbType.VarChar, 100).Value     = city_list.SelectedItem.ToString();
             insBuild.Parameters.Add("@build_contact", SqlDbType.VarChar, 100).Value  = txt_emg_co.Text.ToString();
             insBuild.Parameters.Add("@build_storey", SqlDbType.VarChar, 100).Value   = txt_storey.Text.ToString();
             insBuild.Parameters.Add("@build_rooms", SqlDbType.VarChar, 100).Value    = txt_total_rooms.Text.ToString();
             insBuild.Parameters.Add("@school", SqlDbType.VarChar, 100).Value         = getScoolName().ToString();
             insBuild.Parameters.Add("@branch", SqlDbType.VarChar, 100).Value         = Session["Branch"].ToString();
             insBuild.Parameters.Add("@created_by", SqlDbType.VarChar, 100).Value     = Session["uname"].ToString();
             insBuild.Parameters.Add("@date_time", SqlDbType.VarChar, 100).Value      = System.DateTime.Now;
             insBuild.Parameters.Add("@client_mac", SqlDbType.VarChar, 100).Value     = Global_Class.getFormatMac(Global_Class.GetMACAddress()).ToString();
             insBuild.Parameters.Add("@school_code", SqlDbType.VarChar, 100).Value    = Session["schoolcode"].ToString();
             insBuild.Parameters.Add("@branch", SqlDbType.VarChar, 100).Value         = Session["Branch"].ToString();
             insBuild.ExecuteNonQuery();
             ShowMessage("Build has been saved successfully.");
             txt_id.Text = Global_Class.GenerateID("select count(*) from tbl_Buildings where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "' ", "Build#0");
             FillCountry();
             txt_building.Text = txt_buildingno.Text = txt_emg_co.Text = txt_landmark.Text = txt_locality.Text = txt_storey.Text = txt_total_rooms.Text = String.Empty;
         }
     }
     catch (Exception ex) { ex.ToString(); }
 }
Esempio n. 11
0
        protected void btn_add_Click(object sender, EventArgs e)
        {
            try
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = "insert into ADDEMPLOYEE(SCHOOL_CODE,BRANCH,EMPLOYEE_ID,FIRSTNAME,LASTNAME,GENDER,DOB,PHONENO,ADDRESS1,ADDRESS2,CITY,STATE,COUNTRY,EMERGENCYNO,RELATION,DOJ,DESIGNATION,OFFICIALEMAILID,TYPEOFEMPLOYEE,BANKNAME,ACNO,IFSCCODE,PANNO,PFNO,UANNO,BASICSALARY,HRA,CONVEYANCE)" +
                                  "values('" + Session["schoolcode"].ToString() + "','" + Session["Branch"].ToString() + "','" + txt_empid.Text.ToString() + "'," +
                                  "'" + txt_fname.Text.ToString() + "','" + txt_lname.Text.ToString() + "','" + lst_gender.SelectedItem.Text.ToString() + "'," +
                                  "'" + txt_dob.Text.ToString() + "','" + txt_phone.Text.ToString() + "','" + txt_add1.Text.ToString() + "','" + txt_add2.Text.ToString() + "'," +
                                  "'" + txt_city.Text.ToString() + "','" + txt_state.Text.ToString() + "','" + txt_country.Text.ToString() + "','" + txt_emg_co.Text.ToString() + "'," +
                                  "'" + txt_emg_name.Text.ToString() + "','" + txt_doj.Text.ToString() + "','" + txt_designation.Text.ToString() + "','" + txt_email.Text.ToString() + "'," +
                                  "'" + lst_toe.SelectedItem.Text.ToString() + "','" + txt_bank.Text.ToString() + "','" + txt_acc.Text.ToString() + "'," +
                                  "'" + txt_ifsc.Text.ToString() + "','" + TextBox12.Text.ToString() + "','" + txt_pf.Text.ToString() + "','" + txt_uan.Text.ToString() + "'," +
                                  "'" + txt_bs.Text.ToString() + "','" + txt_hra.Text.ToString() + "','" + txt_convey.Text.ToString() + "')";

                //cmd.Parameters.Add("@SCHOOL_CODE", SqlDbType.VarChar, 50).Value = Session["schoolcode"].ToString();
                //cmd.Parameters.Add("@BRANCH", SqlDbType.VarChar, 50).Value = Session["Branch"].ToString();
                //cmd.Parameters.Add("@EMPLOYEE_ID", SqlDbType.VarChar).Value = txt_empid.Text.ToString();
                //cmd.Parameters.Add("@FIRSTNAME", SqlDbType.VarChar, 50).Value = txt_fname.Text.ToString();
                //cmd.Parameters.Add("@LASTNAME", SqlDbType.VarChar, 50).Value = txt_lname.Text.ToString();
                //cmd.Parameters.Add("@GENDER", SqlDbType.VarChar, 50).Value = lst_gender.SelectedItem.Text.ToString();
                //cmd.Parameters.Add("@DOB", SqlDbType.VarChar, 50).Value = txt_dob.Text.ToString();
                //cmd.Parameters.Add("@PHONENO", SqlDbType.VarChar, 50).Value = txt_phone.Text.ToString();
                //cmd.Parameters.Add("@ADDRESS1", SqlDbType.VarChar, 50).Value = txt_add1.Text.ToString();
                //cmd.Parameters.Add("@ADDRESS2", SqlDbType.VarChar, 50).Value = txt_add2.Text.ToString();
                //cmd.Parameters.Add("@CITY", SqlDbType.VarChar, 50).Value = txt_city.Text.ToString();
                //cmd.Parameters.Add("@STATE", SqlDbType.VarChar, 50).Value = txt_state.Text.ToString();
                //cmd.Parameters.Add("@COUNTRY", SqlDbType.VarChar, 50).Value = txt_country.Text.ToString();
                //cmd.Parameters.Add("@EMERGENCYNO", SqlDbType.VarChar, 50).Value = txt_emg_co.Text.ToString();
                //cmd.Parameters.Add("@RELATION", SqlDbType.VarChar, 50).Value = txt_emg_name.Text.ToString();
                //cmd.Parameters.Add("@DOJ", SqlDbType.VarChar, 50).Value = txt_doj.Text.ToString();
                //cmd.Parameters.Add("@DESIGNATION", SqlDbType.VarChar, 50).Value = txt_designation.Text.ToString();
                //cmd.Parameters.Add("@OFFICIALEMAILID", SqlDbType.VarChar, 50).Value = txt_email.Text.ToString();
                //cmd.Parameters.Add("@TYPEOFEMPLOYEE", SqlDbType.VarChar, 50).Value = lst_toe.SelectedItem.Text.ToString();
                //cmd.Parameters.Add("@BANKNAME", SqlDbType.VarChar, 50).Value = txt_bank.Text.ToString();
                //cmd.Parameters.Add("@ACNO", SqlDbType.VarChar, 50).Value = txt_acc.Text.ToString();
                //cmd.Parameters.Add("@IFSCCODE", SqlDbType.VarChar, 50).Value = txt_ifsc.Text.ToString();
                //cmd.Parameters.Add("@PANNO", SqlDbType.VarChar, 50).Value = TextBox12.Text.ToString();
                //cmd.Parameters.Add("@PFNO", SqlDbType.VarChar, 50).Value = txt_pf.Text.ToString();
                //cmd.Parameters.Add("@UANNO", SqlDbType.VarChar, 50).Value = txt_uan.Text.ToString();
                //cmd.Parameters.Add("@BASICSALARY", SqlDbType.VarChar, 50).Value = txt_bs.Text.ToString();
                //cmd.Parameters.Add("@HRA", SqlDbType.VarChar, 50).Value = txt_hra.Text.ToString();
                //cmd.Parameters.Add("@CONVEYANCE", SqlDbType.VarChar, 50).Value = txt_convey.Text.ToString();

                cmd.ExecuteNonQuery();
                ShowMessage("Added Successfully");
                txt_empid.Text = Global_Class.GenerateID("select count(*) from ADDEMPLOYEE where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/EMP/");
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
        }
Esempio n. 12
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (conn.State == ConnectionState.Open)
     {
         conn.Close();
     }
     conn.Open();
     txt_routeid.Text    = Global_Class.GenerateID("select count(*) from ROUTE where  school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/ROUTE/");
     txt_routeid.Enabled = false;
 }
Esempio n. 13
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (conn.State == ConnectionState.Open)
     {
         conn.Close();
     }
     conn.Open();
     txt_user_id.Attributes.Add("readonly", "readonly");
     txt_user_id.Text = Global_Class.GenerateID("select count(*) from tbl_UserFile where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/USER/");
 }
Esempio n. 14
0
 protected void Crt_route(object sender, EventArgs e)
 {
     try {
         string     str = "insert into ROUTE (ROUTEID,ROUTENAME,AREA,school_code,branch) values('" + txt_routeid.Text + "','" + txt_routename.Text + "','" + txt_area.Text + "', '" + Session["schoolcode"].ToString() + "','" + Session["Branch"].ToString() + "')";
         SqlCommand cmd = new SqlCommand(str, conn);
         cmd.ExecuteNonQuery();
         ShowMessage("Route Created");
         txt_routeid.Text = Global_Class.GenerateID("select count(*) from ROUTE where  school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/ROUTE/");
     }
     catch (Exception ex) { ex.ToString(); }
 }
Esempio n. 15
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (conn.State == ConnectionState.Open)
     {
         conn.Close();
     }
     conn.Open();
     txt_fee_code.Attributes.Add("readonly", "readonly");
     btn_ftype_add.Style.Add("background-color", Session["ColorTheme"].ToString());
     txt_fee_code.Text = Global_Class.GenerateID("select count(*) from FEETYPEFILE where school_code ='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/FEE/");
 }
Esempio n. 16
0
        //void autogenerated()
        //{
        //    string str = "select count(*) from VEHICLE where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'";
        //    SqlCommand com = new SqlCommand(str, conn);
        //    int count = Convert.ToInt16(com.ExecuteScalar()) + 1;
        //    txt_vechileid.Text = "VECL - 0" + count.ToString();
        //}

        protected void crt_vehicle(object sender, EventArgs e)
        {
            try {
                string str = "insert into VEHICLE (ID,VEHICLE_NO,VEHICLE_TYPE,SEAT_CAPACITY,school_code,branch) values('" + txt_vechileid.Text + "','" + txt_vechile_no.Text + "','" + vechile_type.SelectedItem.Text.ToString() + "','" + txt_seat_capacity.Text + "','" + Session["schoolcode"].ToString() + "','" + Session["Branch"].ToString() + "')";

                SqlCommand cmd = new SqlCommand(str, conn);
                cmd.ExecuteNonQuery();
                ShowMessage("Vehicle Created");
                txt_vechileid.Text = Global_Class.GenerateID("select count(*) from VEHICLE where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/VECL/");
            }
            catch (Exception ex) { ex.ToString(); }
        }
Esempio n. 17
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         txt_id.Attributes.Add("readonly", "readonly");
         txt_sub_id.Attributes.Add("readonly", "readonly");
         txt_cat.Focus();
         txt_id.Text     = Global_Class.GenerateID("select count(*) from tbl_BookCategory where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/CAT/");
         txt_sub_id.Text = Global_Class.GenerateID("select count(*) from tbl_BookSubCategory where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/SUBCAT/");
         fillcategory();
         FillCatGrid();
         FillSubCatGrid();
     }
 }
Esempio n. 18
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                }

                txt_stram_code.Attributes.Add("readonly", "readonly");
                btn_add_stream.Style.Add("background-color", Session["ColorTheme"].ToString());
                txt_stram_code.Text = Global_Class.GenerateID("select count(*) from STREAMLIST where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/STREAM/");
            }
        }
Esempio n. 19
0
 protected void btn_save_Click(object sender, EventArgs e)
 {
     try {
         foreach (RepeaterItem item in rptCustomers.Items)
         {
             string room_name     = (item.FindControl("txt_name") as TextBox).Text;
             string amnties       = (item.FindControl("amnties_list") as DropDownList).SelectedItem.ToString();
             string type          = (item.FindControl("list_type") as DropDownList).SelectedItem.ToString();
             string st_no         = (item.FindControl("list_no_st") as DropDownList).SelectedItem.ToString();
             string building_name = building_list.SelectedItem.ToString();
             string entry_by      = Session["uname"].ToString();
             string entry_dt      = System.DateTime.Now.ToString();
             string mac           = Global_Class.getFormatMac(Global_Class.GetMACAddress()).ToString();
             SaveData(room_name, amnties, type, st_no, building_name, entry_by, entry_dt, mac);
         }
     }
     catch (Exception ex) { ex.ToString(); }
 }
Esempio n. 20
0
        protected void btn_Cat_Click(object sender, EventArgs e)
        {
            try {
                SqlCommand     cmd  = new SqlCommand("select * from tbl_BookCategory where cat_name='" + txt_cat.Text + "' and school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", conn);
                SqlDataAdapter adpt = new SqlDataAdapter(cmd);
                DataSet        ds   = new DataSet();
                adpt.Fill(ds);
                int i = ds.Tables[0].Rows.Count;

                if (i > 0)
                {
                    ShowMessage("This category is already exists.");
                    ds.Clear();
                }
                else
                {
                    cmd             = new SqlCommand();
                    cmd.CommandType = CommandType.Text;
                    cmd.CommandText = "insert into tbl_BookCategory " +
                                      "(cat_id,cat_name,cat_val,entry_dt,entry_by,mac_id,school_code,branch) " +
                                      "values('" + Global_Class.GenerateID("select count(*) from tbl_BookCategory where " +
                                                                           "school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/CAT/").ToString() + "'," +
                                      "'" + txt_cat.Text + "','" + Global_Class.Drp_val_gen("select count(*) from tbl_BookCategory where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", 0).ToString() + "','" + DateTime.Now.ToString("dd/MM/yyyy") + "','" + Session["uname"] + "','" + Global_Class.getFormatMac(Global_Class.GetMACAddress()) + "','" + Session["schoolcode"].ToString() + "','" + Session["Branch"].ToString() + "') ";
                    cmd.Connection = conn;
                    if (conn.State == ConnectionState.Open)
                    {
                        conn.Close();
                    }
                    conn.Open();
                    cmd.ExecuteNonQuery();
                    ShowMessage("Category saved.");
                    txt_id.Text     = Global_Class.GenerateID("select count(*) from tbl_BookCategory where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/CAT/");
                    txt_sub_id.Text = Global_Class.GenerateID("select count(*) from tbl_BookSubCategory where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/SUBCAT/");

                    fillcategory();
                    FillCatGrid();
                    FillSubCatGrid();
                    txt_cat.Text     = String.Empty;
                    txt_sub_cat.Text = String.Empty;
                }
            }
            catch (Exception ex) { ex.ToString(); }
        }
Esempio n. 21
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         if (conn.State == ConnectionState.Open)
         {
             conn.Close();
         }
         conn.Open();
         txt_dob.Attributes.Add("readonly", "readonly");
         txt_std_id.Attributes.Add("readonly", "readonly");
         txt_doa.Attributes.Add("readonly", "readonly");
         txt_sc_branch.Attributes.Add("readonly", "readonly");
         txt_session.Attributes.Add("readonly", "readonly");
         txt_session.Text   = DateTime.Now.Year.ToString() + " - " + (DateTime.Now.Year + 1).ToString();
         txt_sc_branch.Text = Session["Branch"].ToString();
         //autogenerated();
         fillCountry();
         fillclass();
     }
     txt_std_id.Text = Global_Class.GenerateID("select count(*) from ST_PROFILE where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/ST/");
 }
Esempio n. 22
0
        protected void btn_class_add_Click(object sender, EventArgs e)
        {
            try {
                SqlCommand CheckSub = new SqlCommand();
                CheckSub.Connection  = conn;
                CheckSub.CommandType = CommandType.Text;
                CheckSub.CommandText = "SELECT COUNT(*) FROM CLASSFILE WHERE CLASSNAME = '" + txt_class_name.Text + "' and  school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "' ";
                int SubExists = (int)CheckSub.ExecuteScalar();

                if (SubExists > 0)
                {
                    ShowMessage("This class is already exists.");
                }
                else
                {
                    if (int.Parse(txt_class_name.Text) > 12)
                    {
                        ShowMessage("This class is not valid.");
                        txt_class_name.Text = "";
                    }
                    else
                    {
                        SqlCommand cmd = new SqlCommand();
                        cmd.Connection  = conn;
                        cmd.CommandType = CommandType.Text;
                        cmd.CommandText = "insert into CLASSFILE" +
                                          " (CLASSCODE,CLASSNAME,CLASS_VAL,school_code,branch)" +
                                          " VALUES('" + txt_class_code.Text + "','" + txt_class_name.Text + "','" + Global_Class.Drp_val_gen("select count(*) from CLASSFILE where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", 0).ToString() + "','" + Session["schoolcode"].ToString() + "','" + Session["Branch"].ToString() + "')";
                        cmd.ExecuteNonQuery();
                        ShowMessage("Recorded To The System Successfully");
                        txt_class_code.Text = Global_Class.GenerateID("select count(*) from CLASSFILE where  school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/CLS/");
                        txt_class_name.Text = "";
                    }
                }
            }
            catch (Exception ex) { ex.ToString(); }
        }
Esempio n. 23
0
 protected void Unnamed11_Click(object sender, EventArgs e)
 {
     try {
         conn.Open();
         SqlCommand cmd = new SqlCommand("BOOK_ENTRY", conn);
         cmd.CommandType = CommandType.StoredProcedure;
         cmd.Parameters.Add("@BOOKID", SqlDbType.VarChar, 50).Value           = txt_book_id.Text.ToString();
         cmd.Parameters.Add("@BOOKNAME", SqlDbType.VarChar, 50).Value         = txt_book_name.Text.ToString();
         cmd.Parameters.Add("@AUTHOR", SqlDbType.VarChar, 50).Value           = txt_author.Text.ToString();
         cmd.Parameters.Add("@ISBN", SqlDbType.VarChar, 50).Value             = txt_isbn.Text.ToString();
         cmd.Parameters.Add("@PRICE", SqlDbType.VarChar, 50).Value            = txt_price.Text.ToString();
         cmd.Parameters.Add("@QUANTITY", SqlDbType.VarChar, 50).Value         = txt_book_quantity.Text.ToString();
         cmd.Parameters.Add("@CATEGORY", SqlDbType.VarChar, 50).Value         = drp_cat.SelectedItem.Text.ToString();
         cmd.Parameters.Add("@SUBCATEGORY", SqlDbType.VarChar, 50).Value      = drp_sub_cat.SelectedItem.Text.ToString();
         cmd.Parameters.Add("@SUBCATEGORYVALUE", SqlDbType.VarChar, 50).Value = drp_sub_cat.SelectedValue.ToString();
         cmd.Parameters.Add("@PURCHASEDATE", SqlDbType.VarChar, 50).Value     = pur_date.Text.ToString();
         cmd.Parameters.Add("@PUBLISHDATE", SqlDbType.VarChar, 50).Value      = pub_date.Text.ToString();
         cmd.Parameters.Add("@LANGUAGE", SqlDbType.VarChar, 50).Value         = txt_lang.Text.ToString();
         cmd.Parameters.Add("@ENTRYDATE", SqlDbType.VarChar, 50).Value        = DateTime.Now.ToString("dd/MM/yyyy");
         cmd.Parameters.Add("@ENTRYBY", SqlDbType.VarChar, 50).Value          = Session["uname"].ToString();
         cmd.Parameters.Add("MACADDRESS", SqlDbType.VarChar, 50).Value        = Global_Class.getFormatMac(Global_Class.GetMACAddress()).ToString();
         cmd.Parameters.Add("@school_code", SqlDbType.VarChar, 100).Value     = Session["schoolcode"].ToString();
         cmd.Parameters.Add("branch", SqlDbType.VarChar, 100).Value           = Session["Branch"].ToString();
         cmd.ExecuteNonQuery();
         ShowMessage("Added Successfully");
         conn.Close();
     }
     catch (Exception ex) { ex.ToString(); }
 }
Esempio n. 24
0
        protected void btn_Signup_Click(object sender, EventArgs e)
        {
            String crntdt = DateTime.Now.ToString("dd/MM/yyyy");

            enddt = DateTime.Now.AddDays(7);
            String en_Dt = enddt.ToString("dd/MM/yyyy");

            DateTime idt  = DateTime.ParseExact(crntdt, "dd/MM/yyyy", null);
            DateTime rdt  = DateTime.ParseExact(en_Dt, "dd/MM/yyyy", null);
            TimeSpan span = rdt - idt;

            SqlCommand Chk = new SqlCommand("select * from tbl_TrialUsers where mobile='" + txt_mobile.Text + "'", conn);

            Chk.Connection = conn;
            if (conn.State == ConnectionState.Open)
            {
                conn.Close();
            }
            conn.Open();
            int i = Convert.ToInt32(Chk.ExecuteScalar());

            if (i > 0)
            {
                ShowMessage("This mobile number is already exist.");
            }
            else
            {
                String     str    = @"insert into tbl_TrialUsers
                         (user_name,password,mobile,email,sch_name,city,branch,sign_dt,end_dt,day_cnt,mac,ip,school_code) 
                         values('" + txt_name.Text + "','" + txt_pswd.Text + "','" + txt_mobile.Text + "','" + txt_email.Text + "','" + txt_sch.Text + "','" + txt_city.Text + "','" + txt_branch.Text + "','" + crntdt.ToString() + "','" + en_Dt.ToString() + "','" + span.TotalDays.ToString() + "','" + Global_Class.getFormatMac(Global_Class.GetMACAddress()).ToString() + "','" + GetIP().ToString() + "','" + GenID().ToString() + "')";
                SqlCommand Signup = new SqlCommand();
                Signup.Connection = conn;
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                }
                conn.Open();
                Signup.CommandType = CommandType.Text;
                Signup.CommandText = str;
                try
                {
                    Signup.ExecuteNonQuery();
                    ShowMessage("Thank you for choosing us. Your 7 Trial has been started.");
                    txt_branch.Text = txt_city.Text = txt_email.Text = txt_mobile.Text = txt_name.Text = txt_pswd.Text = txt_sch.Text = String.Empty;
                }
                catch (Exception ex)
                {
                    Response.Write(ex.ToString());
                }
                finally
                {
                    Signup.Dispose();
                }
            }
        }