Employee Database Management System - Project Based Training on Latest Software Versions

Language

Database

IDE

Video on this Code

Framework Classes

Code Sample

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace EmployeeData
{
    public partial class CreateEmpData : System.Web.UI.Page
    {
        private int CallCreateEmpData(String strEmpEmail)
        {
            using (SqlConnection con = new SqlConnection(CConstants.ConnString))
            {
                con.Open();
                using (SqlCommand cmd = con.CreateCommand())
                {
                    cmd.CommandText = "spUMCreateEmpData";
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;

                    cmd.Parameters.AddWithValue("@EmpEmail", strEmpEmail);
                    
                    cmd.Parameters.Add(new SqlParameter()
                    {
                        ParameterName = "@Ret",
                        Direction = System.Data.ParameterDirection.Output,
                        SqlDbType = System.Data.SqlDbType.Int
                    });
                    cmd.ExecuteNonQuery();
                    int iResult = Convert.ToInt32(cmd.Parameters["@Ret"].Value);
                    return iResult;
                }
            }
        }



        protected void Page_Load(object sender, EventArgs e)
        {
            UnobtrusiveValidationMode = UnobtrusiveValidationMode.None;
        }

        protected void lnkCreateEmpPro_Click(object sender, EventArgs e)
        {
            if (!fuPhoto.HasFile)
            {
                lblMessage.Text = "Please upload a Picture.";
                return;
            }

            StringBuilder sbITKnowledge = new StringBuilder();
            foreach (ListItem li in chkITKnowledge.Items)
            {
                if (li.Selected)
                {
                    sbITKnowledge.AppendFormat("{0};", li.Value);
                }
            }

            sqdCreateEmpData.InsertParameters["ITKnowledge"].DefaultValue
                = sbITKnowledge.ToString();
          
            int i = sqdCreateEmpData.Insert();
            if (i < 0)
            {
                lblMessage.Text = "Employee already Added.";
                return;
            }
            

            else
            {
                fuPhoto.SaveAs(Server.MapPath(@"~/Images/") + txtEmpEmail.Text);
                lblMessage.Text = "Profile Created";
            }
            txtEmpEmail.Text = "";
            txtEmpName.Text = "";
            txtEmpPhone.Text = "";
            txtEmpAddress.Text = "";

            ddlAge.SelectedIndex = 0;
            chkExp.Checked = false;

            foreach (ListItem li in chkITKnowledge.Items)
            {
                li.Selected = false;
            }
        }
    }
}

Useful Links