C# (CSharp) Pos_CardBank Examples

Example #1

File: Pos_CardBankManager.cs Project: anam/gp-HO

 public static Pos_CardBank GetPos_CardBankByID(int id)
 {
     Pos_CardBank pos_CardBank = new Pos_CardBank();
     SqlPos_CardBankProvider sqlPos_CardBankProvider = new SqlPos_CardBankProvider();
     pos_CardBank = sqlPos_CardBankProvider.GetPos_CardBankByID(id);
     return pos_CardBank;
 }

Example #2

    public static Pos_CardBank GetPos_CardBankByID(int id)
    {
        Pos_CardBank            pos_CardBank            = new Pos_CardBank();
        SqlPos_CardBankProvider sqlPos_CardBankProvider = new SqlPos_CardBankProvider();

        pos_CardBank = sqlPos_CardBankProvider.GetPos_CardBankByID(id);
        return(pos_CardBank);
    }

Example #3

File: AdminPos_CardBankInsertUpdate.aspx.cs Project: anam/gp-HO

    protected void btnAdd_Click(object sender, EventArgs e)
    {
        Pos_CardBank pos_CardBank = new Pos_CardBank();

        pos_CardBank.BankName = txtBankName.Text;
        pos_CardBank.Details = txtDetails.Text;
        pos_CardBank.CharOfAccountLabel4ID = Int32.Parse(ddlCharOfAccountLabel4.SelectedValue);
        int resutl = Pos_CardBankManager.InsertPos_CardBank(pos_CardBank);
        Response.Redirect("AdminPos_CardBankDisplay.aspx");
    }

Example #4

    private void showPos_CardBankData()
    {
        Pos_CardBank pos_CardBank = new Pos_CardBank();

        pos_CardBank = Pos_CardBankManager.GetPos_CardBankByID(Int32.Parse(Request.QueryString["pos_CardBankID"]));

        txtBankName.Text = pos_CardBank.BankName;
        txtDetails.Text  = pos_CardBank.Details;
        ddlCharOfAccountLabel4.SelectedValue = pos_CardBank.CharOfAccountLabel4ID.ToString();
    }

Example #5

    protected void btnAdd_Click(object sender, EventArgs e)
    {
        Pos_CardBank pos_CardBank = new Pos_CardBank();

        pos_CardBank.BankName = txtBankName.Text;
        pos_CardBank.Details  = txtDetails.Text;
        pos_CardBank.CharOfAccountLabel4ID = Int32.Parse(ddlCharOfAccountLabel4.SelectedValue);
        int resutl = Pos_CardBankManager.InsertPos_CardBank(pos_CardBank);

        Response.Redirect("AdminPos_CardBankDisplay.aspx");
    }

Example #6

File: AdminPos_CardBankInsertUpdate.aspx.cs Project: anam/gp-HO

    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        Pos_CardBank pos_CardBank = new Pos_CardBank();
        pos_CardBank = Pos_CardBankManager.GetPos_CardBankByID(Int32.Parse(Request.QueryString["pos_CardBankID"]));
        Pos_CardBank tempPos_CardBank = new Pos_CardBank();
        tempPos_CardBank.Pos_CardBankID = pos_CardBank.Pos_CardBankID;

        tempPos_CardBank.BankName = txtBankName.Text;
        tempPos_CardBank.Details = txtDetails.Text;
        tempPos_CardBank.CharOfAccountLabel4ID = Int32.Parse(ddlCharOfAccountLabel4.SelectedValue);
        bool result = Pos_CardBankManager.UpdatePos_CardBank(tempPos_CardBank);
        Response.Redirect("AdminPos_CardBankDisplay.aspx");
    }

Example #7

    public int InsertPos_CardBank(Pos_CardBank pos_CardBank)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("GP_InsertPos_CardBank", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@Pos_CardBankID", SqlDbType.Int).Direction    = ParameterDirection.Output;
            cmd.Parameters.Add("@BankName", SqlDbType.NVarChar).Value         = pos_CardBank.BankName;
            cmd.Parameters.Add("@Details", SqlDbType.NText).Value             = pos_CardBank.Details;
            cmd.Parameters.Add("@CharOfAccountLabel4ID", SqlDbType.Int).Value = pos_CardBank.CharOfAccountLabel4ID;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return((int)cmd.Parameters["@Pos_CardBankID"].Value);
        }
    }

Example #8

    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        Pos_CardBank pos_CardBank = new Pos_CardBank();

        pos_CardBank = Pos_CardBankManager.GetPos_CardBankByID(Int32.Parse(Request.QueryString["pos_CardBankID"]));
        Pos_CardBank tempPos_CardBank = new Pos_CardBank();

        tempPos_CardBank.Pos_CardBankID = pos_CardBank.Pos_CardBankID;

        tempPos_CardBank.BankName = txtBankName.Text;
        tempPos_CardBank.Details  = txtDetails.Text;
        tempPos_CardBank.CharOfAccountLabel4ID = Int32.Parse(ddlCharOfAccountLabel4.SelectedValue);
        bool result = Pos_CardBankManager.UpdatePos_CardBank(tempPos_CardBank);

        Response.Redirect("AdminPos_CardBankDisplay.aspx");
    }

Example #9

 public Pos_CardBank GetPos_CardBankFromReader(IDataReader reader)
 {
     try
     {
         Pos_CardBank pos_CardBank = new Pos_CardBank
                                     (
             (int)reader["Pos_CardBankID"],
             reader["BankName"].ToString(),
             reader["Details"].ToString(),
             (int)reader["CharOfAccountLabel4ID"]
                                     );
         return(pos_CardBank);
     }
     catch (Exception ex)
     {
         return(null);
     }
 }

Example #10

File: SqlPos_CardBankProvider.cs Project: anam/gp-HO

 public Pos_CardBank GetPos_CardBankFromReader(IDataReader reader)
 {
     try
     {
         Pos_CardBank pos_CardBank = new Pos_CardBank
             (
                 (int)reader["Pos_CardBankID"],
                 reader["BankName"].ToString(),
                 reader["Details"].ToString(),
                 (int)reader["CharOfAccountLabel4ID"]
             );
          return pos_CardBank;
     }
     catch(Exception ex)
     {
         return null;
     }
 }

Example #11

    public static bool UpdatePos_CardBank(Pos_CardBank pos_CardBank)
    {
        SqlPos_CardBankProvider sqlPos_CardBankProvider = new SqlPos_CardBankProvider();

        return(sqlPos_CardBankProvider.UpdatePos_CardBank(pos_CardBank));
    }

Example #12

    public static int InsertPos_CardBank(Pos_CardBank pos_CardBank)
    {
        SqlPos_CardBankProvider sqlPos_CardBankProvider = new SqlPos_CardBankProvider();

        return(sqlPos_CardBankProvider.InsertPos_CardBank(pos_CardBank));
    }

Example #13

File: AdminPos_CardBankInsertUpdate.aspx.cs Project: anam/gp-HO

    private void showPos_CardBankData()
    {
        Pos_CardBank pos_CardBank = new Pos_CardBank();
        pos_CardBank = Pos_CardBankManager.GetPos_CardBankByID(Int32.Parse(Request.QueryString["pos_CardBankID"]));

        txtBankName.Text = pos_CardBank.BankName;
        txtDetails.Text = pos_CardBank.Details;
        ddlCharOfAccountLabel4.SelectedValue = pos_CardBank.CharOfAccountLabel4ID.ToString();
    }

Example #14

File: SqlPos_CardBankProvider.cs Project: anam/gp-HO

    public bool UpdatePos_CardBank(Pos_CardBank pos_CardBank)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("GP_UpdatePos_CardBank", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@Pos_CardBankID", SqlDbType.Int).Value = pos_CardBank.Pos_CardBankID;
            cmd.Parameters.Add("@BankName", SqlDbType.NVarChar).Value = pos_CardBank.BankName;
            cmd.Parameters.Add("@Details", SqlDbType.NText).Value = pos_CardBank.Details;
            cmd.Parameters.Add("@CharOfAccountLabel4ID", SqlDbType.Int).Value = pos_CardBank.CharOfAccountLabel4ID;
            connection.Open();

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

Example #15

File: Pos_CardBankManager.cs Project: anam/gp-HO

 public static bool UpdatePos_CardBank(Pos_CardBank pos_CardBank)
 {
     SqlPos_CardBankProvider sqlPos_CardBankProvider = new SqlPos_CardBankProvider();
     return sqlPos_CardBankProvider.UpdatePos_CardBank(pos_CardBank);
 }

Example #16

File: Pos_CardBankManager.cs Project: anam/gp-HO

 public static int InsertPos_CardBank(Pos_CardBank pos_CardBank)
 {
     SqlPos_CardBankProvider sqlPos_CardBankProvider = new SqlPos_CardBankProvider();
     return sqlPos_CardBankProvider.InsertPos_CardBank(pos_CardBank);
 }