Exemplo n.º 1
0
    public static SectionLabel GetSectionLabelByID(int id)
    {
        SectionLabel            sectionLabel            = new SectionLabel();
        SqlSectionLabelProvider sqlSectionLabelProvider = new SqlSectionLabelProvider();

        sectionLabel = sqlSectionLabelProvider.GetSectionLabelByID(id);
        return(sectionLabel);
    }
Exemplo n.º 2
0
    private void showSectionLabelData(int id)
    {
        SectionLabel sectionLabel = new SectionLabel();

        sectionLabel = SectionLabelManager.GetSectionLabelByID(id);

        txtSectionNo.Text   = sectionLabel.SectionNo.ToString();
        txtLabelText.Text   = sectionLabel.LabelText;
        txtExtraField1.Text = sectionLabel.ExtraField1;
        txtExtraField2.Text = sectionLabel.ExtraField2;
        txtExtraField3.Text = sectionLabel.ExtraField3;
        txtExtraField4.Text = sectionLabel.ExtraField4;
        txtExtraField5.Text = sectionLabel.ExtraField5;
    }
    private void showSectionLabelData()
    {
        SectionLabel sectionLabel = new SectionLabel();

        sectionLabel = SectionLabelManager.GetSectionLabelByID(Int32.Parse(Request.QueryString["sectionLabelID"]));

        txtSectionNo.Text   = sectionLabel.SectionNo.ToString();
        txtLabelText.Text   = sectionLabel.LabelText;
        txtExtraField1.Text = sectionLabel.ExtraField1;
        txtExtraField2.Text = sectionLabel.ExtraField2;
        txtExtraField3.Text = sectionLabel.ExtraField3;
        txtExtraField4.Text = sectionLabel.ExtraField4;
        txtExtraField5.Text = sectionLabel.ExtraField5;
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        SectionLabel sectionLabel = new SectionLabel();

        sectionLabel.SectionNo   = Int32.Parse(txtSectionNo.Text);
        sectionLabel.LabelText   = txtLabelText.Text;
        sectionLabel.ExtraField1 = txtExtraField1.Text;
        sectionLabel.ExtraField2 = txtExtraField2.Text;
        sectionLabel.ExtraField3 = txtExtraField3.Text;
        sectionLabel.ExtraField4 = txtExtraField4.Text;
        sectionLabel.ExtraField5 = txtExtraField5.Text;
        int resutl = SectionLabelManager.InsertSectionLabel(sectionLabel);

        Response.Redirect("AdminSectionLabelDisplay.aspx");
    }
Exemplo n.º 5
0
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        SectionLabel sectionLabel = new SectionLabel();

        sectionLabel.SectionNo   = Int32.Parse(txtSectionNo.Text);
        sectionLabel.LabelText   = txtLabelText.Text;
        sectionLabel.ExtraField1 = txtExtraField1.Text;
        sectionLabel.ExtraField2 = txtExtraField2.Text;
        sectionLabel.ExtraField3 = txtExtraField3.Text;
        sectionLabel.ExtraField4 = txtExtraField4.Text;
        sectionLabel.ExtraField5 = txtExtraField5.Text;
        int resutl = SectionLabelManager.InsertSectionLabel(sectionLabel);

        showSectionLabelGrid();
    }
Exemplo n.º 6
0
    public bool UpdateSectionLabel(SectionLabel sectionLabel)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("AL_UpdateSectionLabel", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@SectionLabelID", SqlDbType.Int).Value   = sectionLabel.SectionLabelID;
            cmd.Parameters.Add("@SectionNo", SqlDbType.Int).Value        = sectionLabel.SectionNo;
            cmd.Parameters.Add("@LabelText", SqlDbType.NVarChar).Value   = sectionLabel.LabelText;
            cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = sectionLabel.ExtraField1;
            cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = sectionLabel.ExtraField2;
            cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = sectionLabel.ExtraField3;
            cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = sectionLabel.ExtraField4;
            cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = sectionLabel.ExtraField5;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return(result == 1);
        }
    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        SectionLabel sectionLabel = new SectionLabel();

        sectionLabel = SectionLabelManager.GetSectionLabelByID(Int32.Parse(Request.QueryString["sectionLabelID"]));
        SectionLabel tempSectionLabel = new SectionLabel();

        tempSectionLabel.SectionLabelID = sectionLabel.SectionLabelID;

        tempSectionLabel.SectionNo   = Int32.Parse(txtSectionNo.Text);
        tempSectionLabel.LabelText   = txtLabelText.Text;
        tempSectionLabel.ExtraField1 = txtExtraField1.Text;
        tempSectionLabel.ExtraField2 = txtExtraField2.Text;
        tempSectionLabel.ExtraField3 = txtExtraField3.Text;
        tempSectionLabel.ExtraField4 = txtExtraField4.Text;
        tempSectionLabel.ExtraField5 = txtExtraField5.Text;
        bool result = SectionLabelManager.UpdateSectionLabel(tempSectionLabel);

        Response.Redirect("AdminSectionLabelDisplay.aspx");
    }
Exemplo n.º 8
0
 public SectionLabel GetSectionLabelFromReader(IDataReader reader)
 {
     try
     {
         SectionLabel sectionLabel = new SectionLabel
                                     (
             (int)reader["SectionLabelID"],
             (int)reader["SectionNo"],
             reader["LabelText"].ToString(),
             reader["ExtraField1"].ToString(),
             reader["ExtraField2"].ToString(),
             reader["ExtraField3"].ToString(),
             reader["ExtraField4"].ToString(),
             reader["ExtraField5"].ToString()
                                     );
         return(sectionLabel);
     }
     catch (Exception ex)
     {
         return(null);
     }
 }
Exemplo n.º 9
0
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        SectionLabel tempSectionLabel = new SectionLabel();

        tempSectionLabel.SectionNo   = Int32.Parse(txtSectionNo.Text);
        tempSectionLabel.LabelText   = txtLabelText.Text;
        tempSectionLabel.ExtraField1 = txtExtraField1.Text;
        tempSectionLabel.ExtraField2 = txtExtraField2.Text;
        tempSectionLabel.ExtraField3 = txtExtraField3.Text;
        tempSectionLabel.ExtraField4 = txtExtraField4.Text;
        tempSectionLabel.ExtraField5 = txtExtraField5.Text;
        if (hfID.Value != "0")
        {
            tempSectionLabel.SectionLabelID = int.Parse(hfID.Value);
            SectionLabelManager.UpdateSectionLabel(tempSectionLabel);
        }
        else
        {
            SectionLabelManager.InsertSectionLabel(tempSectionLabel);
        }
        showSectionLabelGrid();
        Clear_Click();
    }
Exemplo n.º 10
0
    public static bool UpdateSectionLabel(SectionLabel sectionLabel)
    {
        SqlSectionLabelProvider sqlSectionLabelProvider = new SqlSectionLabelProvider();

        return(sqlSectionLabelProvider.UpdateSectionLabel(sectionLabel));
    }
Exemplo n.º 11
0
    public static int InsertSectionLabel(SectionLabel sectionLabel)
    {
        SqlSectionLabelProvider sqlSectionLabelProvider = new SqlSectionLabelProvider();

        return(sqlSectionLabelProvider.InsertSectionLabel(sectionLabel));
    }
Exemplo n.º 12
0
 void Awake()
 {
     sectionLabel = this;
 }
Exemplo n.º 13
0
 public SectionLabel GetSectionLabelFromReader(IDataReader reader)
 {
     try
     {
         SectionLabel sectionLabel = new SectionLabel
             (
                 (int)reader["SectionLabelID"],
                 (int)reader["SectionNo"],
                 reader["LabelText"].ToString(),
                 reader["ExtraField1"].ToString(),
                 reader["ExtraField2"].ToString(),
                 reader["ExtraField3"].ToString(),
                 reader["ExtraField4"].ToString(),
                 reader["ExtraField5"].ToString()
             );
          return sectionLabel;
     }
     catch(Exception ex)
     {
         return null;
     }
 }
Exemplo n.º 14
0
    public bool UpdateSectionLabel(SectionLabel sectionLabel)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("AL_UpdateSectionLabel", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@SectionLabelID", SqlDbType.Int).Value = sectionLabel.SectionLabelID;
            cmd.Parameters.Add("@SectionNo", SqlDbType.Int).Value = sectionLabel.SectionNo;
            cmd.Parameters.Add("@LabelText", SqlDbType.NVarChar).Value = sectionLabel.LabelText;
            cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = sectionLabel.ExtraField1;
            cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = sectionLabel.ExtraField2;
            cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = sectionLabel.ExtraField3;
            cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = sectionLabel.ExtraField4;
            cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = sectionLabel.ExtraField5;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return result == 1;
        }
    }