예제 #1
0
    public int AddRecord(EventMain1_IDBLL SPMI)
    {
        int           row;
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        DataSet       ds  = new DataSet();

        try
        {
            SqlParameter[] par = new SqlParameter[]
            {
                new SqlParameter("@ID", SPMI.ID1),
                new SqlParameter("@Sub_ID", SPMI.Sub_ID1),
                new SqlParameter("@Name", SPMI.Name1),
                new SqlParameter("@Description", SPMI.Description1),
                new SqlParameter("@User", SPMI.User1),
                new SqlParameter("@UserId", SPMI.UserId1)
            };
            SqlCommand cmd = new SqlCommand("EventMain_IDInsert", con);
            cmd.Parameters.AddRange(par);
            cmd.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            con.Open();
            row = cmd.ExecuteNonQuery();
            return(row);
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }
예제 #2
0
    public int AddrecordBLL(EventMain1_IDBLL objEMain1_IDBLL)
    {
        int i = objEMain1_IDDAL.AddRecord(objEMain1_IDBLL);

        return(i);
    }