public Hours Insert(Hours id)
 {
     string ConnectionString = IDManager.connection();
     SqlConnection con = new SqlConnection(ConnectionString);
     try
     {
     con.Open();
     SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_HOURS", con);
     cmd.CommandType = System.Data.CommandType.StoredProcedure;
     cmd.Parameters.AddWithValue("@Hours_Worked", id.Hours_Worked);
     cmd.ExecuteReader();
     con.Close();
     con.Open();
     cmd = new SqlCommand("SP_DMCS_GET_HOURS", con);
     cmd.CommandType = System.Data.CommandType.StoredProcedure;
     cmd.Parameters.AddWithValue("@Hours_Worked", id.Hours_Worked);
     SqlDataReader rdr = cmd.ExecuteReader();
     if (rdr.HasRows)
     {
         rdr.Read();
         id.Hours_ID = rdr.GetInt32(0);
     }
     }
     catch (Exception ex)
     {
     id.SetColumnDefaults();
     }
     finally
     {
     con.Close();
     }
     return id;
 }
 public Hours Delete_Hours_select(int ID)
 {
     Hours = Hours.Select(ID);
     Delete_Hours_ID_txt_lbl.Text = Convert.ToString(Hours.Hours_ID);
     Delete_Hours_Worked_txt_lbl.Text = Convert.ToString(Hours.Hours_Worked);
     return Hours;
 }
 public Hours Update_Hours_select(int ID)
 {
     Hours = Hours.Select(ID);
     Update_Hours_ID_txt.Text     = Convert.ToString(Hours.Hours_ID);
     Update_Hours_Worked_txt.Text = Convert.ToString(Hours.Hours_Worked);
     return(Hours);
 }
Exemplo n.º 4
0
        public Hours Insert(Hours id)
        {
            string        ConnectionString = IDManager.connection();
            SqlConnection con = new SqlConnection(ConnectionString);

            try
            {
                con.Open();
                SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_HOURS", con);
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@Hours_Worked", id.Hours_Worked);
                cmd.ExecuteReader();
                con.Close();
                con.Open();
                cmd             = new SqlCommand("SP_DMCS_GET_HOURS", con);
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@Hours_Worked", id.Hours_Worked);
                SqlDataReader rdr = cmd.ExecuteReader();
                if (rdr.HasRows)
                {
                    rdr.Read();
                    id.Hours_ID = rdr.GetInt32(0);
                }
            }
            catch (Exception ex)
            {
                id.SetColumnDefaults();
            }
            finally
            {
                con.Close();
            }
            return(id);
        }
Exemplo n.º 5
0
        public Boolean Update(Hours id)
        {
            string        ConnectionString = IDManager.connection();
            SqlConnection con = new SqlConnection(ConnectionString);

            try
            {
                con.Open();
                SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_HOURS", con);
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@Hours_ID", id.Hours_ID);
                cmd.Parameters.AddWithValue("@Hours_Worked", id.Hours_Worked);
                cmd.ExecuteReader();
                con.Close();
                return(true);
            }
            catch (Exception ex)
            {
                return(false);
            }
            finally
            {
                con.Close();
            }
        }
 public Hours Hours_insert()
 {
     Hours.Hours_Worked = Convert.ToInt32(Insert_Hours_Worked_txt.Text);
     Hours = Hours.Insert(Hours);
     Insert_Hours_GridView.DataBind();
     Update_Hours_GridView.DataBind();
     Delete_Hours_GridView.DataBind();
     return(Hours);
 }
 public Hours Hours_insert()
 {
     Hours.Hours_Worked = Convert.ToInt32(Insert_Hours_Worked_txt.Text);
     Hours = Hours.Insert(Hours);
     Insert_Hours_GridView.DataBind();
     Update_Hours_GridView.DataBind();
     Delete_Hours_GridView.DataBind();
     return Hours;
 }
 public Hours Hours_update(int ID)
 {
     Hours = Hours.Select(ID);
     Hours.Hours_ID = Convert.ToInt32(Update_Hours_ID_txt.Text);
     Hours.Hours_Worked = Convert.ToInt32(Update_Hours_Worked_txt.Text);
     Hours.Update(Hours);
     Insert_Hours_GridView.DataBind();
     Update_Hours_GridView.DataBind();
     Delete_Hours_GridView.DataBind();
     return Hours;
 }
 public Hours Hours_update(int ID)
 {
     Hours              = Hours.Select(ID);
     Hours.Hours_ID     = Convert.ToInt32(Update_Hours_ID_txt.Text);
     Hours.Hours_Worked = Convert.ToInt32(Update_Hours_Worked_txt.Text);
     Hours.Update(Hours);
     Insert_Hours_GridView.DataBind();
     Update_Hours_GridView.DataBind();
     Delete_Hours_GridView.DataBind();
     return(Hours);
 }
Exemplo n.º 10
0
        public Hours Select(int id)
        {
            Hours         Hours            = new Hours();
            string        ConnectionString = IDManager.connection();
            SqlConnection con = new SqlConnection(ConnectionString);

            try
            {
                con.Open();
                SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_HOURS", con);
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@Hours_ID", id);
                SqlDataReader rdr = cmd.ExecuteReader();
                if (rdr.HasRows)
                {
                    rdr.Read();
                    if (!rdr.IsDBNull(0))
                    {
                        Hours.Hours_ID = rdr.GetInt32(0);
                    }
                    else
                    {
                        Hours.Hours_ID = 0;
                    }
                    if (!rdr.IsDBNull(1))
                    {
                        Hours.Hours_Worked = rdr.GetInt32(1);
                    }
                    else
                    {
                        Hours.Hours_Worked = 0;
                    }
                }
                else
                {
                    Hours.SetColumnDefaults();
                }
            }
            catch (Exception ex)
            {
                Hours.SetColumnDefaults();
                return(Hours);
            }
            finally
            {
                con.Close();
            }
            return(Hours);
        }
 public Hours Insert_Hours_select(int ID)
 {
     Hours = Hours.Select(ID);
     Insert_Hours_Worked_txt.Text = Convert.ToString(Hours.Hours_Worked);
     return Hours;
 }
 public Boolean Update(Hours id)
 {
     string ConnectionString = IDManager.connection();
     SqlConnection con = new SqlConnection(ConnectionString);
     try
     {
     con.Open();
     SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_HOURS", con);
     cmd.CommandType = System.Data.CommandType.StoredProcedure;
     cmd.Parameters.AddWithValue("@Hours_ID", id.Hours_ID);
     cmd.Parameters.AddWithValue("@Hours_Worked", id.Hours_Worked);
     cmd.ExecuteReader();
     con.Close();
     return true;
     }
     catch (Exception ex)
     {
     return false;
     }
     finally
     {
     con.Close();
     }
 }
 /////////////////////////
 ////////////////////////
 ///////////////////////
 //////////////////////
 /////////////////////
 //Update Tab Methods
 protected void Update_Select_Record(object sender, EventArgs e)
 {
     Hours = Update_Hours_select(Convert.ToInt32(Update_Hours_GridView.SelectedValue));
 }
 protected void UPDATE(object sender, EventArgs e)
 {
     Hours = Hours_update(Convert.ToInt32(Update_Hours_GridView.SelectedValue));
 }
 /////////////////////////
 ////////////////////////
 ///////////////////////
 //////////////////////
 /////////////////////
 //Insert Tab Methods
 protected void Insert_Select_Record(object sender, EventArgs e)
 {
     Hours = Insert_Hours_select(Convert.ToInt32(Insert_Hours_GridView.SelectedValue));
 }
 protected void INSERT(object sender, EventArgs e)
 {
     Hours = Hours_insert();
 }
 public Hours Select(int id)
 {
     Hours Hours = new Hours();
     string ConnectionString = IDManager.connection();
     SqlConnection con = new SqlConnection(ConnectionString);
     try
     {
     con.Open();
     SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_HOURS", con);
     cmd.CommandType = System.Data.CommandType.StoredProcedure;
     cmd.Parameters.AddWithValue("@Hours_ID", id);
     SqlDataReader rdr = cmd.ExecuteReader();
     if (rdr.HasRows)
     {
         rdr.Read();
         if (!rdr.IsDBNull(0))
         {
             Hours.Hours_ID = rdr.GetInt32(0);
         }
         else
         {
             Hours.Hours_ID = 0;
         }
         if (!rdr.IsDBNull(1))
         {
             Hours.Hours_Worked = rdr.GetInt32(1);
         }
         else
         {
             Hours.Hours_Worked = 0;
         }
         }
         else
         {
             Hours.SetColumnDefaults();
         }
     }
     catch (Exception ex)
     {
     Hours.SetColumnDefaults();
     return Hours;
     }
     finally
     {
     con.Close();
     }
     return Hours;
 }
 /////////////////////////
 ////////////////////////
 ///////////////////////
 //////////////////////
 /////////////////////
 //Update Tab Methods
 protected void Update_Select_Record(object sender, EventArgs e)
 {
     Hours = Update_Hours_select(Convert.ToInt32(Update_Hours_GridView.SelectedValue));
 }
 protected void INSERT(object sender, EventArgs e)
 {
     Hours = Hours_insert();
 }
 public Hours Insert_Hours_select(int ID)
 {
     Hours = Hours.Select(ID);
     Insert_Hours_Worked_txt.Text = Convert.ToString(Hours.Hours_Worked);
     return(Hours);
 }
 /////////////////////////
 ////////////////////////
 ///////////////////////
 //////////////////////
 /////////////////////
 //Insert Tab Methods
 protected void Insert_Select_Record(object sender, EventArgs e)
 {
     Hours = Insert_Hours_select(Convert.ToInt32(Insert_Hours_GridView.SelectedValue));
 }
 protected void UPDATE(object sender, EventArgs e)
 {
     Hours = Hours_update(Convert.ToInt32(Update_Hours_GridView.SelectedValue));
 }