Пример #1
0
        public int Create_Customers_ClassName(MPanelDTO MClass)
        {
            SqlCommand cmd = new SqlCommand();

            cmd.Connection  = conn;
            cmd.CommandText = "[Adobe].[SP_Insert_Customers_ClassName]";
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.AddWithValue("@CustomerId", MClass.Customers_ClassName_CustomerId);
            cmd.Parameters.AddWithValue("@Name", MClass.Customers_ClassName_Name);
            cmd.Parameters.AddWithValue("@NameLatin", MClass.Customers_ClassName_NameLatin);
            cmd.Parameters.AddWithValue("@UserCount", MClass.Customers_ClassName_UserCount);
            cmd.Parameters.AddWithValue("@SessionCount", MClass.Customers_ClassName_SessionCount);
            cmd.Parameters.AddWithValue("@DateStart", MClass.Customers_ClassName_DateStart);
            cmd.Parameters.AddWithValue("@DateEnd", MClass.Customers_ClassName_DateEnd);
            cmd.Parameters.AddWithValue("@ScoId", MClass.Customers_ClassName_ScoId);
            cmd.Parameters.AddWithValue("@ServerName", MClass.Customers_ClassName_ServerName);
            cmd.Parameters.AddWithValue("@MeetingAccess", MClass.Customers_ClassName_MeetingAccess);

            if (conn.State != System.Data.ConnectionState.Open)
            {
                conn.Open();
            }
            int modified = (int)cmd.ExecuteScalar();

            if (conn.State == System.Data.ConnectionState.Open)
            {
                conn.Close();
            }

            cmd.Connection.Close();
            cmd.Dispose();

            return(modified);
        }
 public int Create_Customers_ClassName(MPanelDTO MClass)
 {
     return(MpDAO.Create_Customers_ClassName(MClass));
 }